I have JSON Result
Widget Arrangement
Column => DataTable
In DataTable we set "Number Of Column" with JSON Path "$.dataTable_data.column"
In DataTable we set "Generate Dynamic Childer" with JSON Path "$.data[:].columns" with Variabel "dataReport"
There are instructions or tips on using Dynamic Index Column but I'm not sure how to use it.
Example "Number Of Column" with JSON Path "$.dataTable_data.column" is 4
Example
Header 1 || Header 2 || Header 3 || Header 4
=================================
Cell 1 || Cell 2 || Cell 3 || Cell 4
Cell 1 We set dataReport => JSON Path => $[0]
Header 1 || Header 2 || Header 3 || Header 4
=================================
John Doe || John Doe || John Doe || John Doe
Peter Parker || Peter Parker || Peter Parker || Peter Parker
I hope result like this
Header 1 || Header 2 || Header 3 || Header 4
=================================
John Doe || Project Manager 1 || Present || Present
John Doe || Deputy Project Manager2 || Present || Present
Use Dynamic Column Index in DataTable
Database & APIs
{
"api_status": {"status": "success","code": 200,"message": "Data successfully retrieved."},
"dataTable_data": {"column": 4,"total_rows": "58","total_page": 6},
"header": ["Full Name","Job Position","2024-07-26","2024-07-29"],
"data":
[
{
"row_index": 0,
"columns": ["John Doe","Project Manager 2","Present","Present"]
},
{
"row_index": 1,
"columns": ["Peter Parker","Deputy Project Manager 2","Present","Present"]
}
]
}
No
1