Workflow not working - API Connector

anfitrioesdealuguel · 2024-08-01T13:05:12.300Z

When clicking on a calendar date, the corresponding card with the information of the existing reservation for that date does not appear.

It worked correctly until the end of June, and without making any changes to the workflow, it stopped working.

Steps:

1 - Click the day 2 painted in red

2 - Data to send in the workflow

Captura de tela de 2024-08-01 09-51-201168×259 47.6 KB

3 - Value in the URL parameters

3862×300 50.5 KB

4 - Empty return of the expected values

The queries are made through the API Connector plugin and work when I pass the same parameters “P2299” and “02/07/2024” in the test connection of the plugin’s endpoint. Returning the expected values as shown in the image below:

Raw data from api793×445 41.5 KB

Jici · 2024-08-01T13:26:22.289Z

Can you share the whole API Connector settings?

anfitrioesdealuguel · 2024-08-01T13:43:18.545Z

The API connector settings (The endpoint has been omitted for security reasons.):

settings915×516 42.9 KB

Jici · 2024-08-01T13:47:13.299Z

Everything work in API Connector but not when running WF?
But in API Connector, you have a different date… what if you put the same date?

anfitrioesdealuguel · 2024-08-01T14:17:16.428Z

Yes, it works in the API Connector, but not when running the WF.

Sorry, I had attached the wrong screenshot, the correct one would be this:

Untitled design (1)742×412 43.1 KB

Jici · 2024-08-01T14:21:06.914Z

If you can, activate the capture response header and the include errors checkbox.
Reinitialize API Connector and Update your workflow (because this will add “body” to the body response key). Once it’s done, run the WF an in inspector, check the body’s raw data (and post a screenshot here)

anfitrioesdealuguel · 2024-08-01T14:38:08.699Z

I did and the reponse was:

Untitled design (2)

This is the translation of the raw body text from an exception raised by our API:

{"ERROR":"The application behaved unexpectedly. Please contact the administrators."}

Jici · 2024-08-01T14:40:27.173Z

Now let’s try to debug:
create a requestbin.com and send the request from API Connector (be sure this one is working when you send it to API)
Run the WF
Compare both results

anfitrioesdealuguel · 2024-08-01T15:08:45.801Z

The response in the requestbin was:

Untitled design (3)1308×577 57.1 KB

Jici · 2024-08-01T16:23:22.447Z

Did you create request from both API connector and run mode? Compare both request.
Actually, I cannot do anything with your screenshot.

J805 · 2024-08-01T16:59:01.569Z

Not sure if this matters for your situation, but Bubble typically displays the date in the American format. 02/07/2024 = February 7th, 2024. Are you passing it along in the format that you need to pass it along in?

In your API connector, you are sending the date the other way around.

Not sure if that will make a difference. Hope it helps.

anfitrioesdealuguel · 2024-08-01T17:34:59.435Z

I actually didn’t send it with Run in the application. Here’s the result when running it from there:
Untitled design (5)

The date format is being sent incorrectly in Run. I believe that’s the issue. Do you know why this is happening?

anfitrioesdealuguel · 2024-08-01T17:37:36.332Z

Yes, this happened in the earlier versions of the application, but I have made corrections to use the dd/mm/yyyy format and ensure it is properly used in the endpoint query.

Jici · 2024-08-01T18:07:25.739Z

Can you share settings of the data field? (in the action/wf)

anfitrioesdealuguel · 2024-08-01T18:21:09.412Z

The settings of the data field:

Captura de tela de 2024-08-01 15-20-03692×504 48.7 KB

anfitrioesdealuguel · 2024-08-15T14:20:39.948Z

anfitrioesdealuguel:

The date format is being sent incorrectly in Run. I believe that’s the issue. Do you know why this is happening?

The problem was found here and i could make the fix in the workflow. Thanks for the help @Jici