Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Invalid syntax error when using "Take Body from Field" option in the Download Tool

patrickprentice
8 - Asteroid

I'm 90% of the way through building a proof of concept that will hopefully allow us to drop one of our third party dependencies and automate a lot of my repetitive daily tasks but I'm running into a small issue with the download tool.

 

In my workflow I'm downloading data from an API using the download tool.  If I drop the body of my POST request into the "Use Following for Query String/Body" option in the payload section it works perfectly but if I drop that body into a text field to be read using the "Take Query String/Body from Field" option it kicks it back to me saying it's an invalid syntax.  Unfortunately, for the task I need it to complete I need to dynamically change a part of the body so just leaving the body in pasted in the "Use Following for Query String/Body" won't work for me.

 

I'm pretty sure the body is being read by the download tool as truncated to 256 characters.  So far I have tried messing with the data type and size.  Even with V_WString and 1000000000 size it still gives me the same issue.

 

Does anyone have any suggestions?

 

I am on Version 2021.2.1.35394 if that makes any difference.

1 REPLY 1
patrickprentice
8 - Asteroid

Nevermind.  The problem had to do with the fact that I was using the Replace function in a formula tool.  It was locking the size of my field to the input size despite the fact that I was adding in another 50 or so characters.  Works perfectly now.

Labels
Top Solution Authors