Passing JSON through API Connector

Need help APIs
21

Another type to try is Form-data

22

Finally got back to try this again. I switched to requestcatcher, to catch outputs, rather than pipedream. I copied the array output directly from requestcatcher, which contained two tabs in the array text, and put it in my workflow. From my experience, gaps like that have always tend to break things.

The problem with pipedream is that it deserialized and parsed, even when copying, whereas request catcher seemed to be plain text.

That did the trick though! lol, smh, tabs…

This is what worked
{ “PowerNumber”: “562800312”, “BondAmount”: 5000, “ExecutionDate”: “2023-08-10”, “State”: “WY”, “City”: “Gillette”, “DefendantFirstName”: “Rich”, “DefendantLastName”: “Snider”, “ExecutingAgentId”: 14455}

Thanks everyone for the help! Gotta love the Bubble community even though sometimes frustrations can be presented.

1 Like
23

I have to laugh even more so at how Bubbles forum just parsed the json in the comment I just posted and removed all of the tabs. :laughing:

1 Like
24

For anyone that may dealing with this issue, I had the same one and was checking bubbles logs and seeing the JSON data was formatted properly and the api connector would accept the calls with the same data. I finally checked the logs of the api I was sending requests to and noticed that bubble was adding a newline /n to every space I had causing the json to be unreadable. I solved the problem by removing all spaces and newlines in the format as text editor. It’s annoying because no one writes out their JSON this way naturally. Basically when using format as text, your JSON should be in a single line.

So the key points here is don’t depend fully on bubble’s logs because the call being made may not look exactly the same. To make your life easier always make sure you can inspect the raw data being sent in your api calls to debug properly, what works in the api connector will not always be a direct one for one when you are making a that same call from a workflow and lastly when using the format as text to create JSON keep it all in a single line.

2 Likes
25

Thank you so much i removed spaces and breaks, and it worked like magic after

1 Like