Extract field from Javascript object in google apps script

Question

I am very new at this and the answer is probably very simple, but please help.

I get the following returned from a query, this is a jsonParse of the result

{"totalSize":1,
"done":true,
"records":
    [{"attributes": 
    {
        "type":"Account",
        "url":"/services/data/v21.0/sobjects/Account/001C0000012Z8Y5IAK"
    },
    "Id":"001C0000012Z8Y5IAK"
    }] 
}

How do I extract the Id at the end into a variable when totalSize = 1?

Arun Nagarajan · Accepted Answer · 2012-11-16 19:54:31Z

1

objectName.records[0].Id will do the trick. Increment records index appropriately.

Sample -

var sforceResponse = {"totalSize":1,"done":true,"records":[{"attributes":{"type":"Account","url":"/services/data/v21.0/sobjects/Account/001C0000012Z8Y5IAK"},"Id":"001C0000012Z8Y5IAK"}]}

sforceResponse.records[0].Id //this variable contains the Id.

answered Nov 16, 2012 at 19:54

Arun Nagarajan

5,6651 gold badge24 silver badges19 bronze badges

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

5 Comments

Jim F Over a year ago

I get "TypeError: Cannot read property "Id" from undefined." Here is my code

Jim F Over a year ago

Arun Nagarajan Over a year ago

First thing I noticed is that you want to change this line - queryResult["totalSize"]=1 to be queryResult["totalSize"]===1. The code as is will always be true as its just an assignment and the 2nd version will actually do the comparision. Does that help?

Jim F Over a year ago

Thank you very much. I assumed I had a syntax error and never thought about this as a data error. Problem solved.

Arun Nagarajan Over a year ago

Great. Glad to hear. Mark this as accepted so that the next person knows what fixes the issue.

Collectives™ on Stack Overflow

Extract field from Javascript object in google apps script

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related