Forum Discussion
A web API key can only be specified when a web API key name is provided
JirkaZ
Humm, I hadn't seen your second link and I just read it and applied the method.
but since I'm very bad at programming, I guess my code doesn't mean anything.
here is my code :
let
SalsifyKey = "pOae0egsjqz12-M5TkZBxuYxzv2DN0cA8Bnalnj3Fqc",
entity_type= product,
ProductList = List.Transform(Product),
each Number.ToText(entity_type),
GetElevations = Web.Contents(https://app.salsify.com/api/orgs/s-ce10487b-d3bb-4ee6-9f40-0b854ab97d15/export_runs?access_token=pOae0egsjqz12-M5TkZBxuYxzv2DN0cA8Bnalnj3Fqc
[Content=Text.ToBinary(PostContents)]),
{
"configuration":{
"entity_type":"product",
"format":"csv",
"filter":"=list:default",
"properties":"'UPC','Product Name','Brand','Main Image','Short Description','Long Description'",
"include_all_columns":false,
"sort_order":"desc",
"sort_property":"Brand"
}
}
in
#"Converted to Table"can you help me
First of all you shouldn't post your auth tokens publically.
Secondly - I checked this API call (export_runs) and it really doesn't return any usable data. It only triggers some kind of data export, but doesn't return the values of the data.
ah sorry , I forgot to blur my identification.
if i understand correctly, i can't extract information from salsify ?
Since you tried, can you send me the M code you wrote
I only tried in Postman to see what it actually returns.
But to your question - you can extract data from Salsify, but apparently using a different api call.ok thanks for the information, I will try to find another solution
can you send me your code for the post call ?