GET XML via API to Bubble only getting 1 column

GET XML via API to Bubble only getting 1 column

Good Afternoon, 

I'm trying to GET data from Zoho Reports using the Bubble development API.
The results I'm getting are getting stuck at the first column



Here's how I've set up the Bubble API connector to Zoho Reports:

The rest of the parameters are:
ZOHO_ACTION = EXPORT
ZOHO_OUTPUT_FORMAT = JSON
ZOHO_ERROR_FORMAT = XML
ZOHO_API_VERSION = 1.0
ZOHO_DELIMITER = 2 (this sets the delimiter to a semicolon)



And finally, the Bubble results when I initialize the call:
You can see that columns 0, 1, 2, 3... spell out "(response..." referencing the JSON response from the server.



27,000 columns later, at the bottom of the response is the raw response, which is close to what i'd expect:



I've also tried  Using XML Data Type and output



yields this:



The raw output looks ok, but it's hung up on the first column when it parses the response