Execution failed with status 5000 | Appsmith | Page 1

queen vault Jan 27, 2023, 9:09 PM

#

So I'm getting this odd error with a POST API.

Execution failed with status 5000

NotAfter: Fri Jan 06 13:07:00 UTC 2023
{
"actionId":"63d4328510321b1d8e389d6e"
"requestedAt":1674852400.2463515
"body":""
"headers":[...]
"httpMethod":"POST"
"url":"https://computeportal.pliant.io/a/pc/prod/Administration/Locations/List_Locations?api_key=blahblahblah"
}

I like to triangulate, so I can confirm that the query works in Postman. I can also confirm that the datetime settings on the client and server are correct.

dapper novaBOT Jan 27, 2023, 9:15 PM

#

Hey There,

We've registered your query, and our team will get back to you soon.

Regards,
Team Appsmith

dapper novaBOT Jan 27, 2023, 9:52 PM

#

Please help us with the following information for faster debugging.

Which version of Appsmith are you on?
Provide screenshots/screen recordings of the original error/code snippet.
Add details about your use case and provide steps to reproduce the issue, if
possible.

wide musk Jan 27, 2023, 9:53 PM

#

Hello, in addition to the information requested in the previous message, could you please share this other information with us?

You use the cloud version or self/hosted
This worked before
You could run the same query from Postman

queen vault Jan 28, 2023, 12:18 AM

#

Hi @wide musk . This is a brand new docker install today, so self hosted. it's a new app completely, so it has not had the opportunity to work prior to now. 🙂 And yes, I can run the query and get the expected data from postman.

dapper novaBOT Jan 30, 2023, 4:07 AM

#

Hi there!
Thank you for the shared information!

I would like to confirm one last thing, does this api call require any form of
authentication or key to run?
If yes, can you share details on what type of authentication it is and a
screenshot of how you're doing this on appsmith? (Feel free to blur out any
sensitive information on the screenshot)

queen vault Jan 30, 2023, 1:52 PM

#

Yep, it's an api_key field:

wide musk Jan 30, 2023, 2:44 PM

#

Hello, could you show me the configuration you used in postman, please?

queen vault Feb 1, 2023, 8:17 PM

#

Hi @wide musk . It turns out the issue was with an expired cert. Postman was ignoring the cert, but Appsmith was not, so I suppose that is actually by design. Is there a way to toggle ssl safety off?

dapper novaBOT Feb 1, 2023, 8:25 PM

#

Unfortunately, this is not yet possible on Appsmith. But we have this feature
request: https://github.com/appsmithorg/appsmith/issues/16889. Please add a
comment with your use case to help us prioritize it.

GitHub

Issues · appsmithorg/appsmith

Low code project to build admin panels, internal tools, and dashboards. Integrates with 15+ databases and any API. - Issues · appsmithorg/appsmith

marsh portal Feb 15, 2023, 4:02 AM

#

Hello I have the same problem but I'm using a self-hosted version

dapper novaBOT Feb 15, 2023, 5:11 AM

#

@marsh portal Do you mean that you also would need to disable the SSL
for your API? In this case, please add a comment with your use case to the
feature request: https://github.com/appsmithorg/appsmith/issues/16889

GitHub

[Feature]: Provide an option to disable SSL for REST APIs · Issue #...

Is there an existing issue for this? I have searched the existing issues Summary A user wants a config that can enable/disable SSL verification on per request / per Datasource basis. We've ...

marsh portal Feb 15, 2023, 5:21 AM

#

nevermind I found the reason, the server that host appsmith suddenly lost the outbound connection connectivity so all API doesnt work

#Execution failed with status 5000