Search by Keyword

Sense Excel the Add-In for Microsoft

If you miss something please send us an email. Thanks!

Overview about reporting json setting

You are here:
<< Back to all topics

This is a complete overview of the reporting config settings of the JSON Script notation.
At the moment you will see a hsjon (human json) script.

 


SET task = ´{
  tasks: 
  [
    {
      meta: 
      {
        name: <- click for info
        description: <- click for info
      }
      reports:
      [
        {
general:
{
timeout: <- click for info
autoFitTables: <- click for info
disableAutoLink: <- click for info
disableAdvancedTableMode: <- click for info
usePerfomanceAnalyzer: <- click for info
errorRepeatCount: <- click for info
cpuLimitInCore: <- click for info
memoryLimitInGB: <- click for info
} template: { input: <- click for info output: <- click for info outputFormat: <- click for info
outputPassword: <- click for info
outputFormatOptions: <- click for info
useBase64Password: <- click for info selections:<- click for info [ { name: Year <- click for info type: static <- click for info
objectType: <- click for info values: <- click for info [ value
] } { name: <- click for info type: <- click for info values: [ value ] } { name: <- click for info type: <- click for info values:
sorted: <- click for info [ value value
]

} ] } connections: <- click for info { app: <- click for info } distribute: { mail: <- click for info {
sendAttachment: <- click for info subject: <- click for info message: <- click for info ''' string or html ''' mailType: <- click for info text to: <- click for info
cc: <- click for info
bcc: <- click for info
mailServer: <- click for info { host: <- click for info from: <- click for info port: <- click for info username: <- click for info password: <- click for info useSsl: <- click for info } active: <- click for info } file: <- click for info { active: <- click for info target: <- click for info mode: <- click for info } hub: <- click for info { active: <- click for info mode: <- click for info
owner: <- click for info } } } ] }
{
meta:
{
name: ... ] }´;


** This part is autogenerated from the AnalyticsGate - Management Console  ! Do not change this ! **
** You can change this if your are an Qlik expert - good look or visit: https://help.qlik.com/ **
//Start reporting Let ResultWithTaskId = SER.START(task); Let TaskIdValue = TextBetween(ResultWithTaskId,'taskId":"','"'); TRACE TaskId: $(TaskIdValue); //Show Versions Let versions = SER.STATUS('versions: all'); Let MainVersion = TextBetween(versions,'version":"','"'); TRACE Version: $(MainVersion); //Wait for finish Let Status = 0; Do while Status < 3 and Status > -1 Let Result = SER.STATUS(ResultWithTaskId); Let LogMsg = TextBetween(Result,'log":"','"'); Let Status = num(mid(Result,11,1)); TRACE Status: $(Status) - $(LogMsg); Sleep 2000; Loop TRACE Status: $(Status) - Finished; //Read distibute results Let ResultText = SER.RESULT(ResultWithTaskId); Let FormatedResult = TextBetween(ResultText,'formatedResult":"','"'); Let OutputText = Replace(FormatedResult, '\r\n', chr(13)&chr(10)); TRACE $(OutputText); //End reporting
Was this article helpful?
2.5 out of 5 stars
5 Stars 0%
4 Stars 0%
3 Stars 0%
2 Stars 100%
1 Stars 0%
How can we improve this article?
Need help?