Create JSON using SAC Designer Result Set API

[former_member6443]

Hi All,

I am trying to figure a way out whether an API exists to get resultset when a data point in a table has more than 1 measure so that I can create a json string to pass to a Custom Widget based on the SAC Table. This is an imported model but just should not matter.

I have a table on a the Best Run Advanced Model example below

table-from-model.png

Data using resultset API is as below

console-log.pngThe resultant json I require is something like this. Is

[
  {
    "state":"California",
    "Store":"Second Hand",
    "Quantity sold Plan":79321,
    "Gross Margin":1087506
  },
  {
    "state":"California",
    "Store":"Ozzy",
    "Quantity sold Plan":811586,
    "Gross Margin":950619
  }
] 

Is there a simpler way of doing this in SAC Designer , any pointers would be helpful

Cheers

Afshin

[andreasja_schneider]

Ring bling, any news on this, please?

Or other way around:

I've got FilterValues, which are by no suprise of data type FilterValue

I need this to be converted to an ARRAY of String, and I am hitting my head against a brick wall.

Please, can anybody help?