Issue with ‘Scheduled Refresh’ for api calls

Hi Anonymous,

It seems like the power query not allow you direct do merge operations between different types(number and text), please try to use the following code of 'add custom column' step, I added text type convert in the formula.

	#"Added Custom" = Table.AddColumn(#"Converted to Table1", "Source", each Json.Document(Web.Contents("https://api.xyz.com/",	
	[
		Headers=[#"Gen-Api-Key"="...."],
		RelativePath="natgas/events/v1/notices/details",
		Query=
		[
			ids=Text.From([Column1]),
			format="json"
		]
	])))

Regards,

Xiaoxin Sheng

Hi Anonymous and all: Good day! I found checking the data in the data base table and Api portal that for some pipes there will be same event posted for different locations [as they are impacted for all those locations for a pipeline]. That's why the multiple location rows are coming for those pipes! So, it's actually not an error/issue, but a fact! So, I am closing this thread. Thanks all for your patience. 🙂