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):
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.
It tends to do that when you tell it that it should be Jason but isn’t. Maybe you are getting an XML error… And it is being read as JSON. Trying changing the drop down.
Our XML support isn’t great, which probably explains that issue, not sure we can fix this easily, but it would be helpful to share a link with the community
The raw response of your call isn’t a JSON, it’s a text. So if you make it text it will work. Unfortunately we don’t support lists of texts, so this will be returned as a plain text. But you can probably use some utilities service like Blockspring to parse it into a list of texts.