topic Re: External Api not returning any response in Get Started Discussions

External Api not returning any response

sshukla — Fri, 17 Jan 2025 10:52:26 GMT

import requests

url = "https://example.com/api"
headers = {
"Authorization": "Bearer YOUR_TOKEN",
"Content-Type": "application/json"
}
Payload = json.dumps({json_data})

response = requests.post(url, headers=headers, data=Payload)

print(response.status_code)
print(response.text)

this is running for very long time

Same url is working for other payload

could you please let me know why this is happening?

Re: External Api not returning any response

Alberto_Umana — Fri, 17 Jan 2025 12:42:11 GMT

Hello @sshukla,

What is the actual REST API endpoint you are trying to call?

Re: External Api not returning any response

sshukla — Fri, 17 Jan 2025 12:48:41 GMT

its Kinaxis Api end point.

same endpoint is working for other payload but for one specific payload it is not working.

same i have tried in postman and it was giving me result but in databricks it is running for very long

Re: External Api not returning any response

Alberto_Umana — Fri, 17 Jan 2025 14:25:55 GMT

Oh I see, it's an external endpoint. Can you test connectivity to the endpoint first? with curl -vX POST https:// endpoint from within Databricks?

Re: External Api not returning any response

sshukla — Sat, 18 Jan 2025 16:36:34 GMT

Hi,

connectivity is there as i am able to read data for other payload but for one specific payload it is not returning any response

Re: External Api not returning any response

Alberto_Umana — Sun, 19 Jan 2025 13:46:32 GMT

Can you DIM the two payload, it has to do with something on endpoint, since it is working on one payload fine, where in the other is not to the same endpoint.

Re: External Api not returning any response

guptaharsh — Mon, 23 Jun 2025 11:25:08 GMT

I have also faced the same issue, where for some payload the API is taking so much time but it is working absolutely fine on postman. Is is some response data size or cluster memory issue?

Re: External Api not returning any response

sshukla — Mon, 23 Jun 2025 11:47:36 GMT

The issue was due to data size and after filtering the data the issue got resolved

Re: External Api not returning any response

guptaharsh — Mon, 23 Jun 2025 16:32:46 GMT

how to reduce the data size, like API will going to give the data in onetime. can you give with some example.

res = request.get("api")
this above code is taking is lot of time