Ability to create dynamic table widgets via API

I would like to put in a feature request to add the ability to create dynamic table widgets via API. Currently this widget type is not supported for API, only standard table widgets are. Dynamic tables are much more useful since you can add color thresholds and the instance links in the tables actually go to the instance, not just the device

Matt Whitney

Posted 4 years ago·Last reply 4 years ago

2 comments

LM User

·4 years ago

Using Chrome's dev tools, I captured the payload submitted to /santaba/rest/dashboard/widgets when adding a dynamic table to dashboard 107 in my portal:

<span class="pun">{</span><span class="pln">
  </span><span class="str">"columns"</span><span class="pun">:</span><span class="pln"> </span><span class="pun">[</span><span class="pln">
    </span><span class="pun">{</span><span class="pln">
      </span><span class="str">"columnName"</span><span class="pun">:</span><span class="pln"> </span><span class="str">"average"</span><span class="pun">,</span><span class="pln">
      </span><span class="str">"dataPointId"</span><span class="pun">:</span><span class="pln"> </span><span class="lit">98</span><span class="pun">,</span><span class="pln">
      </span><span class="str">"dataPointName"</span><span class="pun">:</span><span class="pln"> </span><span class="str">"average"</span><span class="pun">,</span><span class="pln">
      </span><span class="str">"displayType"</span><span class="pun">:</span><span class="pln"> </span><span class="str">"raw"</span><span class="pun">,</span><span class="pln">
      </span><span class="str">"enableForecast"</span><span class="pun">:</span><span class="pln"> </span><span class="kwd">false</span><span class="pun">,</span><span class="pln">
      </span><span class="str">"roundingDecimal"</span><span class="pun">:</span><span class="pln"> </span><span class="str">"2"</span><span class="pun">,</span><span class="pln">
      </span><span class="str">"rpn"</span><span class="pun">:</span><span class="pln"> </span><span class="str">""</span><span class="pun">,</span><span class="pln">
      </span><span class="str">"unitLabel"</span><span class="pun">:</span><span class="pln"> </span><span class="str">""</span><span class="pln">
    </span><span class="pun">}</span><span class="pln">
  </span><span class="pun">],</span><span class="pln">
  </span><span class="str">"dashboardId"</span><span class="pun">:</span><span class="pln"> </span><span class="lit">107</span><span class="pun">,</span><span class="pln">
  </span><span class="str">"dataSourceFullName"</span><span class="pun">:</span><span class="pln"> </span><span class="str">"Ping"</span><span class="pun">,</span><span class="pln">
  </span><span class="str">"dataSourceId"</span><span class="pun">:</span><span class="pln"> </span><span class="lit">35</span><span class="pun">,</span><span class="pln">
  </span><span class="str">"description"</span><span class="pun">:</span><span class="pln"> </span><span class="str">""</span><span class="pun">,</span><span class="pln">
  </span><span class="str">"displaySettings"</span><span class="pun">:</span><span class="pln"> </span><span class="pun">{</span><span class="pln">
    </span><span class="str">"pageSize"</span><span class="pun">:</span><span class="pln"> </span><span class="str">"25"</span><span class="pln">
  </span><span class="pun">},</span><span class="pln">
  </span><span class="str">"forecast"</span><span class="pun">:</span><span class="pln"> </span><span class="pun">{</span><span class="pln">
    </span><span class="str">"algorithm"</span><span class="pun">:</span><span class="pln"> </span><span class="str">"Linear"</span><span class="pun">,</span><span class="pln">
    </span><span class="str">"confidence"</span><span class="pun">:</span><span class="pln"> </span><span class="lit">70</span><span class="pun">,</span><span class="pln">
    </span><span class="str">"severity"</span><span class="pun">:</span><span class="pln"> </span><span class="str">"warn"</span><span class="pun">,</span><span class="pln">
    </span><span class="str">"timeRange"</span><span class="pun">:</span><span class="pln"> </span><span class="str">"Last 30 days"</span><span class="pln">
  </span><span class="pun">},</span><span class="pln">
  </span><span class="str">"interval"</span><span class="pun">:</span><span class="pln"> </span><span class="str">"3"</span><span class="pun">,</span><span class="pln">
  </span><span class="str">"name"</span><span class="pun">:</span><span class="pln"> </span><span class="str">"Ping Latency"</span><span class="pun">,</span><span class="pln">
  </span><span class="str">"rows"</span><span class="pun">:</span><span class="pln"> </span><span class="pun">[</span><span class="pln">
    </span><span class="pun">{</span><span class="pln">
      </span><span class="str">"deviceDisplayName"</span><span class="pun">:</span><span class="pln"> </span><span class="str">"*"</span><span class="pun">,</span><span class="pln">
      </span><span class="str">"fullName"</span><span class="pun">:</span><span class="pln"> </span><span class="str">"All > All"</span><span class="pun">,</span><span class="pln">
      </span><span class="str">"groupFullPath"</span><span class="pun">:</span><span class="pln"> </span><span class="str">"*"</span><span class="pun">,</span><span class="pln">
      </span><span class="str">"instanceName"</span><span class="pun">:</span><span class="pln"> </span><span class="str">"*"</span><span class="pun">,</span><span class="pln">
      </span><span class="str">"label"</span><span class="pun">:</span><span class="pln"> </span><span class="str">"##RESOURCENAME##"</span><span class="pln">
    </span><span class="pun">}</span><span class="pln">
  </span><span class="pun">],</span><span class="pln">
  </span><span class="str">"sortOrder"</span><span class="pun">:</span><span class="pln"> </span><span class="str">"descending"</span><span class="pun">,</span><span class="pln">
  </span><span class="str">"supportKeyWord"</span><span class="pun">:</span><span class="pln"> </span><span class="str">"Table"</span><span class="pun">,</span><span class="pln">
  </span><span class="str">"theme"</span><span class="pun">:</span><span class="pln"> </span><span class="str">"newBorderGray"</span><span class="pun">,</span><span class="pln">
  </span><span class="str">"topX"</span><span class="pun">:</span><span class="pln"> </span><span class="lit">10</span><span class="pun">,</span><span class="pln">
  </span><span class="str">"type"</span><span class="pun">:</span><span class="pln"> </span><span class="str">"dynamicTable"</span><span class="pun">,</span><span class="pln">
  </span><span class="str">"userPermission"</span><span class="pun">:</span><span class="pln"> </span><span class="str">"write"</span><span class="pln">
</span><span class="pun">}</span>

LM User

·4 years ago

This should be possible. You can configure any dashboard through the API by uploading the json that defines it. Is there a specific reason this appears to not be possible?

1	SUYASH GAIKWAD
2	PK Peter Kamuiru
3	SA Sławomir Abrich Align Technology, Inc.
4	SL sunbik lukab
5	JG Joshua Gedeon
6	TK Tammy Kennedy