Writing Data from Construct to Edify Using OAuth2

The Edify OAuth2 integration allows you to write data directly from Construct to an Edify intake schema using the Output node. Once configured, the OAuth2 Edify integration can be reused across jobs and workflows, making it easy to deliver to or refresh data in Edify. This article walks through steps to set up the OAuth2 integration between Construct and Edify.

Create the Construct Application in Edify

1. In Edify, go to User Profile > OAuth2 Applications.
2. Select Create Application.
3. For Template Type, select Construct Integration.
4. Update the application Name if desired, or leave the default name as Construct Application.
5. Leave the remaining fields as they are, then select Save.
6. Copy the Client ID and Client Secret.

Important: The Client Secret is only visible at this point. Save it somewhere secure before leaving this screen. If you do not save the Client Secret, you will need to delete the application and create a new one.

Add the Edify OAuth2 Configuration in Construct

1. In Construct, go to Tools > Options > Edify OAuth2.
2. Select the blue plus sign to add a new Edify integration.
3. In the Edify Site Base URL field, enter your Edify site URL.
   • This should be the same URL you use to log in to Edify, such as:
     https://edify.edh.eab.com
   • Do not enter the Authorization URL or Redirect URL shown in Edify when creating the Construct Application.
4. Enter the Edify OAuth2 Client ID and Edify OAuth2 Client Secret generated in Edify.

5. Save the settings window.

   

6. After saving, the Authorize button will become available. Select Authorize.

7. Construct will open an OAuth2 Authorization Request in Edify. Select Approve.

   

8. You should see a confirmation message that says:
   Login and Authorization complete. You may close this window.
9. Close the browser window and return to Construct.

Write Data from Construct to Edify

1. In your Construct job, add an Output node.

2. For Output Type, select EAB Edify.

   

3. Next to OAuth2 Config, confirm that your Edify site is listed.
   • For example, if your site URL is https://edify.edh.eab.com, the OAuth2 Config name may display as edify.
4. Enter the Table Schema.
   • Note: The schema must already exist in Edify. Entering the name of a schema that does not exist will cause the output to fail.
   • For more information about creating schemas in Edify, see Schemas.
5. Enter the Table Name
   • Note: If you enter the name of an existing table, the existing table data will be overwritten when the job runs.
6. If desired, enter a column name to use as the table’s Primary Key.
   • Note: If no primary key is specified, Construct will add a default pk field using the row count.
7. Save the Output node.
8. Run the Construct job.

The data will be written to the specified Edify intake schema and table.