External Api not returning any response

[sshukla]

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?

[Alberto_Umana]

Hello @sshukla,

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

[sshukla]

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 

[Alberto_Umana]

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?

[sshukla]

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

[Alberto_Umana]

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.

[guptaharsh]

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?

[sshukla]

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

[guptaharsh]

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