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 -
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
Categories
- All Categories
- 1.2K Product Ideas
- 1.2K Ideas Exchange
- 1.4K 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
- 437 Beast Mode
- 23 Variables
- 513 Automate
- 115 Apps
- 390 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