Cloud Elements Version 2.152

February 12, 2018

Element Updates

OneNote: Added DELETE /files endpoint

You can use DELETE /files to delete pages from OneNote notebooks.

JIRA: Added support for LIKE in CEQL and custom fields

You can now use LIKE in CEQL and query on custom fields. Here are some examples:

  • GET /incidents where : summary LIKE 'QBO%'
  • GET /incidents where : customfield_10100 = '1|hzzvw7:'
  • GET /incidents where : customfield_12201 like 'testing new field blah blah'

Google Drive: New /file/comments endpoints

We added the following comments endpoints to the /files resource:

  • GET /files/comments
  • POST /file/comments
  • GET /file/comments/{commentId}
  • PATCH /file/comments/{commentId}
  • DELETE /file/comments/{commentId}

Mailchimp: New GET /campaigns/{id}/open-details endpoint

You can now get detailed information about any campaign emails that were opened by a list member.

Cloud Elements Platform Updates

Common Resources: Add common resources mapped to sub-objects to the API docs

When you transform data from a field that includes sub resources, the common resource appears in the API docs and can make requests to the resource. For example, in the MailChimp element the listsContacts resource is nested in Cloud Elements as lists/{id}/contacts. If you map a field from MailChimp's listsContacts resource to your common resource and add the common resource to the API docs, the request appears as lists/{id}/yourCommonResource.

Bulk: Upload bulk data in JSON

Some elements such as HubSpot, Marketo, Eloqua, and the Salesforce elements did not previously support uploading bulk data via JSON. You can now upload files in JSON format ({"format" : "json"}). Each JSON object should be on a new line or can be an array of JSON objects.

Formula as a Resource status codes

When you create a Formula as a Resource you can specify status codes and descriptions. To include a status code and result in the response to a FaaR request:

  1. In the formula, add a JS Script step as the final step.
  2. Include a script like the following in the step:

      statusCode: xxx
      result: {
        label: 'message'
  3. Save the step.

The status code that you want to return in the response, such as 200, 401, or 502. The value must be a valid status code.
The body of the response which can be anything related to the status code such as an array of objects, a single object, or text. The example above includes an array containing a key value pair with a label and a message.