Passing Dynamic Date Parameter -API Call
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello Everyone-
I am working on a workflow which will make a RestApi call to pull data from a server. I am able to achieve this piece , the issue now i am having is to have the code to pull data based on dynamically passing data parameters based on a "appliedtodate" field . This field is a STRING field and i am not able to get this to work.
I used the following api call in the Input Tool of the Alteryx WF snippet shown below (where i am passing the url for the "download" tool) .
I get the following error message after executing the WF. Am I doing something wrong ?
I would really appreciate if i could get some direction to resolve this query.
Internal server error encountered while processing the following request
Thank you very much.
MD
Solved! Go to Solution.
- Labels:
- API
- Date Time
- Download
- Dynamic Processing
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @MD2050, judging by the screenshot you provided it looks like the DateTimeFormat and DateTimeParse formulas are being used within the Text Input tool. I would suggest restructuring your workflow to move these calculations inside the formula tool. Alteryx functions by design only work within the formula and filter tools. Something like the screenshot below:
Also, make sure you test the output of the formula tool to see if the output string look appropriate for you to download using the Download tool.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator