Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Extract Record Field Names to List

I'm deep into writing some functions to automate processing some fairly deep and complex JSON files. Since it is JSON coming from user generated data the number and names of the key:value pairs is in...
Need Help
  • KT_Bsmart2gethe's avatar
    KT_Bsmart2gethe
    4 years ago

    Hi Anonymous ,

     

    The syntax for look like > Record.FieldNames([ColumnNames]). To have your syntax work, you need to update your syntax to Record.FieldNames(Record.Field(_,ColumnNames)).

     

    Regards

    KT

KT_Bsmart2gethe's avatar
KT_Bsmart2gethe
Impactful Individual
4 years ago

Hi Anonymous ,

 

The syntax for look like > Record.FieldNames([ColumnNames]). To have your syntax work, you need to update your syntax to Record.FieldNames(Record.Field(_,ColumnNames)).

 

Regards

KT

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Brilliant! At first pass that seems to do what I need it to!

 

So basically, I need to get the record, to then extract the fields? Can you explain the underscore syntax, is that a shortcut for basically saying use the current record?

 

Cheers and thanks!!

  • KT_Bsmart2gethe's avatar
    KT_Bsmart2gethe
    Impactful Individual
    4 years ago

    Hi Anonymous ,

     

    When you deal with dynamic column names, it either comes as "ColumnName" or [ColumnName].

    when you declare the variable as a text, it works for syntax "ColumnName" but not within the square bracket. So, you need Record.Field(_, "ColumnNames"). The underscore means each of the fields within a record.

    I hope above explainable is clear for you 🙂