The output values from the API response are incomplete when Power Query is used.
When using CURL user gets all the expected details such as name,url, metric ID etc but when using Power Query, user does not get the expected output such as metric ID, URL in the results.
Details
- Check whether any changes are made in the API.
- Check the power query tool, whether some headers need to be re-adapted.
When data is imported into Power Query from an Excel file, Power Query tries to automatically detect headers. The first row of the data is considered the column headers by default. If the first row isn't recognized as headers use the "Promote Headers" feature in the editor to convert the first row of the data into the column headers for the dataset. Use the "Remove Headers" option to reset the header row or "Rename" the headers to make them match specific requirements for the analysis. Rename, Remove or Promote to ensure that dataset is correctly structured for analysis so as to make the analyses or transformation complete.
Highlight API's
Additional Resources
CAST Highlight Troubleshooting Guides
CAST Highlight Product Documentation
Ticket
46900
Comments