I'm trying to bring an Alteryx analytics app on our server into a panel in Salesforce so my reps don't need to bounce between multiple tools.
The challenge I'm having appears to be related to the user interface date tool. I'm either passing the parameter wrong or I need to maybe create an API version of the app that doesn't use it. Has anyone encountered this before? Also, is there a good resource describing the different parameter types for the API that would help me troubleshoot these things ongoing?
Error: 'The entered date () is invalid'
Approach:
Extra context.The app takes in a name, product list, start and end date. Using v3/workflows/{workflow_id}/questions I pulled in the question details for the parameter below
{'name': 'Start_Date', 'questionType': 'QuestionDate', 'description': 'Select Beginning of Period', 'value': None, 'multiple': False, 'items': []}
I believe the format I should be passing for the parameter in the payload under questions is this format but I've tried a couple.
{
'Name': 'Start_Date',
'value': 'yyyy-mm-dd'
},
Solved! Go to Solution.
Circling back to this one. I hit my head against it too long then tested using the text input tool and it's working wonderfully. It's an extra step to create a power-user ready analytics app and a second version that strips out the user interface tools for text input, but it works wonderfully.
If anyone ever solves this - let me know. I'd much rather not have an extra step!
@slongstreet What version of designer/server are you running? I'm on 23.2 and the Date tool is working as expected via api. I'm attaching a simple example where my date tool is named DT. For my payload, I used a line of code like this when running the api:
{"questions": [{"name": "DT","value": "2025-01-01"}]}
Your payload looks comparable, so I'm a little stumped why it's not working. It seems like there is either a bug going on or some sort of a small typo (which seems unlikely if you're getting the text box to work).
@patrick_digan - I'm angry at myself. Given your note I went back and commented out all parameters and started reassembling. While the errors were still showing the same as the above for the date being invalid, the issue was how I formatted my listbox parameter. I updated it and everything is working as expected.
Thanks for the nudge!
@slongstreet Been there plenty of times before myself! Glad you got it sorted out.