Skip to main content
P
pruby10-Marble
10-Marble
March 7, 2018
Solved

How to get the fields definition of an InfoTable

  • March 7, 2018
  • 4 replies
  • 7649 views

Is it possible to get the field definition of an InfoTable prior to knowing its DataShape?

 

I am currently doing it by converting my InfoTable to json and then by taking the dataShape definition:

 

var fields = Resources["InfoTableFunctions"].ToJSON(params);
var result = fields.dataShape.fieldDefinitions;

This works fine but I'm wondering if there is a nicer way to do this, by using services like getDataShape and GetFieldDefinitions.

Best answer by CarlesColl

The correct way of recovering the Fields of an Infotable with and unknown DataShape it's this one:

 

var iLF ;
if ((myInfotable.dataShape==null)||(myInfotable.dataShape==undefined)) {
 iLF = myInfotable.ToJSON().dataShape.fieldDefinitions;
 } else {
 iLF = myInfotable.dataShape.fields;
 }
for (var key in iLF) {
 logger.info("Field Name "+key+" baseType: "+iLF[key].baseType);
}

4 replies

P
PaiChung22-Sapphire I
22-Sapphire I
March 7, 2018

There was a similar thread to this before.

I think you can just do something like

for each (var field in myinfotable.fields)

C
CarlesColl1-VisitorAnswer
1-Visitor
March 8, 2018

The correct way of recovering the Fields of an Infotable with and unknown DataShape it's this one:

 

var iLF ;
if ((myInfotable.dataShape==null)||(myInfotable.dataShape==undefined)) {
 iLF = myInfotable.ToJSON().dataShape.fieldDefinitions;
 } else {
 iLF = myInfotable.dataShape.fields;
 }
for (var key in iLF) {
 logger.info("Field Name "+key+" baseType: "+iLF[key].baseType);
}
    Ascherer17
    Ascherer1716-Pearl
    16-Pearl
    July 2, 2018

    This is very helpful!  Thank you.

    L
    LeighEmeritus
    Emeritus
    April 5, 2018

    Hi @pruby

    Did Carles reply solve your issue? If so, please mark this as an Accepted Solution for the benefit of the rest of our Community. If not, let us know the current situation.

     

    Thanks!

    Leigh

    Terms & ConditionsAccessibility statement