Adobe Analytics Advanced Query Relative Date Help
Hello,
I am having difficulty incorporating the relative date $Yesterday into my JSON query for the Adobe Analytics Advanced - Query connector
{"reportDescription":{
"reportSuiteID":"latamprod",
"dateFrom":"$Yesterday",
"dateTo":"$Yesterday",
"dateGranularity":"Day",
"elements":[
{"top":1000,
"selected":[],
"id":"evar26",
"classification":[],
"name":"Asset ID (v26)"}],
"metrics":[
{"decimals":0,
"id":"cm4992_5aac3be5bd01056bb7968ac1"},
{"decimals":0,
"id":"event51"},
{"decimals":0,
"id":"event52"},
{"decimals":0,
"id":"event53"},
{"decimals":0,
"id":"event54"},
{"decimals":0,
"id":"event55"}],
"segments":[],
"locale":"en_US"}}
It keeps telling me that the query is not a valid JSON string.
Thank you
Best Answer
-
Have you looked over the API docs from Adobe?
https://github.com/AdobeDocs/analytics-1.4-apis/blob/master/docs/reporting-api/real_time.md
Their link points to using 'yesterday'
1
Answers
-
Thank you! that worked out nicely!
0
Categories
- 7.6K All Categories
- Connect
- 917 Connectors
- 242 Workbench
- 472 Transform
- 1.8K Magic ETL
- 60 SQL DataFlows
- 445 Datasets
- 31 Visualize
- 197 Beast Mode
- 2K Charting
- 7 Variables
- 1 Automate
- 348 APIs & Domo Developer
- 82 Apps
- Workflows
- 14 Predict
- 3 Jupyter Workspaces
- 11 R & Python Tiles
- 241 Distribute
- 59 Domo Everywhere
- 241 Scheduled Reports
- 14 Manage
- 35 Governance & Security
- 19 Product Ideas
- 1.1K Ideas Exchange
- Community Forums
- 15 Getting Started
- 1 Community Member Introductions
- 49 Community News
- 18 Event Recordings
- 579 日本支部