Trouble with API output

[BWCWeb]

I have an API from Twilio that i am working with. I have set it up and tested in on Postman and it seems to display properly

However i am trying to get it setup in Wappler and i am having a little difficulty.
i have set it up on the Server side and it seems to display the data and format correctly.

however when i try to pull the data on the web page side, i can’t get it to display in normal format the the API output seems off.

Any ideas why this is off? I have also tried to run a Table Generator using the query from the API and it still doesn’t display correctly.

[Teodor]

Are you sure you are connected to the correct API endpoint as it returns XML and not JSON?

[BWCWeb]

yes, certain…the api URL is Messages.json

and the Postman results look to be in .json format as well and that is using the same data.

[Teodor]

I am not talking about postman, but about the server action. When you run the server action directly in browser what is the result?
What is the exact url you are using in the server action?

[BWCWeb]

here is the link
https://clientcreator.com/dmxConnect/api/twilio_messages.asp

[Teodor]

The content type is XML, so probably the URL you used is not the one calling the JSON response:

[BWCWeb]

let me check with Twilio again…thank you

[BWCWeb]

okay, so it looks like their default is .xml data, so you need to actually change the Data Type from Auto to json to force it. Then the data displays correctly.

Thank you for your help.