Forum Discussion
Custom API call added as column
Hi guys Hope you can help me out. I have got a column with a logger ID for each row. Then added a custom column with API web to retrieve data for each loggerid. Then I simply added another column...
Are you sure that "Custom" column exists? Also, why do you have "=" after "[Custom]" in your code?
mariopavic Yes, the custom column exists as below. The custom column contains the API web address as https://energycloud.com/api/LoggerData/dailytotals?&channelNumber=1&apiKey=cb&pageSize=100&orderby=id&page
The equal symbol equals to page number
[Custom]&"="&Text.From([Page])Try this
mariopavic thanks again. However, its coming with error 'Custom' column cannot be found.
