Hello guys,
Right now I am struggling to fill a table with data that I request using an automation script.
The data is requested via an onclick (btn) and I want to parse it into a table element in a low-code app. For testing, I already parse the data into a text field using
engine.AddScriptOutput("TextField", stringBuilder.ToString()).
For the table i tried as string and as json:
string jsonTable = JsonSerializer.Serialize(Data);
engine.AddScriptOutput("dbOutput",jsonTable).
The requested data is displayed correctly there, but I want to parse it into a table for better visibility.
The variable for the table in the low-code app is called dbOutput and is of type table.
I found that IGQIDataSource exists and created the table based on dbOutput. I can see the rows and columns, but no data is shown.
I didn't find any information here:
https://docs.dataminer.services/dataminer/Functions/Dashboards_and_Low_Code_Apps/Visualizations/Available_visualizations/Tables/Table_component.html?q=table
Thanks in advance.
Can be possible I need to check,
How can I pass the row I selected to my automation script? (all columns)
How to join tables?
Hi Ömer,
It isn't possible to create a full table directly from a script output in a LCA. As an alternative, you could use the script to store the resulting table somewhere (element, file-based, ...) and then use an Ad-hoc data source to request the table inside your LCA. Clicking the button will then:
- Execute a script action to generate the table and store it somewhere on the DMA.
- Trigger a post-action to fetch the data in the table using an ad hoc query.
Hi Ömer, can't you retrieve the data directly in the ad-hoc data source itself, instead of retrieving it via a script and providing it via output to the data source?