Static Widgets

S3 Static Bucket Connector

if either a JSON or xlsx file is placed in Amazon s3 under the dashboards/STATIC_DATA folder and in the query, we specify the filename. we will return data from that file.

Report Query Examples

XLSX file

JSON File

Adding pictures to S3 Static files

1. In the file, add a column for PictureId and put the name of the picture with an extension e.g. FirmLogo.jpg.

2. Then in a folder add the pictures in a subfolder called Res. Make sure the names match the sheet.

3. Zip the file and folder together in a zip.

4. Go to Dashboard-> Entities in the Administration panel.

5. Add a static S3 entity for this file. When the name of a data source and type (excel, json) are selected, the Upload static file button displays. Click it and select the zip file you created.

6. Click Save and the entity can now be used in a widget or report.

Static Client Side Widgets/Reports

if we use static_client_side as report_data_source then the backend will not return data. it is supposed that the UI has the data and logic.

Report Query Examples

Embedded Widgets and Reports

If we use the static_json as report_data_source, then we assume that the user will create a report with a static json array of data. that will be stored within the report itself (or we can say embedded report )

Report Query Example

Sharepoint List Connector

If we use the “SHAREPOINT LIST CONNECTOR” as the report data source then we will return data from the specified sharepoint list url.

Report Query Examples

• parent_entity_name : - SiteCode

• entity_name : - listCode

Report Query Example