Getting table data in mashup.

s29124141 — Sun, 07 May 2017 15:32:28 GMT

Hi All, I need help in getting the Qlik Sense table data into javascript object via capability API or any other API. Below is the table that present in data model viewer. I need to fetch this table into my javascript object. Can someone direct me in the right path?

Re: Getting table data in mashup.

Anonymous — Sun, 07 May 2017 15:52:34 GMT

You need to create HyperCube of your data. Here is the relevant section of the online help, https://help.qlik.com/en-US/sense-developer/3.2/Subsystems/EngineAPI/Content/Structs/HyperCube.htm

Re: Getting table data in mashup.

s29124141 — Sun, 07 May 2017 16:04:13 GMT

Thanks bill.markham for your response.

I am able to create hypercube and pull the data using createcube method. But above table has the mapping (dimension name and label name) for straight table dimensions that needed for creating hypercube. How do I set the dimension label (Column label) to the defined in the above table dynamically.?

For Example :-

"CustLevel1" column should have "Company" as the column header. This mapping may vary for another app, so looking for generic solution.

app.createCube({
  "qInitialDataFetch": [
  {
  "qHeight": 20,
  "qWidth": 2
  }
  ],
  "qDimensions": [
  {
  "qDef": {
  "qFieldDefs": [
  "CustLevel1"
  ]
  },
  "qNullSuppression": true,
  "qOtherTotalSpec": {
  "qOtherMode": "OTHER_OFF",
  "qSuppressOther": true,
  "qOtherSortMode": "OTHER_SORT_DESCENDING",
  "qOtherCounted": {
  "qv": "5"
  },
  "qOtherLimitMode": "OTHER_GE_LIMIT"
  }
  },
  {
  "qDef": {
  "qFieldDefs": [
  "CustLevel2"
  ]
  },
  "qNullSuppression": true,
  "qOtherTotalSpec": {
  "qOtherMode": "OTHER_OFF",
  "qSuppressOther": true,
  "qOtherSortMode": "OTHER_SORT_DESCENDING",
  "qOtherCounted": {
  "qv": "5"
  },
  "qOtherLimitMode": "OTHER_GE_LIMIT"
  }
  }
  ],
  "qMeasures": [],
  "qSuppressZero": false,
  "qSuppressMissing": false,
  "qMode": "S",
  "qInterColumnSortOrder": [],
  "qStateName": "$"
  },CubeCreatedCallback);

topic Re: Getting table data in mashup. in Integration, Extension & APIs

Getting table data in mashup.

Re: Getting table data in mashup.

Re: Getting table data in mashup.