0 Replies Latest reply: Nov 7, 2017 9:40 AM by Jorik Jeeninga RSS

    Get DataModel fields names and values

    Jorik Jeeninga

      Hi,

      I Would like to know the fieldnames and values of my dataModel.


      I use the GetTablesAndKeys method get a list of the fieldnames.

       

      it returns this list of fieldnames:

       

      VerkoopkansKey

      LeadKey

      DatumKey

      RelatieKey

      Division

       

      Then i get the fieldvalues with the method getTableData:

       

      it returns this list of fieldvalues


      VK001

      LE001

      DIV001  - these are switched

      REL001  -

       

      as you can see the names and values are not in the same order and i wonder why the Qlik Sense API doesnt have a method that returns an object with BOTH the name AND the value of the tableModel, instead of separating them.

       

      Whats even more worrying is that the Qlik Sense engine-api-explorer returns this list of fieldnames:


      LeadKey

      VerkoopkansKey

      RelatieKey

      DatumKey

      Division


      This list is ALSO in a different order than the list of fieldvalues.


      Any help would be appreciated.