Audit API not returning times or actor info


Following the example code provided at the API training, I created a script to read data from the audit logs to push back into Domo. I got it working with one small issue - The actorId is always "0", the actorType is "undefined", and eventTime is "undefined". We got a few records with an actorId but they were all Domo people.
It is not throwing an error that the column names are wrong and it returns data. Without an eventtime, I cannot create a recursive dataflow to append to the dataset.
partial result : 0,undefined,,VIEWED,CARD,1268279286,Sample Express - Weekly Orders by SSC,undefined
code snippets:
var audit = new com.domo.dp.js.HTTPConnectionV2('https://api.domo.com/v1/audit?start=' + start + '&end=' + end + '&limit=50&offset=0', 'GET');
...
var results = audit.get();
while(audit.getCode() == 200 && results.length > 3){
var auditlist = JSON.parse(results);
for (i in auditlist) {
var a = auditlist[i];
...
print( a.actorId +','
+a.actorType +','
+a.actorName +','
+a.actionType +','
+a.objectType +','
+a.objectId +','
+a.objectName +','
+a.eventTime +','
Anyone else having this issue?
Best Answer
-
Support solved the biggest issue. They sent a copy of the JSON returned by the API and I realized that eventtime is referenced as time in the response. Now I have the event time and can load overlapping data and remove duplicates.
0
Answers
-
Hi,
Is anyone able to help out with this request?
Thanks,0
Categories
- 7.7K All Categories
- 5 Connect
- 921 Connectors
- 244 Workbench
- 477 Transform
- 1.8K Magic ETL
- 60 SQL DataFlows
- 446 Datasets
- 40 Visualize
- 199 Beast Mode
- 2K Charting
- 8 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
- 15 Manage
- 36 Governance & Security
- 28 Product Ideas
- 1.1K Ideas Exchange
- Community Forums
- 14 Getting Started
- 1 Community Member Introductions
- 49 Community News
- 18 Event Recordings
- 579 日本支部