POST API call completed successfully, but I'm not getting a response in retool

Queries and Resources
1

I'm calling the Xero Accounting API to add a bunch of manual journals.

In the latest case, the query ended up returning "Unexpected error occurred while running query" after 480 seconds. However, when I look at the API history on the Xero side, I see the call completed in just over a second (see screenshot below). And the journals were successfully inserted into Xero.

This sort of behaviour has been happening whenever I do PUT or POST calls to the Xero API. GETs work fine. Other APIs (eg HubSpot) are working fine as well.

I'm at a lost for what is going on - hopefully someone can help?

image
image1355×520 33.5 KB

2

Same issue to me, API call succeeded, but no response body in Retool editor.

3

Glad to see I'm not the only one!

I can also add that I can run the same api calls via Xero's "API explorer" and I get (almost) instant responses (https://api-explorer.xero.com/)

4

True, I can run API call in Retool query library and get response, but when run same query to same end point in editor panel, the response body show Null :joy:

5

Hey folks! Are you running into this error consistently when hitting this particular endpoint?

6

Hi Kabirdas,

Yes it's just the xero end point (https://api.xero.com/api.xro/2.0/), and it's just POST and PUTs

Cheers

7

And yep its everytime :wink:

8

Sorry for the late reply here @maxamillian, took me a bit to set up and attempt to reproduce the behavior. The PUT requests I'm sending seem to return properly though so I imagine I'm missing something from your setup:

If you run the query with the example data from xero do you see the same issue? There have been a couple releases since you mentioned the behavior so it's also possible that it was fixed in the interim but in case it hasn't been, any other additional information you can provide about your setup would be much appreciated!

9

Still very slow / timing out for me.

For example, I sent just ONE invoice today and it took 20 seconds to get a response via retool app, but the Xero API history told me just 219ms.

And then I did ONE invoice via the Xero API explorer and the response was pretty much instant, with the Xero API history reporting 400ms

So something seems to be stopping Retool getting a response in a timely fashion?

10

Sorry for delay in coming back with details. Here's an example of a post that took 70 seconds today. From Retool's Timeline:

Screenshot 2023-09-07 094051
Screenshot 2023-09-07 0940511119×713 66.3 KB

But only took 191ms from Xero's API History:

Screenshot 2023-09-07 100903
Screenshot 2023-09-07 1009031351×350 25.6 KB

This is a small post - 2 journals with a total of 8 line items. Usually they're bigger, and when I attempt to post a bigger journal via retool, it times out, but the post is still successful from the Xero side! When I post those bigger journals directly via the Xero API Explorer, it has no trouble dealing with it, and the response is prompt.

This is the payload (with descriptions anonymised) for this particular post:

payload.json (1.8 KB)

11

Still no luck using that same data :disappointed: since it looks like you both may be using the New Zealand API I'm wondering if overriding the outbound Retool region on your instance has any effect on the result. My guess would be that us-west-2 would be better ultimately but it may still be worth a try.

Even though I haven't been able to reproduce this I'll still log it as a bug for further investigation. Thanks for surfacing the issue here!

12

Hi Kabirdas,

Thank you for looking into it. It is a bit of a mystery eh! Ok, I'll try adjusting the region...

13

Kabirdas, can you please provide me with screenshots info on your Xero resource setup? Just want to double check its not something to do with that?