... | ... | @@ -69,7 +69,10 @@ To select (firstname, lastname) record fields of Module for matching email (=[te |
|
|
<where>
|
|
|
<field name="email" condition="eq" value="[email protected]"> </field>
|
|
|
</where>
|
|
|
<limit max="1"></limit>
|
|
|
<sort>
|
|
|
<field name="annualrevenue" order="desc"></field>
|
|
|
</sort>
|
|
|
<limit max="10"></limit>
|
|
|
</select>
|
|
|
</api>
|
|
|
```
|
... | ... | @@ -78,7 +81,7 @@ Condition in where clause supports below options |
|
|
|
|
|
| Condition | Description |
|
|
|
| -------- | -------- |
|
|
|
| eq | Equals (=) |
|
|
|
| eq | Equals (=), defaults if not passed |
|
|
|
| neq | Not Equals (!=) |
|
|
|
| gt | Greater Than (>) |
|
|
|
| lt | Less Than (<) |
|
... | ... | @@ -186,12 +189,12 @@ To replace email field value with incoming parameter (new_email) on all Contacts |
|
|
<record>
|
|
|
<field name="email" value="@new_email"></field>
|
|
|
</record>
|
|
|
<return>
|
|
|
<field name="id"></field>
|
|
|
</return>
|
|
|
<where>
|
|
|
<field name="email" condition="eq" value="@old_email"></field>
|
|
|
</where>
|
|
|
<return>
|
|
|
<field name="id"></field>
|
|
|
</return>
|
|
|
</update>
|
|
|
</api>
|
|
|
```
|
... | ... | @@ -245,6 +248,45 @@ You can update and create in one single api |
|
|
</api>
|
|
|
```
|
|
|
|
|
|
#### Update a record and add a mention
|
|
|
|
|
|
```
|
|
|
<?xml version="1.0" ?>
|
|
|
<api method="POST">
|
|
|
<update>
|
|
|
<record>
|
|
|
<field name="leadsource" value="Facebook" presence="optional"></field>
|
|
|
</record>
|
|
|
<where>
|
|
|
<field name="status" value="Active"></field>
|
|
|
</where>
|
|
|
<return>
|
|
|
<field name="id"></field>
|
|
|
</return>
|
|
|
<mention>
|
|
|
<template>
|
|
|
<![CDATA[
|
|
|
<br>
|
|
|
<table>
|
|
|
<tr>
|
|
|
<td>Marketing Channel: %s</td></tr>
|
|
|
<tr>
|
|
|
<td>New lead created from Facebook: %s</td>
|
|
|
</tr>
|
|
|
</table>
|
|
|
]]>
|
|
|
</template>
|
|
|
<values>
|
|
|
<value name="fld_marketingchannel"></value>
|
|
|
<value name="email"></value>
|
|
|
</values>
|
|
|
<text>
|
|
|
//either use template or text, one of them.
|
|
|
</text>
|
|
|
</mention>
|
|
|
</update>
|
|
|
</api>
|
|
|
```
|
|
|
|
|
|
|
|
|
#### Invoke HTTP Rest API
|
... | ... | |