Once a submission is shared, authorized parties can securely download the submission contents using a time-limited access token.
This token grants temporary, read-only access and automatically expires after a predefined period, ensuring secure and controlled distribution of sensitive information.
The token can be used as a Bearer token in the Authorization header to retrieve submission data via a standard GET request over HTTPS.
This allows integration with any system or tool capable of making HTTPS requests. Below are examples using:
Once you've been shared access to a submission, you can download its contents to Excel through the following steps:
Click the Download button in either the Forms or Grid section of the desired submission.
Click the Generate Token button icon. A token should appear in the input field. Click the Copy as Power Query button. Your clipboard should now contain a script similar to the following:
let
Source = Json.Document(
Web.Contents(
"https://www.boundplatform.ca/api/router/submission-token/",
[
Headers = [
Authorization =
You can reuse query steps for other submissions by parametrizing the token with which the submission is queried, and replacing it with a newly generated token to pull new data as follows:
Using a new submission, generate a new token and copy its value to your clipboard.
In Excel, open the Power Query Editor and in the Parameters section, click Manage Parameters > New Parameter. Create a new parameter with the following details:
TokenOpen Advanced Editor. Find the line where Source is defined (i.e. Source = ..) and replace this line with the following code:
Source = Json.Document(
Web.Contents(
"https://www.boundplatform.ca/api/router/submission-token/"
You can retrieve the submission data using a standard HTTP GET request and your generated access token.
Use the Bearer scheme with your token.
curl -X GET "https://www.boundplatform.ca/api/router/submission-token/" \
-H "Authorization: Bearer YOUR_ACCESS_TOKEN"
In Excel, click Data > Get Data > From Other Sources > Blank Query > Advanced Editor. Delete the text currently in the editor and paste the Power Query script in the editor. Click Done once complete.
If prompted with a Access Web Content window, choose Anonymous and click Save.
Your data should now be successfully loaded into the Power Query Editor. You can filter or transform the data using Power Query. Once properly transformed, click Close & Load to load the data to a new worksheet in your workbook.
You can copy and paste this code directly into the editor. Click Done once finished.
Click Refresh Preview to get the updated data.