Forum Discussion
Api Connection with methods and token
Hello, try this in PQ:
let
// Token and API URL
apiUrl = "https://api.baselinker.com/connector.php",
tokenHeader = [X-BLToken = ""],
// Request headers
headers = [#"Content-Type"="application/x-www-form-urlencoded"] & tokenHeader,
// Request data
requestData = [
method = "getOrders",
parameters = "{""date_from"": 1692223200}"
],
// Convert request data to form-urlencoded
formData = "method=" & Uri.EscapeDataString(requestData[method]) & "¶meters=" & Uri.EscapeDataString(requestData[parameters]),
// Create the request
source = Web.Contents(apiUrl, [Headers=headers, Content=Text.ToBinary(formData)]),
// Convert response to text
responseText = Text.FromBinary(source),
// Parse JSON response
jsonResponse = Json.Document(responseText)
in
jsonResponse
You must change token and date