I am currently working on integrating Pyramid Analytics with Microsoft Power Automate/ aka Microsoft Fabric to automate the retrieval of JSON files generated by Pyramid. Specifically, I have configured a subscription in Pyramid to output reports as JSON files. I then set up a General Webhook for the publication, which provides a link to the content. This setup successfully triggers in Power Automate, and I can extract the link from the webhook.
However, I encounter an issue when attempting to have Power Automate access and retrieve the file from the provided link. Despite using my Pyramid login credentials, I am unable to authorize access to the file through Power Automate.
I would appreciate your guidance on the following:
Authentication Method: Could you please clarify the authentication mechanism Pyramid employs for accessing files via direct URLs? Understanding this will assist me in configuring the appropriate authentication within Power Automate.
Integration Best Practices: Are there recommended practices or specific configurations for integrating Pyramid-generated file links with external automation tools like Power Automate?
For your reference, I typically access Pyramid reports through our partner link. And this may be a root of the problem.
We utilize these sales data to populate an Excel-based tracker that monitors stock balances between two days. Managers have to have a way to enter data and see results through multiple calculations. So this cannot be done on Pyramid Platform.
Is there a chance any of you have any experience with pulling data from link to the file send through Webhook, automatically?
The HTTP request needs to contain the authentication token to be able to download the file from the link received from the publication flow automatically.
After the token is retrieved the following call need to be used:
URL: {{received_url_from_webhook}}
METHOD: GET
HEADER: name: Cookie
value: PyramidAuth={{token_from_api}}
example using curl:
curl -X GET \
-H "Cookie: PyramidAuth={{token_from_api}}" \
"{{received_url_from_webhook}}"
Lukas_Beres
4 days ago
Reported - view
Thanks a million for coming back to me. Unfortunately is looking like API is blocked for me. Im getting error: 500 Server Error See example of python code i used to test few different authorisation method's. Response: