I’m trying to use the Bubble API Connector to connect to Zoho reports, to pull a sample export of User information.
I’ve included my authtoken in the GET string, since it didn’t seem to work elsewhere.
In any case, the result I’m getting is that each letter of each value returned is being interpreted as its own column.
The user table only has 26 records in it, and the table in Zoho Reports looks like this (this comes right from a Bubble export):
What am I doing wrong here?
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 closed to what i’d expect: