Extract information from a Procore object.
This action can be used to execute most Procore API calls that use an HTTP GET request and return a single object (rather than an array of objects). Please refer to the Procore API Reference to find such APIs; most of them begin with the word "Show". Here are just a handful of Procore APIs that you can invoke with this action:
|Required||The Procore API endpoint that you wish to invoke, without the "vapid" prefix. Please refer to the Procore Actions overview for more on the |
|Required (at least one)||The name of a field to be retrieved from the Procore object specified in the |
To reference subfields, use dot notation. For instance, in the Show Company User API, to reference the
|Optional||The data type of the field that was retrieved from Procore using the corresponding |
Refer to the Responses section of your Procore API's documentation to determine which fields are of type
|Optional||The time zone in which any |
This input is unnecessary if no
|The value retrieved by the corresponding |
A common purpose of looking up information from a Procore object is to use it to pre-populate some fields in a GoFormz form or other GoFormz object. For this reason, the Lookup action is typically used in conjunction with actions like Create Form, Update Form, Add Data Source Rows, etc. Those actions then reference the outputs of this Lookup Object step.
Suppose you are using a Procore Webhook to dispatch a GoFormz form when a new Incident is created in Procore, and you want to pre-fill this form with some information. One of the fields you want to pre-fill is the name and contact information of the Safety Manager on the project. Here is how you might go about retrieving this data.
Your workflow would start with the Procore Event trigger, which listens for the Procore Webhook to initiate the workflow. Then you might use the Query action to get information about the project's Safety Manager, and the Filter DataSet and Select DataSet Row actions to extract the Safety Manager's user ID from the DataSet file returned by the Query action. After this, you might use this Lookup Object action with the following inputs:
We use Procore's Show Company User API here. We construct the
apiPath as described in the API documentation, using the company ID output from the Webhook trigger and the Safety Manager's user ID from the selectSafetyManager workflow step to fill in the required path parameters.
Next, we retrieve the fields that we want from the user object —
created_at. Notice that all of these fields can be found in the Responses section of the API documentation. Since the
created_at field is a date/time, we specify its field type as such and also specify the time zone in which we want the date and time to be returned.
Finally, you may end your workflow by creating a new form with Create Form and using the information retrieved by this Lookup Object step to pre-fill the Safety Manager's name and contact information in the appropriate form fields.
Updated over 3 years ago