Hi, a user is on DMA10.3.0 CU7. There is a use case to extract a dataset from elements of a certain protocol on a daily basis. This needs to be automated. The dataset is from a table. For each row of the table, the user would like to extract the IDX value and other parameters from the same row. Then iterate through each IDX.
- Current thought is to export to a file per element and upload to a shared folder.
- User-defined API is not an option with current DMA version.
We would like some advice on how to achieve this with DMA standard WebServices v1 API?
e.g.: in diagram below, we iterate all IDX and retrieve only Param_1, Param3 and Param_5 values.
Alternatively, let us know if there is a way to use Dashboards to automate such an export of data.
Hi Bing,
To iterate through the rows of a table, you could use the following methods:
- GetTableForParametersV2: With this method you could retrieve the list of primary keys/display keys (see hide-cell option)
- GetTableRowForParameter: With this method you could iterate per row based on the keys retrieved by the previous method
Hope it helps.