Forum Discussion

bboysen's avatar
bboysen
Regular Visitor
3 years ago
Solved

JSON Keys Change for each record

Hello,   I have a JSON file that I am pulling via API; I am running into an issue when trying to expand the record into individual columns to access the values. Below is a snip of the JSON object. ...
Need Help
  • jbwtp's avatar
    jbwtp
    3 years ago

    Hi bboysen,

     

    the code which I posted works with a record and I think that you are trying to apply it to a table (according to what I see).

     

    try using AddColumn [from the point on your screenshot, i.e. the time_stamp column does exist, but not yet expanded] to add this code:

    Record.Field([time_bucket], Record.FieldNames([time_bucket]){0})

    This will/should estract the record with start/stop regardless of the actual "tag" of the record.

     

    Cheers,

    John  

    I think 

jbwtp's avatar
jbwtp
Memorable Member
3 years ago

Hi bboysen,

 

the code which I posted works with a record and I think that you are trying to apply it to a table (according to what I see).

 

try using AddColumn [from the point on your screenshot, i.e. the time_stamp column does exist, but not yet expanded] to add this code:

Record.Field([time_bucket], Record.FieldNames([time_bucket]){0})

This will/should estract the record with start/stop regardless of the actual "tag" of the record.

 

Cheers,

John  

I think 

bboysen's avatar
bboysen
Regular Visitor
3 years ago

John, this is money. Thank you, sir; the sad part is that I was missing one little item.