You need to sign in to do that
Don't have an account?
Kevlangdo
json parse openactivities node.js
Hello
I am trying to parse the data from OpenActivties SOQL query in javascript
I am trying to parse the data from OpenActivties SOQL query in javascript
SELECT id, CreatedDate, (SELECT Subject, WhoId, IsTask, ActivityDate, Status, Priority, OwnerId, raison_dap__c, description FROM OpenActivities) OpenActivities FROM AccountThe OpenActivities is returned as json, but when I use JSON.stringify I get back the json data in string format. However, when I parse the data I can't retrieve any values
conn.query(query, function(err, result) { if (err) { return console.error(err); } console.log("total : " + result.totalSize); console.log("fetched : " + result.records.length); for (var i=0; i<result.records.length; i++) { var record = result.records[i]; var activity = result.records[i].OpenActivities; console.log("Name: " + record.Id); console.log("Created Date: " + record.CreatedDate); console.log("Activity data: " + JSON.stringify(record.OpenActivities)); JSON.parse(record.OpenActivities, (key,value)=>{ console.log(key); console.log(value); }); //or var data = JSON.parse(record.OpenActivities); console.log("size: " + data.totalSize); //nothing returnedsample data
Activity data: {"totalSize":2, "done":true, "records":[ {"attributes": { "type":"OpenActivity", "url":"/services/data/v39.0/sobjects/OpenActivity/00T0B0zzzzzzzixxxxxxxxx"}, "Subject":"call", "WhoId":null, "IsTask":true, "ActivityDate":null, "Status":"In Progress", "Priority":"High", "OwnerId":"005000000000", "Description":null}, {"attributes": { "type":"OpenActivity", ......}]}
All Answers