How to retrieve specific value from list of Json Object in NodeJS

Question

I'm trying the below code to retrieve the executionArn but I'm getting this error

Error [SyntaxError]: Unexpected token o in JSON at position 1
    at JSON.parse (<anonymous>)

How to get executionArn or stateMachineArn from each record? Any help would be much appreciated.

console.log(data) - Output

{
  executions: [
    {
      executionArn: 'arn:aws:states:us-east-2:12222:execution:test:dcb689bc',
      stateMachineArn: 'arn:aws:states:us-east-2:12222:stateMachine:test-sm',
      name: 'test-name',
      status: 'SUCCEEDED',
      startDate: 2021-06-17T13:43:39.817Z,
      stopDate: 2021-06-17T13:43:53.667Z
    },
    {
      executionArn: 'arn:aws:states:us-east-2:12222:execution:test:sd32dsdf',
      stateMachineArn: 'arn:aws:states:us-east-2:12222:stateMachine:test-sm',
      name: 'test-name1',
      status: 'SUCCEEDED',
      startDate: 2021-06-17T13:43:39.817Z,
      stopDate: 2021-06-17T13:43:53.667Z
    }
  ],
  nextToken: 'aadfdfdf'
}

Code:

  stepfunctions.listExecutions(params, function(err, data) {
    if (err) console.log(err, err.stack); 
    else     
    console.log(data)
    //console.log(data.executions[0].executionArn)
    data = JSON.parse(data);
    data.forEach(function(result) {
        var arnValue = result.executions.executionArn;
        console.log(arnValue);
    });

  });

What is the output of console.log(data)? Please be aware that the input is not valid JSON. — evolutionxbox
– evolutionxbox, Commented Jun 17, 2021 at 14:24
data looks like it's a JavaScript object, not JSON. There should be no need to use JSON.parse — evolutionxbox
– evolutionxbox, Commented Jun 17, 2021 at 14:27
If I don't use JSON.parse then its giving me a data.forEach is not a function :( — Mike Marsh
– Mike Marsh, Commented Jun 17, 2021 at 14:35
Probably because data is an object which doesn't have that function. Try using data.executions.forEach instead? — evolutionxbox
– evolutionxbox, Commented Jun 17, 2021 at 14:36

Jishnu · Accepted Answer · 2021-06-17 14:40:22Z

1

data is an object and executions inside it is an array, so try this

data.executions.foreach(function (execution) {
  console.log('executionArn', execution.executionArn)
  console.log('stateMachineArn', execution.stateMachineArn)
})

answered Jun 17, 2021 at 14:40

Jishnu

4743 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Daniel Paul · Accepted Answer · 2021-06-17 14:27:46Z

0

executions.map(e=>{
   // access it here
   let a =  e.executionArn;
 });

answered Jun 17, 2021 at 14:27

Daniel Paul

5141 gold badge6 silver badges13 bronze badges

Comments

evolutionxbox · Accepted Answer · 2021-06-17 14:54:10Z

0

The provided output (data) is not a valid JSON object,

{...
  startDate: 2021-06-17T13:43:39.817Z,
  stopDate: 2021-06-17T13:43:53.667Z
}

For valid JSON, it should look like

{...
  "startDate": "2021-06-17T13:43:39.817Z",
  "stopDate": "2021-06-17T13:43:53.667Z"
}

for it to be iterated correctly.

If the data is from the server (API), stringify the dates before returning them, and the values could be found by

  data.executions.map(execution=>{
      let arnValue = execution.executionArn;
      console.log(arnValue);
  })

edited Jun 17, 2021 at 14:54

evolutionxbox

4,1426 gold badges41 silver badges59 bronze badges

answered Jun 17, 2021 at 14:43

daniel ernest

4961 gold badge5 silver badges12 bronze badges

2 Comments

evolutionxbox Over a year ago

The JSON example is not valid JSON. Also There's no such thing as a "JSON Object"

daniel ernest Over a year ago

thanks @evolutionxbx. Its a common mistake we make as developers.

Collectives™ on Stack Overflow

How to retrieve specific value from list of Json Object in NodeJS

3 Answers 3

Comments

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related