Relative date range filtering using JSON no code with API only supporting timestamp format
Hello,
I'd like to use our partner API within Domo with JSON no code connector
The connexion works fine until I set up a relative date range filtering of 7 days (which is allowed by the API with startDate and endDate parameters). The API documentation specifies that date parameters should follow this timestamp format : "yyyy-MM-ddThh:mm:ss"
When setting this format in advanced settings, Domo returns following error :
"Domo is ready, but the date format entered is invalid. Please verify your date format and try again."
My understanding is that Domo does not recognise the timestamp format as specified by the documentation. Is there an "official" timestamp format redable by the connector ? Will it be passed correctly on the request URL ?
Thanks for any help !
Answers
-
Are you using Date Query parameters? I'm assuming that's the case in which it would cause Domo to validate the date string. In this instance it won't work if you're using relative values. Have you tried passing it via a string query parameter?
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0
Categories
- All Categories
- 1.2K Product Ideas
- 1.2K Ideas Exchange
- 1.3K Connect
- 1.1K Connectors
- 273 Workbench
- 2 Cloud Amplifier
- 3 Federated
- 2.7K Transform
- 78 SQL DataFlows
- 525 Datasets
- 2.1K Magic ETL
- 2.9K Visualize
- 2.2K Charting
- 434 Beast Mode
- 22 Variables
- 511 Automate
- 114 Apps
- 389 APIs & Domo Developer
- 8 Workflows
- 26 Predict
- 10 Jupyter Workspaces
- 16 R & Python Tiles
- 332 Distribute
- 77 Domo Everywhere
- 255 Scheduled Reports
- 66 Manage
- 66 Governance & Security
- 1 Product Release Questions
- Community Forums
- 40 Getting Started
- 26 Community Member Introductions
- 68 Community Announcements
- 4.8K Archive