Download tool not returning data

[rishabh_saxena]

HI,

while trying to downlaod data through an API connection i am able to establish the connection but downloaddata column returns{"Message":"No HTTP resource was found that matches the request URI 'http://www53.***test1/api/v'."} while the download header returns

"HTTP/1.1 200 Connection established

HTTP/1.1 404 Not Found"

i have tried switching off the encode URL option in basic tab in download tool as suggested in one of the posts but still getting same results.

URL seems to be correct as my colleague is getting the data in insomnia.

can anyone help me on this please

[shancmiralles]

hi @rishabh_saxena  ,

if you're sure that URL is correct better try and see any trailing slashes ( some APIs require a trailing slash , others don't) 

[rishabh_saxena]

Hi shancmiralles,

I tried adding trailing slashes, but i still get the same result, have attached few screenshots see if it helps you help me.

[apathetichell · Accepted solution]

add a select tool before your url in your formula tool. you have this set for 51. --- change URL to accept 300 characters. your string is cutting off. you are getting a 404 error. There is another warning in your workflow relating to your formula tool which talks about string truncation.

if this is not correct -> try this in postman. get it to work in postman. then bring to Alteryx.

[rishabh_saxena]

Thank you so much apathetichell, it's working now. I can't believe I missed this.