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.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 747 Beast Mode
- 59 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 396 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 126 Manage
- 123 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive