The API call returns a non-object and you picked JSON

andreg.diniz97 · March 22, 2021, 2:58pm

Hi guys,

I’m trying to use the “API connector” plugin, but it returns the error below:

I’m using these settings in the plugin:

I call the API through this link: https://api.bcb.gov.br/dados/serie/bcdata.sgs.22940/dados?formato=json&dataInicial=01/01/2010&dataFinal=31/12/2016

Which returns me a string of objects, just like the example below:

What can I be doing to resolve this issue?

Jici · March 22, 2021, 3:11pm

Add an header
key: User-Agent
value: bubble/yourapp
(You can enter what you want in value).

jared.gibb · March 22, 2021, 3:18pm

that works! I was having this issue recently, turned to postman and saw that header!

andreg.diniz97 · March 22, 2021, 3:31pm

Thank you so much guys! Now it’s working. @Jici @jared.gibb

Alter345 · September 20, 2021, 4:46pm

Hi there
Im having the same issue
i followed your advices @Jici @jared.gibb
but impossible for me the data, the call is not working
see the set up attached
Am i missing something ?
thanks

jared.gibb · September 20, 2021, 4:48pm

Are you able to get your api calls working in postman?

Alter345 · September 20, 2021, 5:29pm

I did this (see attached)
but not sure to have more informaiton ^^

jared.gibb · September 20, 2021, 5:40pm

ok. click the headers tab here. there may be special headers there.
does the call work from within postman?

Jici · September 21, 2021, 12:06am

What I think you have is a bug in Bubble. you have probably deleted or modify an header and in some case, this will create an issue. Can you start from a fresh new API Call to see if you have this error back?

Alter345 · September 21, 2021, 11:18am

@jared.gibb @Jici
thank you for your replies
I tried a call again
now the issue is not the same but still a problem ^^

jared.gibb · September 21, 2021, 11:19am

Change your data type to the appropriate response? Maybe it’s not a json?

Try text

Jici · September 21, 2021, 11:25am

You are calling Integromat and by default, Integromat will return a text. You need to change to text OR add Webhook response in your Integromat scenario

Alter345 · September 21, 2021, 11:30am

Thanks i will try guys
I guess I will check on thursday.
Not sure BTW that with the text format I can get the right datas
I ll let you know
Many thanks !

Alter345 · September 21, 2021, 1:51pm

@Jici @jared.gibb Ok it works when i turn it into text.
However, it’s not ideal to manipulate datas with integromat as text but i will figure out a solution.
Many thanks for your help !

Jici · September 21, 2021, 2:52pm

Can you share screenshot of your integromat scenario?

Alter345 · September 22, 2021, 6:45am

Yes
I did a split function, and it works, since it cut differents emails adress

jared.gibb · September 22, 2021, 10:47am

looks like you’re using it as a trigger to send emails? What would you expect it to return?

93bulletsb · May 11, 2022, 3:35pm

So I am struggling with the same thing here

Thats my api set up. It works in Postman. My return in text looks like this-

But JSON is the same non object type thing.

I tried the headers from postman but that didnt work.

Its a list of json objects, each with its own set of key value pairs.