Skip to content

Instantly share code, notes, and snippets.

@splatch
Created June 1, 2022 10:10
Show Gist options
  • Save splatch/88dc8c9d3338c815c03ae145d3bb9c24 to your computer and use it in GitHub Desktop.
Save splatch/88dc8c9d3338c815c03ae145d3bb9c24 to your computer and use it in GitHub Desktop.
OData feed definition for Excel
# If you ever come to that point - official power query docs are not very clear
# on how to append custom headers or query options, here is how
= OData.Feed("https://....", null, [
Implementation="2.0",
Headers=[#"X-API-Token"="xyz",#"X-xyz"="zyx"],
Query=[#"timeZone"="UTC",#"another"="abc"]
])
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment