topic Re: Qlik Sense .NET SDK API - WriteJson method in Integration, Extension & APIs

Qlik Sense .NET SDK API - WriteJson method

agigliotti — Sat, 16 Nov 2024 19:34:00 GMT

Hello,

Could someone help me how to get "snapshotData" from Qlik Engine related to a specific object Id ?

Below an example of "snapshotData" content from Chrome:
{\"data\":{\"qInfo\":{\"qId\":\"tLHmjnW\",\"qType\":\"barchart\"},\"qMeta\":{\"privileges\":[\"read\",\"exportdata\"]},\"qSelectionInfo\":{},\"qHyperCube\":{\"qSize\":{\"qcx\":2,\"qcy\":11},\"qDimensionInfo\":[{\"qFallbackTitle\":\"Negozio\",\"qApprMaxGlyphCount\":60,\"qCardinal\":1336,\"qSortIndicator\":\"A\",\"qGroupFallbackTitles\":[\"Negozio\"],\"qGroupPos\":0,\"qStateCounts\":{\"qLocked\":0,\"qSelected\":0,\"qOption\":66,\"qDeselected\":0,\"qAlternative\":0,\"qExcluded\":1270,\"qSelectedExcluded\":0,\"qLockedExcluded\":0},\"qTags\":[\"$text\"],\"qDimensionType\":\"D\",\"qGrouping\":\"N\",\"qNumFormat\":{\"qType\":\"U\",\"qnDec\":10,\"qUseThou\":0},\"qIsAutoFormat\":true,\"qGroupFieldDefs\":[\"=if( not isnull(Negozio), Negozio & ' (' & Città & '-' & [ISO code] & ')' )\"],\"qMin\":\"NaN\",\"qMax\":\"NaN\",\"qAttrExprInfo\":[{\"qMin\":32498.693999999996,\"qMax\":163909.0488,\"qFallbackTitle\":\"Importo ordinato\",\"qMinText\":\"32498,694\",\"qMaxText\":\"163909,0488\",\"id\":\"colorByAlternative\",\"matchMeasure\":0,\"colorMapRef\":\"JkRJtP\"}],\"qAttrDimInfo\":[],\"qIsCalculated\":true,\"qCardinalities\":{\"qCardinal\":1336,\"qHypercubeCardinal\":11,\"qAllValuesCardinal\":-1},\"autoSort\":true,\"cId\":\"jVPeVQy\",\"othersLabel\":\"Altri\"}],\"qMeasureInfo\":[{\"qFallbackTitle\":\"Importo ordinato\",\"qApprMaxGlyphCount\":13,\"qCardinal\":0,\"qSortIndicator\":\"D\",\"qNumFormat\":{\"qType\":\"R\",\"qnDec\":0,\"qUseThou\":0,\"qDec\":\",\",\"qThou\":\".\"},\"qMin\":32498.693999999996,\"qMax\":163909.0488,\"qIsAutoFormat\":true,\"qAttrExprInfo\":[],\"qAttrDimInfo\":[],\"qLibraryId\":\"JkRJtP\",\"coloring\":{},\"autoSort\":true,\"cId\":\"czCmYm\",\"numFormatFromTemplate\":true}],\"qEffectiveInterColumnSortOrder\":[1,0],\"qGrandTotalRow\":[{\"qText\":\"746904,412528\",\"qNum\":746904.4125280001,\"qElemNumber\":-1,\"qState\":\"X\",\"qIsTotalCell\":true}],\"qDataPages\":[{\"qMatrix\":[[{\"qText\":\"Nationwide Supply (Rhodes-AU)\",\"qNum\":\"NaN\",\"qElemNumber\":1331,\"qState\":\"O\",\"qAttrExps\":{\"qValues\":[{\"qText\":\"114344,556528\",\"qNum\":114344.5565280001}]}},{\"qText\":\"114344,556528\",\"qNum\":114344.5565280001,\"qElemNumber\":0,\"qState\":\"L\"}],[{\"qText\":\"Rich Department Store (Lane Cove-AU)\",\"qNum\":\"NaN\",\"qElemNumber\":1113,\"qState\":\"O\",\"qAttrExps\":{\"qValues\":[{\"qText\":\"66292,716\",\"qNum\":66292.71600000001}]}},{\"qText\":\"66292,716\",\"qNum\":66292.71600000001,\"qElemNumber\":0,\"qState\":\"L\"}],[{\"qText\":\"Helmets and Cycles (Lavender Bay-AU)\",\"qNum\":\"NaN\",\"qElemNumber\":1224,\"qState\":\"O\",\"qAttrExps\":{\"qValues\":[{\"qText\":\"62485,428\",\"qNum\":62485.42800000002}]}},{\"qText\":\"62485,428\",\"qNum\":62485.42800000002,\"qElemNumber\":0,\"qState\":\"L\"}],[{\"qText\":\"Cycle Parts and Accessories (Melbourne-AU)\",\"qNum\":\"NaN\",\"qElemNumber\":727,\"qState\":\"O\",\"qAttrExps\":{\"qValues\":[{\"qText\":\"58876,596\",\"qNum\":58876.59600000003}]}},{\"qText\":\"58876,596\",\"qNum\":58876.59600000003,\"qElemNumber\":0,\"qState\":\"L\"}],[{\"qText\":\"Gears and Parts Company (Milsons Point-AU)\",\"qNum\":\"NaN\",\"qElemNumber\":760,\"qState\":\"O\",\"qAttrExps\":{\"qValues\":[{\"qText\":\"55446,834\",\"qNum\":55446.834}]}},{\"qText\":\"55446,834\",\"qNum\":55446.834,\"qElemNumber\":0,\"qState\":\"L\"}],[{\"qText\":\"Bike Part Wholesalers (Sydney-AU)\",\"qNum\":\"NaN\",\"qElemNumber\":998,\"qState\":\"O\",\"qAttrExps\":{\"qValues\":[{\"qText\":\"52669,2854\",\"qNum\":52669.28540000002}]}},{\"qText\":\"52669,2854\",\"qNum\":52669.28540000002,\"qElemNumber\":0,\"qState\":\"L\"}],[{\"qText\":\"Helpful Sales and Repair Service (Seaford-AU)\",\"qNum\":\"NaN\",\"qElemNumber\":722,\"qState\":\"O\",\"qAttrExps\":{\"qValues\":[{\"qText\":\"50178,0974\",\"qNum\":50178.09740000001}]}},{\"qText\":\"50178,0974\",\"qNum\":50178.09740000001,\"qElemNumber\":0,\"qState\":\"L\"}],[{\"qText\":\"Popular Bike Lines (Newcastle-AU)\",\"qNum\":\"NaN\",\"qElemNumber\":996,\"qState\":\"O\",\"qAttrExps\":{\"qValues\":[{\"qText\":\"48599,328\",\"qNum\":48599.32800000002}]}},{\"qText\":\"48599,328\",\"qNum\":48599.32800000002,\"qElemNumber\":0,\"qState\":\"L\"}],[{\"qText\":\"Budget Toy Store (Lavender Bay-AU)\",\"qNum\":\"NaN\",\"qElemNumber\":1191,\"qState\":\"O\",\"qAttrExps\":{\"qValues\":[{\"qText\":\"41603,8284\",\"qNum\":41603.8284}]}},{\"qText\":\"41603,8284\",\"qNum\":41603.8284,\"qElemNumber\":0,\"qState\":\"L\"}],[{\"qText\":\"Liquidation Sales (Perth-AU)\",\"qNum\":\"NaN\",\"qElemNumber\":847,\"qState\":\"O\",\"qAttrExps\":{\"qValues\":[{\"qText\":\"32498,694\",\"qNum\":32498.693999999996}]}},{\"qText\":\"32498,694\",\"qNum\":32498.693999999996,\"qElemNumber\":0,\"qState\":\"L\"}],[{\"qText\":\"Altri\",\"qNum\":\"NaN\",\"qElemNumber\":-3,\"qState\":\"L\",\"qIsOtherCell\":true,\"qAttrExps\":{\"qValues\":[{\"qText\":\"163909,0488\",\"qNum\":163909.0488}]}},{\"qText\":\"163909,0488\",\"qNum\":163909.0488,\"qElemNumber\":0,\"qState\":\"L\"}]],\"qTails\":[{\"qUp\":0,\"qDown\":0}],\"qArea\":{\"qLeft\":0,\"qTop\":0,\"qWidth\":2,\"qHeight\":11}}],\"qPivotDataPages\":[],\"qStackedDataPages\":[],\"qMode\":\"S\",\"qNoOfLeftDims\":-1,\"qHasOtherValues\":true,\"qTreeNodesOnDim\":[],\"qColumnOrder\":[]},\"refLine\":{\"refLines\":[]},\"showTitles\":true,\"title\":\"TOP 10 NEGOZI\",\"subtitle\":\"\",\"footnote\":\"\",\"showDetails\":false,\"barGrouping\":{\"grouping\":\"grouped\"},\"orientation\":\"horizontal\",\"scrollStartPos\":0,\"gridLine\":{\"auto\":true,\"spacing\":2},\"dataPoint\":{\"showLabels\":true},\"color\":{\"auto\":false,\"mode\":\"byMeasure\",\"useBaseColors\":\"off\",\"paletteColor\":{\"index\":6},\"useDimColVal\":true,\"useMeasureGradient\":false,\"persistent\":false,\"expressionIsColor\":true,\"expressionLabel\":\"\",\"measureScheme\":\"sg\",\"reverseScheme\":false,\"dimensionScheme\":\"12\",\"autoMinMax\":true,\"measureMin\":0,\"measureMax\":10,\"altLabel\":\"JkRJtP\",\"byDimDef\":{\"label\":\"Negozio\",\"key\":\"StoreName\",\"type\":\"expression\",\"activeDimensionIndex\":0},\"byMeasureDef\":{\"label\":\"JkRJtP\",\"key\":\"JkRJtP\",\"type\":\"libraryItem\"}},\"legend\":{\"show\":false,\"dock\":\"auto\",\"showTitle\":true},\"dimensionAxis\":{\"continuousAuto\":true,\"show\":\"labels\",\"label\":\"auto\",\"dock\":\"near\"},\"preferContinuousAxis\":true,\"showMiniChartForContinuousAxis\":true,\"measureAxis\":{\"show\":\"labels\",\"dock\":\"near\",\"spacing\":1,\"autoMinMax\":true,\"minMax\":\"min\",\"min\":0,\"max\":10},\"visualization\":\"barchart\",\"masterVersion\":0.96,\"metadata\":{},\"snapshotData\":{\"object\":{\"size\":{\"w\":309,\"h\":481}},\"rtl\":false,\"content\":{\"size\":{\"w\":289.1875,\"h\":437.6458435058594},\"chartData\":{\"scrollOffset\":0,\"zoom\":{\"min\":0,\"max\":0}}},\"parent\":{\"h\":1169.33,\"w\":1062.67}},\"reducedHyperCube\":{\"qSize\":{\"qcx\":2,\"qcy\":11},\"qDimensionInfo\":[{\"qFallbackTitle\":\"Negozio\",\"qApprMaxGlyphCount\":60,\"qCardinal\":1336,\"qSortIndicator\":\"A\",\"qGroupFallbackTitles\":[\"Negozio\"],\"qGroupPos\":0,\"qStateCounts\":{\"qLocked\":0,\"qSelected\":0,\"qOption\":66,\"qDeselected\":0,\"qAlternative\":0,\"qExcluded\":1270,\"qSelectedExcluded\":0,\"qLockedExcluded\":0},\"qTags\":[\"$text\"],\"qDimensionType\":\"D\",\"qGrouping\":\"N\",\"qNumFormat\":{\"qType\":\"U\",\"qnDec\":10,\"qUseThou\":0},\"qIsAutoFormat\":true,\"qGroupFieldDefs\":[\"=if( not isnull(Negozio), Negozio & ' (' & Città & '-' & [ISO code] & ')' )\"],\"qMin\":\"NaN\",\"qMax\":\"NaN\",\"qAttrExprInfo\":[{\"qMin\":32498.693999999996,\"qMax\":163909.0488,\"qFallbackTitle\":\"Importo ordinato\",\"qMinText\":\"32498,694\",\"qMaxText\":\"163909,0488\",\"id\":\"colorByAlternative\",\"matchMeasure\":0,\"colorMapRef\":\"JkRJtP\"}],\"qAttrDimInfo\":[],\"qIsCalculated\":true,\"qCardinalities\":{\"qCardinal\":1336,\"qHypercubeCardinal\":11,\"qAllValuesCardinal\":-1},\"autoSort\":true,\"cId\":\"jVPeVQy\",\"othersLabel\":\"Altri\"}],\"qMeasureInfo\":[{\"qFallbackTitle\":\"Importo ordinato\",\"qApprMaxGlyphCount\":13,\"qCardinal\":0,\"qSortIndicator\":\"D\",\"qNumFormat\":{\"qType\":\"R\",\"qnDec\":0,\"qUseThou\":0,\"qDec\":\",\",\"qThou\":\".\"},\"qMin\":32498.693999999996,\"qMax\":163909.0488,\"qIsAutoFormat\":true,\"qAttrExprInfo\":[],\"qAttrDimInfo\":[],\"qLibraryId\":\"JkRJtP\",\"coloring\":{},\"autoSort\":true,\"cId\":\"czCmYm\",\"numFormatFromTemplate\":true}],\"qEffectiveInterColumnSortOrder\":[1,0],\"qGrandTotalRow\":[{\"qText\":\"746904,412528\",\"qNum\":746904.4125280001,\"qElemNumber\":-1,\"qState\":\"X\",\"qIsTotalCell\":true}],\"qDataPages\":[{\"qMatrix\":[[{\"qText\":\"Nationwide Supply (Rhodes-AU)\",\"qNum\":\"NaN\",\"qElemNumber\":1331,\"qState\":\"O\",\"qAttrExps\":{\"qValues\":[{\"qText\":\"114344,556528\",\"qNum\":114344.5565280001}]}},{\"qText\":\"114344,556528\",\"qNum\":114344.5565280001,\"qElemNumber\":0,\"qState\":\"L\"}],[{\"qText\":\"Rich Department Store (Lane Cove-AU)\",\"qNum\":\"NaN\",\"qElemNumber\":1113,\"qState\":\"O\",\"qAttrExps\":{\"qValues\":[{\"qText\":\"66292,716\",\"qNum\":66292.71600000001}]}},{\"qText\":\"66292,716\",\"qNum\":66292.71600000001,\"qElemNumber\":0,\"qState\":\"L\"}],[{\"qText\":\"Helmets and Cycles (Lavender Bay-AU)\",\"qNum\":\"NaN\",\"qElemNumber\":1224,\"qState\":\"O\",\"qAttrExps\":{\"qValues\":[{\"qText\":\"62485,428\",\"qNum\":62485.42800000002}]}},{\"qText\":\"62485,428\",\"qNum\":62485.42800000002,\"qElemNumber\":0,\"qState\":\"L\"}],[{\"qText\":\"Cycle Parts and Accessories (Melbourne-AU)\",\"qNum\":\"NaN\",\"qElemNumber\":727,\"qState\":\"O\",\"qAttrExps\":{\"qValues\":[{\"qText\":\"58876,596\",\"qNum\":58876.59600000003}]}},{\"qText\":\"58876,596\",\"qNum\":58876.59600000003,\"qElemNumber\":0,\"qState\":\"L\"}],[{\"qText\":\"Gears and Parts Company (Milsons Point-AU)\",\"qNum\":\"NaN\",\"qElemNumber\":760,\"qState\":\"O\",\"qAttrExps\":{\"qValues\":[{\"qText\":\"55446,834\",\"qNum\":55446.834}]}},{\"qText\":\"55446,834\",\"qNum\":55446.834,\"qElemNumber\":0,\"qState\":\"L\"}],[{\"qText\":\"Bike Part Wholesalers (Sydney-AU)\",\"qNum\":\"NaN\",\"qElemNumber\":998,\"qState\":\"O\",\"qAttrExps\":{\"qValues\":[{\"qText\":\"52669,2854\",\"qNum\":52669.28540000002}]}},{\"qText\":\"52669,2854\",\"qNum\":52669.28540000002,\"qElemNumber\":0,\"qState\":\"L\"}],[{\"qText\":\"Helpful Sales and Repair Service (Seaford-AU)\",\"qNum\":\"NaN\",\"qElemNumber\":722,\"qState\":\"O\",\"qAttrExps\":{\"qValues\":[{\"qText\":\"50178,0974\",\"qNum\":50178.09740000001}]}},{\"qText\":\"50178,0974\",\"qNum\":50178.09740000001,\"qElemNumber\":0,\"qState\":\"L\"}],[{\"qText\":\"Popular Bike Lines (Newcastle-AU)\",\"qNum\":\"NaN\",\"qElemNumber\":996,\"qState\":\"O\",\"qAttrExps\":{\"qValues\":[{\"qText\":\"48599,328\",\"qNum\":48599.32800000002}]}},{\"qText\":\"48599,328\",\"qNum\":48599.32800000002,\"qElemNumber\":0,\"qState\":\"L\"}],[{\"qText\":\"Budget Toy Store (Lavender Bay-AU)\",\"qNum\":\"NaN\",\"qElemNumber\":1191,\"qState\":\"O\",\"qAttrExps\":{\"qValues\":[{\"qText\":\"41603,8284\",\"qNum\":41603.8284}]}},{\"qText\":\"41603,8284\",\"qNum\":41603.8284,\"qElemNumber\":0,\"qState\":\"L\"}],[{\"qText\":\"Liquidation Sales (Perth-AU)\",\"qNum\":\"NaN\",\"qElemNumber\":847,\"qState\":\"O\",\"qAttrExps\":{\"qValues\":[{\"qText\":\"32498,694\",\"qNum\":32498.693999999996}]}},{\"qText\":\"32498,694\",\"qNum\":32498.693999999996,\"qElemNumber\":0,\"qState\":\"L\"}],[{\"qText\":\"Altri\",\"qNum\":\"NaN\",\"qElemNumber\":-3,\"qState\":\"L\",\"qIsOtherCell\":true,\"qAttrExps\":{\"qValues\":[{\"qText\":\"163909,0488\",\"qNum\":163909.0488}]}},{\"qText\":\"163909,0488\",\"qNum\":163909.0488,\"qElemNumber\":0,\"qState\":\"L\"}]],\"qTails\":[{\"qUp\":0,\"qDown\":0}],\"qArea\":{\"qLeft\":0,\"qTop\":0,\"qWidth\":2,\"qHeight\":11}}],\"qPivotDataPages\":[],\"qStackedDataPages\":[],\"qMode\":\"S\",\"qNoOfLeftDims\":-1,\"qHasOtherValues\":true,\"qTreeNodesOnDim\":[],\"qColumnOrder\":[]},\"visualizationType\":\"barchart\",\"sourceObjectId\":\"BxMZKc\",\"sheetId\":\"4cde9edb-1562-4d42-a5e8-77dc0420e6f9\",\"timestamp\":1574767874445,\"isClone\":false,\"qMetaDef\":{\"title\":\"TOP 10 NEGOZI\"},\"supportExport\":true},\"appLocaleInfo\":{\"qDecimalSep\":\",\",\"qThousandSep\":\".\",\"qListSep\":\";\",\"qMoneyDecimalSep\":\",\",\"qMoneyThousandSep\":\".\",\"qCurrentYear\":2019,\"qMoneyFmt\":\"#.##0,00 €;-#.##0,00 €\",\"qTimeFmt\":\"hh:mm:ss\",\"qDateFmt\":\"DD/MM/YYYY\",\"qTimestampFmt\":\"DD/MM/YYYY hh:mm:ss[.fff]\",\"qCalendarStrings\":{\"qDayNames\":[\"lun\",\"mar\",\"mer\",\"gio\",\"ven\",\"sab\",\"dom\"],\"qMonthNames\":[\"gen\",\"feb\",\"mar\",\"apr\",\"mag\",\"giu\",\"lug\",\"ago\",\"set\",\"ott\",\"nov\",\"dic\"],\"qLongDayNames\":[\"lunedì\",\"martedì\",\"mercoledì\",\"giovedì\",\"venerdì\",\"sabato\",\"domenica\"],\"qLongMonthNames\":[\"gennaio\",\"febbraio\",\"marzo\",\"aprile\",\"maggio\",\"giugno\",\"luglio\",\"agosto\",\"settembre\",\"ottobre\",\"novembre\",\"dicembre\"]},\"qFirstWeekDay\":0,\"qReferenceDay\":4,\"qFirstMonthOfYear\":1,\"qCollation\":\"it-IT\",\"qNumericalAbbreviation\":\"3:k;6:M;9:G;12:T;15:P;18:E;21:Z;24:Y;-3:m;-6:μ;-9:n;-12:p;-15:f;-18:a;-21:z;-24:y\"},\"language\":\"it-IT\"}

I need to send it via HTTP POST request.
Maybe I should use the WriteJson method ?

Many thanks in advance for your time.

Best regards
Andrea

Re: Qlik Sense .NET SDK API - WriteJson method

Øystein_Kolsrud — Fri, 29 Nov 2019 14:19:53 GMT

Do you mean you want to extract the "snapshotData" from messages of the type you printed? In that case it would be something like this:

myData.Get<AbstractStructure>("data").Get<AbstractStructure>("snapShotData");

Or potentially:

myData.CloneSubstructureAs<AbstractStructure>("/data/snapshotData");

Re: Qlik Sense .NET SDK API - WriteJson method

agigliotti — Fri, 29 Nov 2019 14:39:52 GMT

actually I'm trying to make an HTTP POST request to export a chart object as image using printing service.

below an example of body request:

{
"imageType": "Png",
"appName": "YYYYYY",
"appId": "001e3853-02dd-46b5-95e2-fc0055d38393",
"captureSize": {
"width": 648,
"height": 481,
"dpi": 96
},
"objTree": {
"id": "BxMZKc",
"type": "barchart",
"snapshotData": "?????",
"children": [],
"isExtension": false,
"title": "xxxxxx",
"area": {
"left": 0,
"top": 0,
"width": 1,
"height": 1
}
}
}

I don't know how to get the string value of snapshotData to pass in the request.

Re: Qlik Sense .NET SDK API - WriteJson method

Øystein_Kolsrud — Fri, 29 Nov 2019 14:45:17 GMT

OK, I don't know much about that part of the API I'm afraid, but there is an example project for how to deal with storytelling (and snapshots) here:

https://github.com/AptkQlik/PublicExamples/tree/master/DataStorytelling

It's rather old though, so don't know if it's up to date, but it should at least give you some clues.

Re: Qlik Sense .NET SDK API - WriteJson method

Øystein_Kolsrud — Fri, 29 Nov 2019 14:50:54 GMT

Or do you mean that you have the AbstractStructure but want to turn it into a string? In that case you can do this:

myStructure.PrintStructure()

Re: Qlik Sense .NET SDK API - WriteJson method

agigliotti — Fri, 29 Nov 2019 16:11:17 GMT

i'm doing as below:

GenericObjectLayout objLayout = MyObject.GetLayout();
objLayout.PrintStructure();

but it's not working beacuse the image is not being generated.

below what I get from PrintStructure():
"{\"qInfo\":{\"qId\":\"BxMZKc\",\"qType\":\"barchart\"},\"qMeta\":{\"privileges\":[\"read\",\"exportdata\"]},\"qExtendsId\":\"485a3f6f-5d28-48de-9b95-919602c3c039\",\"qSelectionInfo\":{},\"qHyperCube\":{\"qSize\":{\"qcx\":2,\"qcy\":11},\"qDimensionInfo\":[{\"qFallbackTitle\":\"Negozio\",\"qApprMaxGlyphCount\":60,\"qCardinal\":1336,\"qSortIndicator\":\"A\",\"qGroupFallbackTitles\":[\"Negozio\"],\"qGroupPos\":0,\"qStateCounts\":{\"qLocked\":0,\"qSelected\":0,\"qOption\":1336,\"qDeselected\":0,\"qAlternative\":0,\"qExcluded\":0,\"qSelectedExcluded\":0,\"qLockedExcluded\":0},\"qTags\":[\"$text\"],\"qDimensionType\":\"D\",\"qGrouping\":\"N\",\"qNumFormat\":{\"qType\":\"U\",\"qnDec\":10,\"qUseThou\":0},\"qIsAutoFormat\":true,\"qGroupFieldDefs\":[\"=if( not isnull(Negozio), Negozio & ' (' & Città & '-' & [ISO code] & ')' )\"],\"qMin\":\"NaN\",\"qMax\":\"NaN\",\"qAttrExprInfo\":[{\"qMin\":727272.64936700044,\"qMax\":72565657.79535009,\"qFallbackTitle\":\"Importo ordinato\",\"qMinText\":\"727272,649367\",\"qMaxText\":\"72565657,79535\",\"id\":\"colorByAlternative\",\"matchMeasure\":0,\"colorMapRef\":\"JkRJtP\"}],\"qAttrDimInfo\":[],\"qIsCalculated\":true,\"qCardinalities\":{\"qCardinal\":1336,\"qHypercubeCardinal\":11,\"qAllValuesCardinal\":-1},\"autoSort\":true,\"cId\":\"jVPeVQy\",\"othersLabel\":\"Altri\"}],\"qMeasureInfo\":[{\"qFallbackTitle\":\"Importo ordinato\",\"qApprMaxGlyphCount\":15,\"qCardinal\":0,\"qSortIndicator\":\"D\",\"qNumFormat\":{\"qType\":\"R\",\"qnDec\":0,\"qUseThou\":0,\"qDec\":\",\",\"qThou\":\".\"},\"qMin\":727272.64936700044,\"qMax\":72565657.79535009,\"qIsAutoFormat\":true,\"qAttrExprInfo\":[],\"qAttrDimInfo\":[],\"qLibraryId\":\"JkRJtP\",\"coloring\":{},\"autoSort\":true,\"cId\":\"czCmYm\",\"numFormatFromTemplate\":true}],\"qEffectiveInterColumnSortOrder\":[1,0],\"qGrandTotalRow\":[{\"qText\":\"80487704,179188\",\"qNum\":80487704.179187819,\"qElemNumber\":-1,\"qState\":\"X\",\"qIsTotalCell\":true}],\"qDataPages\":[{\"qMatrix\":[[{\"qText\":\"Brakes and Gears (Tooele-US)\",\"qNum\":\"NaN\",\"qElemNumber\":1001,\"qState\":\"O\",\"qAttrExps\":{\"qValues\":[{\"qText\":\"877107,192221\",\"qNum\":877107.192220999}]}},{\"qText\":\"877107,192221\",\"qNum\":877107.192220999,\"qElemNumber\":0,\"qState\":\"L\"}],[{\"qText\":\"Excellent Riding Supplies (Memphis-US)\",\"qNum\":\"NaN\",\"qElemNumber\":1104,\"qState\":\"O\",\"qAttrExps\":{\"qValues\":[{\"qText\":\"853849,179524\",\"qNum\":853849.17952399945}]}},{\"qText\":\"853849,179524\",\"qNum\":853849.17952399945,\"qElemNumber\":0,\"qState\":\"L\"}],[{\"qText\":\"Vigorous Exercise Company (Toronto-CA)\",\"qNum\":\"NaN\",\"qElemNumber\":1097,\"qState\":\"O\",\"qAttrExps\":{\"qValues\":[{\"qText\":\"841908,770707\",\"qNum\":841908.77070699888}]}},{\"qText\":\"841908,770707\",\"qNum\":841908.77070699888,\"qElemNumber\":0,\"qState\":\"L\"}],[{\"qText\":\"Totes & Baskets Company (San Antonio-US)\",\"qNum\":\"NaN\",\"qElemNumber\":1,\"qState\":\"O\",\"qAttrExps\":{\"qValues\":[{\"qText\":\"816755,576276\",\"qNum\":816755.57627599954}]}},{\"qText\":\"816755,576276\",\"qNum\":816755.57627599954,\"qElemNumber\":0,\"qState\":\"L\"}],[{\"qText\":\"Retail Mall (Richmond-CA)\",\"qNum\":\"NaN\",\"qElemNumber\":1205,\"qState\":\"O\",\"qAttrExps\":{\"qValues\":[{\"qText\":\"799277,895062\",\"qNum\":799277.89506199979}]}},{\"qText\":\"799277,895062\",\"qNum\":799277.89506199979,\"qElemNumber\":0,\"qState\":\"L\"}],[{\"qText\":\"Corner Bicycle Supply (Toronto-CA)\",\"qNum\":\"NaN\",\"qElemNumber\":1180,\"qState\":\"O\",\"qAttrExps\":{\"qValues\":[{\"qText\":\"787773,043768\",\"qNum\":787773.04376799939}]}},{\"qText\":\"787773,043768\",\"qNum\":787773.04376799939,\"qElemNumber\":0,\"qState\":\"L\"}],[{\"qText\":\"Outdoor Equipment Store (Nashua-US)\",\"qNum\":\"NaN\",\"qElemNumber\":1118,\"qState\":\"O\",\"qAttrExps\":{\"qValues\":[{\"qText\":\"746317,529257\",\"qNum\":746317.52925699949}]}},{\"qText\":\"746317,529257\",\"qNum\":746317.52925699949,\"qElemNumber\":0,\"qState\":\"L\"}],[{\"qText\":\"Thorough Parts and Repair Services (Lacey-US)\",\"qNum\":\"NaN\",\"qElemNumber\":1202,\"qState\":\"O\",\"qAttrExps\":{\"qValues\":[{\"qText\":\"740985,833742\",\"qNum\":740985.833741999}]}},{\"qText\":\"740985,833742\",\"qNum\":740985.833741999,\"qElemNumber\":0,\"qState\":\"L\"}],[{\"qText\":\"Health Spa, Limited (Toronto-CA)\",\"qNum\":\"NaN\",\"qElemNumber\":825,\"qState\":\"O\",\"qAttrExps\":{\"qValues\":[{\"qText\":\"730798,713914\",\"qNum\":730798.71391399938}]}},{\"qText\":\"730798,713914\",\"qNum\":730798.71391399938,\"qElemNumber\":0,\"qState\":\"L\"}],[{\"qText\":\"Fitness Toy Store (Garland-US)\",\"qNum\":\"NaN\",\"qElemNumber\":1173,\"qState\":\"O\",\"qAttrExps\":{\"qValues\":[{\"qText\":\"727272,649367\",\"qNum\":727272.64936700044}]}},{\"qText\":\"727272,649367\",\"qNum\":727272.64936700044,\"qElemNumber\":0,\"qState\":\"L\"}],[{\"qText\":\"Altri\",\"qNum\":\"NaN\",\"qElemNumber\":-3,\"qState\":\"L\",\"qIsOtherCell\":true,\"qAttrExps\":{\"qValues\":[{\"qText\":\"72565657,79535\",\"qNum\":72565657.79535009}]}},{\"qText\":\"72565657,79535\",\"qNum\":72565657.79535009,\"qElemNumber\":0,\"qState\":\"L\"}]],\"qTails\":[{\"qUp\":0,\"qDown\":0}],\"qArea\":{\"qLeft\":0,\"qTop\":0,\"qWidth\":2,\"qHeight\":11}}],\"qPivotDataPages\":[],\"qStackedDataPages\":[],\"qMode\":\"S\",\"qNoOfLeftDims\":-1,\"qHasOtherValues\":true,\"qTreeNodesOnDim\":[],\"qColumnOrder\":[]},\"refLine\":{\"refLines\":[]},\"showTitles\":true,\"title\":\"TOP 10 NEGOZI\",\"subtitle\":\"\",\"footnote\":\"\",\"showDetails\":false,\"barGrouping\":{\"grouping\":\"grouped\"},\"orientation\":\"horizontal\",\"scrollStartPos\":0,\"gridLine\":{\"auto\":true,\"spacing\":2},\"dataPoint\":{\"showLabels\":true},\"color\":{\"auto\":false,\"mode\":\"byMeasure\",\"useBaseColors\":\"off\",\"paletteColor\":{\"index\":6},\"useDimColVal\":true,\"useMeasureGradient\":false,\"persistent\":false,\"expressionIsColor\":true,\"expressionLabel\":\"\",\"measureScheme\":\"sg\",\"reverseScheme\":false,\"dimensionScheme\":\"12\",\"autoMinMax\":true,\"measureMin\":0,\"measureMax\":10,\"altLabel\":\"JkRJtP\",\"byDimDef\":{\"label\":\"Negozio\",\"key\":\"StoreName\",\"type\":\"expression\",\"activeDimensionIndex\":0},\"byMeasureDef\":{\"label\":\"JkRJtP\",\"key\":\"JkRJtP\",\"type\":\"libraryItem\"}},\"legend\":{\"show\":false,\"dock\":\"auto\",\"showTitle\":true},\"dimensionAxis\":{\"continuousAuto\":true,\"show\":\"labels\",\"label\":\"auto\",\"dock\":\"near\"},\"preferContinuousAxis\":true,\"showMiniChartForContinuousAxis\":true,\"measureAxis\":{\"show\":\"labels\",\"dock\":\"near\",\"spacing\":1,\"autoMinMax\":true,\"minMax\":\"min\",\"min\":0,\"max\":10},\"visualization\":\"barchart\",\"masterVersion\":0.96,\"metadata\":{}}"

the string length is about 6.740 characters while the string I get from chrome dev tools that works is about 13.120 characters
I noted "snapshotData" and "chartData" sections are missing that it seems are expected.

Also {\"data\": at the beginning is needed.

Re: Qlik Sense .NET SDK API - WriteJson method

ar5 — Sun, 01 Oct 2023 19:47:12 GMT

Hi,

Were you able to figure this out, generating image?

Re: Qlik Sense .NET SDK API - WriteJson method

agigliotti — Mon, 02 Oct 2023 07:25:40 GMT

Yes I did.

Re: Qlik Sense .NET SDK API - WriteJson method

ar5 — Mon, 02 Oct 2023 13:16:57 GMT

Did you simply append {\"data\": to the output of PrintedStructure(). What about snapshotData?