Markers, User Tokens, and Field References

You can use the markers and field references listed in the tables below to configure the Message body of your webhook.

Markers

You can use the following field markers in the message body of your webhook:

Marker

APPEARS AS

WHAT IT DOES

Examples

The name of this app %appName% Inserts the full name of the app. <field name="app_name">%appName%</field>
 The ID of this app  %appid%  Inserts the app DBID.

<field name="app_id">%appid%</field>

The name of this table   %dbName% Inserts the name of the current table.

<field name="table_name">%dbName%</field>

The ID of this table %dbId% Inserts the table ID that Quick Base automatically assigns to each table.

<field name="table_id">%dbid%</field>

 The name of your Quick Base realm %realmHost% Inserts the subdomain used for your Quick Base realm/account URL

<field name="realm_host">%realmHost%</field>

The ID of your Quick Base realm  %realmid% Inserts the numerical ID for your Quick Base realm.

<field name="realm_id">%realmid%</field>

Begin repeated info for each changed record %RepeatOn% See section below: Process multiple rows in a single event

%RepeatOn%

"%action% Sync Gmail Message ","From: [From.csv]"

%RepeatOff%

End repeated info %RepeatOff% See section below: Process multiple rows in a single event See example for %RepeatOn%
A link to the changed record %reclink% Inserts a link to the changed record <a href="%reclink%">Click here</a>
The change to the record %action% Inserts Add, Replace, or Delete, depending on what action triggered the webhook

%RepeatOn%

"%action% Sync Gmail Message ","From: [From.csv]"

%RepeatOff%

The user who triggered this webhook %curuser% Inserts the name and user ID of the user who triggered the webhook %curuser% performed an action in %dbName%
The date this webhook was triggered %curdate% Inserts the date and time when the webhook was triggered Record was deleted on %curdate%
The ID of this webhook %webhookid% Inserts the numeric ID of the current webhook Triggered by webhook %webhookid%

User Tokens

You can create your own user tokens in Quick Base and use them to run APIs and automation. Many API calls that use a ticket can instead take the usertoken parameter. For example:

%user.token.SalesToken%

When you create a webhook, you are the owner. When you put a user token in the body of the message, it is shown in the message body as %user.token.$your_userid.first token%. For example: %user.token$jsmith.first token% That token appears in the list in the Fields & Markers dropdown, and is translated to the actual user token when the webhook is saved.

When you edit or copy a webhook you don’t own, the user token is shown in the message body as %user.token.$someuserid.first token%. That token does not appear in the list in the Fields & Markers dropdown (only your tokens appear there).

Field references

You can also insert field references to configure your webhook the way you want. Field references act like variables in your message body. For instance, if you might use a field reference to get a value from the "Last Modified By" field.

A field marker is simply the field name enclosed by square brackets, e.g., [LastModifiedBy]. When you click inside either the Endpoint URL or Message body, you'll see a list of valid field references you can use. You can also type these in manually, if you know the field names. But keep in mind, depending on the type of message you're composing, and the insertion point, certain field markers are not valid.

Field reference prefixes

You can use field references to capture the original value from a field (that is, before it was changed). To do so, add the prefix old. in front of the field name, as in [old.status] or [old.description].


  Status changed from [old.status] to [status].

If a user were to change the value in the status field from Open to Closed, this line would be displayed as:


  Status changed from Open to Closed.

Process multiple rows in a single event

In some cases, a single Quick Base event can affect multiple rows of a table. This can happen as a result of:

You can repeat of portion of the message body by surrounding it with the %RepeatOn% and %RepeatOff% markers.

If the format is JSON and the last non-whitespace character in a repeated section is a comma, Quick Base will trim the trailing comma and whitespace for the last repeat. For example, in the following template:

[%repeatOn%[Field1], %repeatOff%]

if Field1 changed in three records, the result would be: 

[Closed, Open, Hold]

Warning:If there are field references that aren't between %repeatOn% and %repeatOff%, and there is a multi-record operation (such as grid edit), the field values will be replaced with the value of the first changed record.

Field reference suffixes

By default, field values are formatted based on the message format you select (XML, JSON, RAW).

If you don't use any suffix, the specified message format is used and provides default escaping. For example, tokens in the URL field are URL-escaped by default and don't require a suffix. Similarly, tokens in the template body are escaped based on the template format (XML, JSON, RAW).

However, you may not always want to use the default formatting. Field suffixes allow you to override the default behavior for each message format. For example, the following use of the .CSV suffix would csv-encode the previous value of the field "My field name":

[old.My field name.csv]

You can append the following suffixes to a field reference: .xml, .json, .csv, .url, ,or .raw. If you append any of these suffixes to the field reference, the field value will be encoded using the specified encoding,not the encoding of the entire message. For example, when you use API_ImportFromCSV, the overall message would be XML, but the record information needs to be CSV-encoded. 

Use these suffixes to escape data for the following formats:

.xml -- Escapes data in an XML document.

.json -- Escapes data in a JSON document.

.csv -- Escapes data in a CSVdocument.

.url -- Escapes data in the query string of a URL.

.raw -- Does not escape any data in the message.

The following table shows how field suffixes are used to reformat special characters.

RAW TEXT .json .xml .CSV

"

\" &quot; """
\ \\    
/ \ /    
<   &lt;  
>   &gt;  
&   &amp;  

Note that for .csv:

Formatting with the.raw and .printable suffixes

The .raw suffix means to not use the JSON or XML formatting. So, if the body is JSON or XML, adding the .raw suffix will ignore the default formatting for the designated field.

Use the .printable suffix to apply default or custom formatting as specified in Quick Base field settings.

Field Type
.raw Result
.printable Result

Date/Time

Formula - Date/Time

Date Created

Date Modified

04-15-2016 10:00 AM (uses fixed format) as specified in field settings: 07-15-2014 05:30 PM (EDT), etc. 

Date

Work Date

Formula - Date

Formula - Work Date

08-20-2014 (uses fixed MM-DD-YYYY format) as specified in field settings: DEC-10-2014, Wednesday, 08-20-2014, etc.

List - User

Formula - List-User

Chris Baker <1001.v2xw>;Colleen Garton <1003.bar3>;Gregory Baxter <1004.bfc9> Chris Baker ; Colleen Garton ; Gregory Baxter
Multi-select Text Selection 1;Selection 4;Selection 8 Selection 1 ; Selection 4 ; Selection 8
Numeric - Currency $32,505 (does not display trailing zeros in decimal places)

as specified in field settings: $32,505.00

Numeric

Formula - Numeric

51,427 (does not display trailing zeros in decimal places)

as specified in field settings:51,427.00

Time of Day

Formula - Time of Day

3:00:00 pm (uses fixed format) as specified in field settings: 2:15 pm, 20:00, etc.

User

Formula - User

Last Modified By

Record Owner

Colleen Garton <1003.bar3> Garton, Colleen, Colleen Garton, cgarton, etc.

File Attachments

The name of the attached file. The name of the attached file.
Related Topics:

 

Go back      |       |   

© 1999-2018  QuickBase, Inc.  All rights reserved.  Legal Notices.