My goal: Use an OpenAPI 3.1.0 JSON file as a Retool resource (Per documentation)
Issue: When attempting to connect to the resource, we get the following error in the Retool console:
Test connection failed (15.429s):Error: Could not establish a connection. Try checking your database firewall configuration and whitelisting Retool's IP Address.
HttpError {statusCode: 422, payload: Object}
statusCode: 422
payload: Object
statusCode: 422
error: "Unprocessable Entity"
message: "Could not establish a connection. Try checking your database firewall configuration and whitelisting Retool's IP Address."
data: null
Steps I've taken to troubleshoot: We're able to connect to and use the OpenAPI resource via Postman and CURL. We've reviewed our CORs and IP allowlist configuration as well, and confirmed that Retool should be able to connect.
Apologies for the issue. Very odd that even with the Retool IP whitelisted that the firewall is still catching and rejecting the incoming requests.
Can you confirm what IPs you have white listed? I have another user with a similar issue and I am checking internally if there is a unique quirk to how OpenAPI queries are sent
Are you able to query the routes via a REST API query?
What's confusing, though, is that the OpenAPI resource is not hosted behind a firewall; it's publicly available on the internet, requiring authentication via a username and password. There should be no allowlisting required, and I assume just a CORs validation.
I was just going through your org's logs in Datadog and it looks like at least one of the errors getting passed back to Retool from the server had an error code of 401.
Could you double check that the auth username and password are correct?
It's still an issue with the cached clear, in an Incognito window, new browser, etc.