Bulk Sync API

A new API (POST to /api/bulk/sync) allows bulk creation, updating, and inactivation of documents using CSV data.

This can be used to keep a list of data in Execute synchronized with an external system. Any tool that can extract data as a CSV file and perform an HTTP POST will now be able to update Execute data.

Example Usage

The API is reached at https://YOUR_SERVER/api/bulk/sync?type=PARTNER&dryrun=true.

Authentication uses Execute API Keys via HTTP Basic Auth.

The type= query parameter is required and indicates which Execute document type will be updated.

Other parameters are available to control the sync behaviour, see the documentation.

The dryrun=true parameter is useful for testing — it runs the full sync and returns a report of what would happen without making any changes to the data. Remove it (or set it to false) when ready to commit.

Each row in the CSV identifies one or more documents and provides value columns to update the data on the matched document(s).

The CSV header row contains the field path for each column. Columns prefixed with $ are key columns used to find matching documents; the remaining columns are the values to update.

Here is a CSV for Execute PARTNER data which will match on the partner code to update the name and address.

COMNAME,$CODE,STRADDRESS
Sesame Exploration,39,123 Sesame Street
Micro Eggbert Oil,12,"1111, 111 - 1st Avenue S.W."
Example Ltd.,10,"3300, 333.3 - 3rd Avenue S.W."

It could be sent to the Execute API with curl like so:

curl -u "$APIKEY_ID:$APIKEY_KEY" \
  -X POST "https://YOUR_SERVER/api/bulk/sync?type=PARTNER&dryrun=true" \
  -H "Content-Type: text/csv" \
  --data-binary @sample.csv

With dryrun=true, the response shows what would happen without making any changes:

Record,Level,Message
1,Info,DRY RUN: Would update document a1b2c3d4-...
2,Info,DRY RUN: Would update document b2c3d4e5-...
3,Info,DRY RUN: Would update document c3d4e5f6-...
Summary,Info,"Summary: 0 created, 3 updated, 0 unchanged, 0 inactivated, 0 errors, 0 warnings"

Once the results look correct, remove dryrun=true to commit the changes. The response will then confirm what was actually updated:

Record,Level,Message
1,Info,Updated document a1b2c3d4-...
2,Info,Updated document b2c3d4e5-...
3,Info,Updated document c3d4e5f6-...
Summary,Info,"Summary: 0 created, 3 updated, 0 unchanged, 0 inactivated, 0 errors, 0 warnings"

Interrupted Schedule Activities

Schedule activities can now be set as interruptible or non-interruptible (Tools > Configuration > Schedule Activity Types). If an activity is interruptible, the activity’s duration will extend when it overlaps an exclusion period on the primary resource.

For example: An activity with a 4 day duration is assigned a primary resource that is not available on a weekend.

• If the activity starts on a Monday, the activity runs on Monday, Tuesday, Wednesday, Thursday.
• If the activity starts on a Thursday, the activity runs Thursday, Friday, takes the weekend off, and continues Monday and Tuesday.

The Duration field on the activity does not change as it will continue to show the “actual” duration of the work. When viewing the content on the activity, you would see an elapsed duration that includes the time that the resource is unavailable.

A Job that is linked to an interrupted activity will show the elapsed duration (see example of linked Job below).

An interrupted schedule activity that is linked to a capital activity on a project will cause the project to appear in the Due for Forecast list, as the timing for the activity has changed.

Rystad Integration

The Rystad integration requires a subscription to Rystad Energy but there is no additional licensing required for Execute.

At a high level, the integration allows Execute to:

1. Query capital data from Rystad and load that data to a Cost Well entity (or a document if we’re using Execute lingo!)

The input parameters used for the query and the resulting costs are written to tables on the Cost Well. The costs are organized in categories that we refer to as Cost Well Categories.

2. For an AFE, the GL accounts are mapped to Cost Well Categories. Then, you can link a Cost Well to your AFE and validation messages appear if the AFE’s estimate is under or exceeds the costs in the Cost Well.

3. For a Project, Cost Well Categories are mapped to project activity types. By linking a Cost Well to a Project, validation messages are displayed if your costs do not align with the mapped cost well category.

This doesn’t replace the current detailed estimation process that our customers use today. This isn’t authoring the estimate. The goal is context and confidence, not replacing engineering judgment.