Hello,
I am using the data acquisition feature in a Task to parse data from an equipment output file, and would like to know if it is possible to retrieve the parsed data that is visible in the measurements page directly using the API? Please see the attachment that shows the data I am trying to retrieve (highlighted in green - actual data blocked out for confidentiality).
Currently, I am able to download the parsed data as a delimited file, however for the purpose of aggregating many measurements, it would be easier to be able to retrieve this data from an API call directly rather than having to scrape the files. The method I am using to do this is described below:
- Query the pex using the \$reviewData endpoint and get a list of all the unique measurement guids.
- Query the measurement using the guid from step 1.
- The json returned from calling the measurement endpoint has a field called "lastParseResult" which has a URL for the parsed_x_y data (for example: https://host.com/plp/runtime/v1/jobs/svc_foundation-hub/{guid}/parsed_xy_data_0), but this returns a 404 error.
As a workaround, I query the attachments endpoint (https://host.com/foundation/hub/api/v1/measurements/{measurement guid}/attachments/) which returns this data that I use to download the parsed data file.
"displayName": "parsed_xy_data_0 (Attachment)", "file": { "id": "{id}", "urn": "urn:file:{urn}", "downloadUrl": "https://host.com/foundation/hub/api/v1/files/download/{download guid}", "mimeType": "application/excel", "name": "parsed_xy_data_0"
If anyone has suggestions on a more direct way to get to this data, I would be most appreciative! Thanks in advance.