Issue
When running an Automation Process, we are getting an error similar to the following
- "Error calling foundry: Request failed with status code 500"
- "Error calling foundry: Request failed with status code 502"
Cause
This may be caused by one of the following reasons:
- If creating an Excel Spreadsheet, the file has been configured to use Merge Fields, but the Merge Names option is toggled on in FYI instead, or vice versa.
- A temporary issue with Microsoft Graph API.
Solution
Update the Spreadsheet Template
Merging data from FYI into a spreadsheet can be done in one of two ways:
If your document has been set up to use Merge Fields, but in FYI has been enabled for Merge Names, an error will be displayed when creating the document. You will need to update the configuration in FYI to ensure the correct Merge option is selected.
- In FYI, click the Knowledge menu.
- Click the Template to open the Spreadsheet drawer.
- Expand the Filing section.
- Check the settings for the Merge Fields and Merge Names options, and update as required.
Note: Only one of these should be toggled on at one time; enabling both will result in an error when generating the document.
- Re-try creating the document.
Re-run the Automation
Re-run the FYI Automation as follows:
- Navigate to the Process History (refer to Automation History).
- Filter the Status column to “Error”.
- Select the process(es) that have failed.
- Click the Retry button in the toolbar at the top.
- The automation will run again from the last failed step of the process.
If you are still receiving the error please contact FYI support.