API Connector - Initialize is working but then returns no data

[ayman326]

Hi everyone,

I’m using the external API connector, which up until today has worked great.

I set up my JSON and dynamic values as I have been. I initialize it, which goes through and reports back the correct data, and then I click “Save”.

I activate the API in my workflow, select my dynamic inputs, then I make changes to a user based on the results of the API call.

Then when I try to run this workflow in my app the result of the API call keeps returning empty. You can see in the screenshots below that valid inputs are going into the API but it keeps not returning any data.

Thank you for anyone looking into my issue! I would love any help you can offer to help me figure out why this is happening and how I can fix it.

Things I have tried that have not worked

• deleted API call and remade it
• made dynamic values in the workflow arbitrary texts
• having dynamic values empty when reinitializing
• having dynamic values private so it is the exact same input going in during initialization and actually running it

[Jici]

Can yo activate capture response header and activate include erros in response?
You will need to reinitialize the call and set your fields again
Run it in debug mode, and share the result of raw body

Also, in logs, please share the request that is sent?
What happen if you put the exact same value/request into API connector?

[ayman326]

Thank you for the reply! I activated the two checkmarks you said, I made the values in api connector the same as the requests when it runs, and I reinitialized.

The body (where the data is properly formatted) is still empty, but you are right the data is now showing up in the raw body text. That is good to see, do you know what I should do next to pull this data from each of the fields?

Here is the logs when request is sent.

[Jici]

So here’s the issue:
your json will never be the same because it return a dictionnaries of data for company using the company name as key (in the raw payload, it’s Test 1). This is not something you can use directly with API Connector.

Am I wrong to say that you have created a function so maybe you can modify the JSON returned?

[ayman326]

I guess it is a function in that it reports different data based on the inputs the user feeds it. Do you know how I can draw out specific data from the JSON returned, I’ve never done something like that before? Now I can see the info I want in the raw body text but I don’t know how I can extract each “id” value within it.

[Jici]

So you don’t have access to the function script?

There’s some solutions
A) Use this plugin to convert the dictionnary into something Bubble can work with

Templates for Bubble

B) Detect the JSON as text instead in API connector and use one of the JSON tool plugin available

C) Use a third party tool that could work with this kind of JSON like make.com

D) Use regex

[ayman326]

I used regex to extract the field I needed from the raw text and it worked!

Thanks for all of the help @Jici, couldn’t have done it without you!