find value from return API array in app script

Question

I use app script and try to get value from return array by API, this is return array :

this is the full JSON:

   {data=[{first=[[10, 1], [14, 0], [13, 5]}]}

I use this code to get value but not woeking:

var request = UrlFetchApp.fetch(url);
var json = JSON.parse(request);
// this is the code to get value
const value= json.data.first.map(obj => [obj[0]]);

The error is : TypeError: Cannot read property 'map' of undefined

You're trying to map object before the data from API is loaded. That's why it's undefined. Read about async functions: developer.mozilla.org/docs/Web/JavaScript/Reference/Statements/… — abellay
– abellay, Commented Sep 28, 2021 at 13:38
If my assumption that the full json is {data=[{first=[[10, 1], [14, 0], [13, 5]]}]} (yours is lacking a single closing square bracket), then use data[0] before accessing first. See my answer below. — NightEye
– NightEye, Commented Sep 28, 2021 at 15:24

NightEye · Accepted Answer · 2021-09-28 15:27:18Z

1

The full json's array you included is not properly closed.

modified it to this instead

{data=[{first=[[10, 1], [14, 0], [13, 5]]}]}

Upon doing that, this code should work.

Code:

function myFunction() {
  var json = {data: [{first: [[10, 1], [14, 0], [13, 5]]}]};
  Logger.log(json)
  // access first array element of data
  var value= json.data[0].first.map(obj => [obj[0]]);
  Logger.log(value)
}

Using data[0]:

Using data:

edited Sep 28, 2021 at 15:27

answered Sep 28, 2021 at 15:17

NightEye

11.3k2 gold badges8 silver badges25 bronze badges

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

Comments

Cooper · Accepted Answer · 2021-09-28 14:27:19Z

0

Your data doesn't look like JSON to me:

This works:

function myfunk() {
  const resp = '{"time":1632835594443, "first":[[10, 1], [14, 0.16306, 0], [13, 5]]}';
  const obj = JSON.parse(resp);
  Logger.log(JSON.stringify(obj.first));
}

8:26:36 AM  Notice  Execution started
8:26:37 AM  Info    [[10,1],[14,0.16306,0],[13,5]]
8:26:37 AM  Notice  Execution completed

answered Sep 28, 2021 at 14:27

Cooper

64.2k7 gold badges28 silver badges65 bronze badges

3 Comments

johnvan Over a year ago

not working, Return null . this is the full JSON {data=[{first=[[10, 1], [14, 0], [13, 5]}]}

Cooper Over a year ago

That's not JSON. And my code is not returning anything.

johnvan Over a year ago

I see the error oky I update that in another place can you checked that pleas: stackoverflow.com/questions/69795163/get-value-from-api-json

colorswall · Accepted Answer · 2021-09-28 14:58:17Z

0

Show your response

But maybe just

const [first] = json.data || []; // get 0 from array
const values = first.map(obj => [obj[0]])

Or maybe get object property

const { first } = json.data || {}; // get propetry first
const values = first.map(obj => [obj[0]])

edited Sep 28, 2021 at 14:58

answered Sep 28, 2021 at 13:40

colorswall

1881 silver badge4 bronze badges

3 Comments

johnvan Over a year ago

Error TypeError: first.map is not a function

colorswall Over a year ago

Please show result of console.log(json.data);

johnvan Over a year ago

this is the full JSON {data=[{first=[[10, 1], [14, 0], [13, 5]}]}

Collectives™ on Stack Overflow

find value from return API array in app script

3 Answers 3

Code:

Using data[0]:

Using data:

Comments

3 Comments

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Code:

Using data[0]:

Using data:

Comments

3 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related