Create a duplicate of an existing spreadsheet.

These Headers are ignored if a "Spreadsheet to Copy" is selected.

The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.

Use a search step before this to get the row to delete.

API docs for Google Sheets are located here https://developers.google.com/sheets/api/reference/rest

Requests can only be made to domains associated by this application.

These params will be URL-encoded and appended to the URL when making the request.

Authentication headers are included automatically

Zapier will apply these optional headers and values to the request in addition to any headers created as part of the authentication mechanism.

Zapier will pass this along raw. If you would like to provide complex JSON, try a "Code by Zapier" step to build the structure and pass it along here. For example, {"foo": "bar"} is perfectly valid.

The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.

Value of the Worksheet Title to match exactly. Search is case-sensitive.

The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.

You must have column headers. See here for more information.

Specify the column we should search for cells which match the Lookup Value.

Optionally, specify another column you want to search by. Note that if you supply this, the Zap will trigger only on rows that match both columns. (An example column might be something like Email Address or Phone Number)

An example value might be me@example.com or 555-5555

Search from bottom of the sheet? In other words, pick the most recent match?

The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.

You must have column headers. See here for more information.

Specify the column we should search for cells which match the Lookup Value.

Optionally, specify another column you want to search by. Note that if you supply this, the Zap will trigger only on rows that match both columns. (An example column might be something like Email Address or Phone Number)

An example value might be me@example.com or 555-5555

Search from bottom of the sheet? In other words, pick the most recent match?

Choose yes to trigger when someone creates a new name for an existing emoji.

Linked mentions of this user will trigger the zap. Make sure to specify a value for one or both of username or a highlight word. Specifying both a username and a highlight word means that both the linked username and word need to be included in a message to trigger the zap.

Mentions of this word will trigger the zap. Case insensitive. Make sure to specify a value for one or both of username or a highlight word. Specifying both a username and a highlight word means that both the linked username and word need to be included in a message to trigger the zap.

If no, only messages sent by users will trigger the Zap. If yes, messages sent by users and slackbots will trigger the Zap.

Warning: Slackbots don't have profiles. If yes, don't depend on user profile information being present. Also, avoid Zap loops where Zaps trigger and post slackbot messages to the same channel!

The actual reminder text that should be sent to yourself or a user. To include URLs, Slack uses this syntax.

Slack parses natural language like "in 15 minutes" or "every Thursday". Times are relative to when the Zap actually runs.

Pick a user to remind. If you pick no one, you will be reminded.

Only channels you are a member of will appear in this list. If you can't find your channel, click the Load More button or switch to the Custom tab and enter the channel's ID. Once live, the trigger will work even if you are not a member of the channel.

Specify text of the message to send. Check out the formatting help doc for advanced options.

If you choose no, this message will appear to come from you. Direct messages are always sent by bots.

Specify the bot name which appears as a bold username above the message inside Slack. Defaults to Zapier. When using Schedule At, this field will be ignored by slack.

Either an image url or an emoji available to your team (surrounded by :). For example, https://site.com/icon_256.png or :robot_face:. When using Schedule At, this field will be ignored by slack.

If you choose yes, a link to this Zap will be added to the end of the message, making it easy for you and your team to edit the Zap with one click.

If specified, this will upload the given image URL to Slack and attach it to the message separately.

Should Slack try to automatically expand links in this message? For example: turn a YouTube link into a playable widget.

If no, any usernames and channels mentioned won't be linked (or mentioned). Also affects @channel and @group. Unfortunately, @here notifications cannot be sent by Zapier.

Schedule the message to be posted later. Cannot be more than 120 days in the future. If you do schedule a message, rather than post it immediately, this Zap step will not return a ts or permalink field. This option does not support Bot Name and Bot Icon customization and will default to Zapier as bot name and icon.

Include a file to send along with your message. NOTE: Bot names/icons cannot be customized when sending a File.

If you want this to be part of a thread, you'll need the timestamp (Ts) of the parent message. For example: 1345232312616.1231232.

If you get the message from a trigger, select "use a custom value" from the dropdown and connect accordingly by selecting the Ts field.

Otherwise, add a search step and fetch the message you want.

If true, posts in the thread and channel. See here for more info. Ignored unless the message is part of a thread.

Name for the channel to be created. Channel names are normalized by converting to lowercase, replacing any non-allowed characters with hyphens or underscore, and truncating to 80 characters.

Slack will auto-link @names and #channels where applicable.

Leave empty to clear.

Use any emoji that's available in your Slack team, with leading and trailing :.

If emoji is blank when text isn't, :speech_balloon: is used by default. If both text and emoji are empty, your status will be cleared.

Provide a specific date & time for this status to expire. Statuses will not expire by default.

You can also specify a duration for this status by entering in a value like in 60 minutes, for example. Check out other ways you can use this field here.

Search query to use for finding matching messages. See the Slack Search Documentation for more information on constructing a query.

Sort messages by their match strength or by their date. Default is score.

Sort matching messages in ascending or descending order. Default is descending.

Search is case-insensitive

For most responses, we prettify the result we get from Slack. If we're missing a field you're expecting, set this to true

The leading @ is optional

For most responses, we prettify the result we get from Slack. If we're missing a field you're expecting, set this to true

The type to associate the participant with.

The two letter country code (US = United States, AU = Australia, NZ = New Zealand etc). If omitted will default to the country of your organization's participant/contact record.

The two letter country code (US = United States, AU = Australia, NZ = New Zealand etc). If omitted will default to the country of your organization participant record.

For example, an international phone number format +64 234 5678 has "64" as the country code, "234" as the local area code and "5678" as the local phone number.

For example, an international phone number format +64 234 5678 has "64" as the country code, "234" as the local area code and "5678" as the local phone number.

The local phone number (excludes country code and local area code). For example, an international phone number format +64 234 5678 has "64" as the country code, "234" as the local area code and "5678" as the local phone number.

Optional - if using multiple divisions, set this to specify which division this contact record belongs to.

For example, an international phone number format +64 234 5678 has "64" as the country code, "234" as the local area code and "5678" as the local phone number.

For example, an international phone number format +64 234 5678 has "64" as the country code, "234" as the local area code and "5678" as the local phone number.

The local phone number (excludes country code and local area code). For example, an international phone number format +64 234 5678 has "64" as the country code, "234" as the local area code and "5678" as the local phone number.

For example, an international phone number format +64 234 5678 has "64" as the country code, "234" as the local area code and "5678" as the local phone number.

For example, an international phone number format +64 234 5678 has "64" as the country code, "234" as the local area code and "5678" as the local phone number.

The local phone number (excludes country code and local area code). For example, an international phone number format +64 234 5678 has "64" as the country code, "234" as the local area code and "5678" as the local phone number.

For example, an international phone number format +64 234 5678 has "64" as the country code, "234" as the local area code and "5678" as the local phone number.

For example, an international phone number format +64 234 5678 has "64" as the country code, "234" as the local area code and "5678" as the local phone number.

The local phone number (excludes country code and local area code). For example, an international phone number format +64 234 5678 has "64" as the country code, "234" as the local area code and "5678" as the local phone number.

An arbitrary string value you can assign to this participant (contact).

Follows the full name of an Individual participant/contact. (e.g. MD, Ph.D.).

The two letter country code (US = United States, AU = Australia, NZ = New Zealand etc). If omitted will default to the country of your organization's participant/contact record.

The two letter country code (US = United States, AU = Australia, NZ = New Zealand etc). If omitted will default to the country of your organization participant record.

For example, an international phone number format +64 234 5678 has "64" as the country code, "234" as the local area code and "5678" as the local phone number.

For example, an international phone number format +64 234 5678 has "64" as the country code, "234" as the local area code and "5678" as the local phone number.

The local phone number (excludes country code and local area code). For example, an international phone number format +64 234 5678 has "64" as the country code, "234" as the local area code and "5678" as the local phone number.

Optional - if using multiple divisions, set this to specify which division this contact record belongs to.

For example, an international phone number format +64 234 5678 has "64" as the country code, "234" as the local area code and "5678" as the local phone number.

For example, an international phone number format +64 234 5678 has "64" as the country code, "234" as the local area code and "5678" as the local phone number.

The local phone number (excludes country code and local area code). For example, an international phone number format +64 234 5678 has "64" as the country code, "234" as the local area code and "5678" as the local phone number.

For example, an international phone number format +64 234 5678 has "64" as the country code, "234" as the local area code and "5678" as the local phone number.

For example, an international phone number format +64 234 5678 has "64" as the country code, "234" as the local area code and "5678" as the local phone number.

The local phone number (excludes country code and local area code). For example, an international phone number format +64 234 5678 has "64" as the country code, "234" as the local area code and "5678" as the local phone number.

For example, an international phone number format +64 234 5678 has "64" as the country code, "234" as the local area code and "5678" as the local phone number.

For example, an international phone number format +64 234 5678 has "64" as the country code, "234" as the local area code and "5678" as the local phone number.

The local phone number (excludes country code and local area code). For example, an international phone number format +64 234 5678 has "64" as the country code, "234" as the local area code and "5678" as the local phone number.

An arbitrary string value to assign to this participant/contact.

The matter id to which this disbursement should be linked.

The date applicable to this disbursement.

Description for this disbursement.

The quantity for this disbursement.

The unit price for this disbursement.

Does the unit price specified include tax? Valid values are T or F.

The unique id for the tax code applicable to this disbursement.

The unique id for this company contact.

The name of the company, organisation, or business.

The first line of the company's physical address.

The second line of the company's physical address.

The city of the company's physical address.

The state or province for the company's physical address.

The zip or postal code for the company's physical address.

The country for the company's physical address.

The first line of the company's mailing address.

The second line of the company's mailing address.

The city of the company's mailing address.

The state or province for the company's mailing address.

The zip or postal code for the company's mailing address.

The country for the company's mailing address.

The label to be assigned to the company's first phone number.

The country for the company's first phone number.

The area code for the company's first phone number.

The number for the company's first phone number.

Any notes for the company's first phone number.

The company's fax number.

The company's SMS number.

The company's email address.

The Company's website address.

The label to be assigned to the company's second phone number.

The country for the company's second phone number.

The area code for the company's second phone number.

The number for the company's second phone number.

Any notes for the company's second phone number.

The label to be assigned to the company's third phone number.

The country for the company's third phone number.

The area code for the company's third phone number.

The number for the company's third phone number.

Any notes for the company's third phone number.

The label to be assigned to the company's fourth phone number.

The country for the company's fourth phone number.

The area code for the company's fourth phone number.

The number for the company's fourth phone number.

Any notes for the company's fourth phone number.

An arbitrary string value to assign to this participant/contact.

The unique Id for the contact (participant) you wish to update.

The salutation for the contact

The contact's first name.

The contact's middle name(s).

The contact's last name.

Follows the full name of an Individual participant/contact (e.g. MD, Ph.D.).

The contact's preferred name.

The first line of the contact's physical address.

The second line of the contact's physical address.

The city of the contact's physical address.

The state or province for the contact's physical address.

The ZIP or postal code for the contact's physical address.

The country code for the contact's physical address.

The first line of the contact's mailing address.

The second line of the contact's mailing address.

The city of the contact's mailing address.

The state or province of the contact's mailing address.

The zip or postal code of the contact's mailing address.

The country code for the contact's mailing address.

The label to assign to the contact's first phone number.

The country code for the contacts first phone number.

The area code for the contact's first phone number.

The number for the contact's first phone number.

Any notes for the contact's first phone number.

The fax number for this contact.

The SMS number for this contact.

The email address for this contact.

The website address for this contact.

The occupation for this contact.

The birthday for this contact.

The date of death for this contact.

The marital status for this contact.

The gender for this contact.

The label to assign to the contact's second phone number.

The country code for the contact's second phone number.

The area code for the contact's second phone number.

The number for the contact's second phone number.

Any notes for the contact's second phone number.

The label to assign to the contact's third phone number.

The country code for the contact's third phone number.

The area code for the contact's third phone number.

The number for this contact's third phone number.

Any notes for this contact's third phone number.

The label to assign to the contact's fourth phone number.

The county code for this contact's fourth phone number.

The area code for the contact's fourth phone number.

The number for the contact's fourth phone number.

Any notes for this contact's fourth phone number.

An arbitrary string value to be assigned to this participant/contact.

Enter the custom field value id for the custom field value you want to update.

The value you want to assign to this custom field value.

Enter the name of the custom field you would like to search for.

Enter the custom field id.

Enter the matter id.

The property of a matter on which you want to search. For example, name, status, or reference.

The value you are looking for.

The participant/contact ID of whom the action/matter will be assigned to. If omitted, it will default to the current API user.

File reference can be used for cross-referencing an action/matter between Actionstep and another system.

An arbitrary value you can attach to a created matter.

The property of a participant on which you want to search. For example, firstName, or lastName.

Set participant/contact as a Company or an Individual.

Required for a Company participant/contact. Optional for an Individual participant/contact. This serves as the Employer field if used on an Individual.

Not used by Company participant/contact.

Not used by Company participant/contact.

Required for an Individual participant/contact. Not used by Company participant/contact.

Follows the full name of an Individual participant/contact. (e.g. MD, Ph.D.). Not used by Company participant/contact.

Not used by Company participant/contact.

The two letter country code (US = United States, AU = Australia, NZ = New Zealand etc). If omitted will default to the country of your organization's participant/contact record.

The two letter country code (US = United States, AU = Australia, NZ = New Zealand etc). If omitted will default to the country of your organization participant record.

For example, an international phone number format +64 234 5678 has "64" as the country code, "234" as the local area code and "5678" as the local phone number.

For example, an international phone number format +64 234 5678 has "64" as the country code, "234" as the local area code and "5678" as the local phone number.

The local phone number (excludes country code and local area code). For example, an international phone number format +64 234 5678 has "64" as the country code, "234" as the local area code and "5678" as the local phone number.

Not used by Company participant/contact.

Optional - if using multiple divisions, set this to specify which division this contact record belongs to.

For example, an international phone number format +64 234 5678 has "64" as the country code, "234" as the local area code and "5678" as the local phone number.

For example, an international phone number format +64 234 5678 has "64" as the country code, "234" as the local area code and "5678" as the local phone number.

The local phone number (excludes country code and local area code). For example, an international phone number format +64 234 5678 has "64" as the country code, "234" as the local area code and "5678" as the local phone number.

For example, an international phone number format +64 234 5678 has "64" as the country code, "234" as the local area code and "5678" as the local phone number.

For example, an international phone number format +64 234 5678 has "64" as the country code, "234" as the local area code and "5678" as the local phone number.

The local phone number (excludes country code and local area code). For example, an international phone number format +64 234 5678 has "64" as the country code, "234" as the local area code and "5678" as the local phone number.

For example, an international phone number format +64 234 5678 has "64" as the country code, "234" as the local area code and "5678" as the local phone number.

For example, an international phone number format +64 234 5678 has "64" as the country code, "234" as the local area code and "5678" as the local phone number.

The local phone number (excludes country code and local area code). For example, an international phone number format +64 234 5678 has "64" as the country code, "234" as the local area code and "5678" as the local phone number.

An arbitrary data value to store against this participant.

The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.

If a worksheet with the specified title exists, its content would be lost. Please, use with caution.

The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.

If you want to update the same row each time select a row from the dropdown box. To dynamically update the row, click open the dropdown and choose the "Custom" tab, then the "Add a search step" button.

Choose from your current custom Theme Color in your Spreadhseet, or enter a color #rrggbb in hexadecimal format.

Choose from your current custom Theme Color in your Spreadhseet, or enter a color #rrggbb in hexadecimal format.

True if the text is bold.

True if the text is italicized.

True if the text is strikethrough.

The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.

You must have column headers. See here for more information.

Let us know which column you want to search by with the value below. We will grab the latest matching row and give you all of its values.

Optionally, specify another column you want to search by. Note that if you supply this, the Zap will trigger only on rows that match both columns. (An example column might be something like Email Address or Phone Number)

An example value might be me@example.com or 555-5555

Search from bottom of the sheet?

Number of rows to return. Max is 500.

The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.

You must have column headers. See here for more information.

Let us know which columns to return. e.g. A:Z

Number of rows to return. Max is 500.

Number of the first row to return (1 is the header)

The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.

Value of the Worksheet Title to match exactly. Search is case-sensitive.

If a worksheet with the specified title exists, its content would be lost. Please, use with caution.

If no, only messages sent by users will trigger the Zap. If yes, messages sent by users and slackbots will trigger the Zap.

Warning: Slackbots don't have profiles. If yes, don't depend on user profile information being present. Also, avoid Zap loops where Zaps trigger and post slackbot messages to the same channel!

Only channels you are a member of will appear in this list. If you can't find your channel, click the Load More button or switch to the Custom tab and enter the channel's ID. Once live, the trigger will work even if you are not a member of the channel. Note: This trigger only supports attachment information for messages generated by bots. If you need to retrieve attachment information from non-bots, see this help document.

If no, only messages sent by users will trigger the Zap. If yes, messages sent by users and slackbots will trigger the Zap.

Warning: Slackbots don't have profiles. If yes, don't depend on user profile information being present. Also, avoid Zap loops where Zaps trigger and post slackbot messages to the same channel!

Only channels you are a member of will appear in this list. If you can't find your channel, click the Load More button or switch to the Custom tab and enter the channel's ID. Once live, the trigger will work even if you are not a member of the channel.

Trigger on files created by a single user.

Trigger when files are shared with you. Please note that this will trigger on created files as well.

Only channels you are a member of will appear in this list. If you can't find your channel, click the Load More button or switch to the Custom tab and enter the channel's ID. Once live, the trigger will work even if you are not a member of the channel.

If no, only messages sent by users will trigger the Zap. If yes, messages sent by users and slackbots will trigger the Zap.

Warning: Slackbots don't have profiles. If yes, don't depend on user profile information being present. Also, avoid Zap loops where Zaps trigger and post slackbot messages to the same channel!

Only triggers when this reaction is added to a message. Use the dropdown to select one of your team's custom emoji or select Use a Custom Value and enter the name of a standard emoji. Use this cheat sheet for reference and be sure not to include the colons. Note that you cannot use an emoji's alias in this field.

Only triggers on reactions added on messages in this public channel. Only channels you are a member of will appear in this list. If you can't find your channel, click the Load More button or switch to the Custom tab and enter the channel's ID. Once live, the trigger will work even if you are not a member of the channel.

Only triggers on reactions added by this user.

Toggle to send to multiple users.

Specify text of the message to send. Check out the formatting help doc for advanced options.

If you choose no, this message will appear to come from you. Direct messages are always sent by bots.

Specify the bot name which appears as a bold username above the message inside Slack. Defaults to Zapier. When using Schedule At, this field will be ignored by slack.

Either an image url or an emoji available to your team (surrounded by :). For example, https://site.com/icon_256.png or :robot_face:. When using Schedule At, this field will be ignored by slack.

If you choose yes, a link to this Zap will be added to the end of the message, making it easy for you and your team to edit the Zap with one click.

If specified, this will upload the given image URL to Slack and attach it to the message separately.

Should Slack try to automatically expand links in this message? For example: turn a YouTube link into a playable widget.

If no, any usernames and channels mentioned won't be linked (or mentioned). Also affects @channel and @group. Unfortunately, @here notifications cannot be sent by Zapier.

Schedule the message to be posted later. Cannot be more than 120 days in the future. If you do schedule a message, rather than post it immediately, this Zap step will not return a ts or permalink field. This option does not support Bot Name and Bot Icon customization and will default to Zapier as bot name and icon.

Only channels you are a member of will appear in this list. If you can't find your channel, click the Load More button or switch to the Custom tab and enter the channel's ID. Once live, the trigger will work even if you are not a member of the channel.

Specify text of the message to send. Check out the formatting help doc for advanced options.

If you choose no, this message will appear to come from you. Direct messages are always sent by bots.

Specify the bot name which appears as a bold username above the message inside Slack. Defaults to Zapier. When using Schedule At, this field will be ignored by slack.

Either an image url or an emoji available to your team (surrounded by :). For example, https://site.com/icon_256.png or :robot_face:. When using Schedule At, this field will be ignored by slack.

If you choose yes, a link to this Zap will be added to the end of the message, making it easy for you and your team to edit the Zap with one click.

If specified, this will upload the given image URL to Slack and attach it to the message separately.

Should Slack try to automatically expand links in this message? For example: turn a YouTube link into a playable widget.

If no, any usernames and channels mentioned won't be linked (or mentioned). Also affects @channel and @group. Unfortunately, @here notifications cannot be sent by Zapier.

Schedule the message to be posted later. Cannot be more than 120 days in the future. If you do schedule a message, rather than post it immediately, this Zap step will not return a ts or permalink field. This option does not support Bot Name and Bot Icon customization and will default to Zapier as bot name and icon.

Include a file to send along with your message. NOTE: Bot names/icons cannot be customized when sending a File.

If you want this to be part of a thread, you'll need the timestamp (Ts) of the parent message. For example: 1345232312616.1231232.

If you get the message from a trigger, select "use a custom value" from the dropdown and connect accordingly by selecting the Ts field.

Otherwise, add a search step and fetch the message you want.

If true, posts in the thread and channel. See here for more info. Ignored unless the message is part of a thread.

Fields left blank will be ignored.

Fields left blank will be ignored.

Fields left blank will be ignored.

Changing a user's email address will send an email to both the old and new addresses, and also post a slackbot to the user informing them of the change.

Update selected values on this user's profile. This argument may only be specified by team admins on paid teams. Defaults to your status, when blank.

Note: Zapier's Slack app supports a limited set of OAuth scopes/permissions, thus many of Slack's API endpoints aren't currently feasible.

API docs for Slack are located here https://api.slack.com/methods

Requests can only be made to domains associated by this application.

These params will be URL-encoded and appended to the URL when making the request.

Authentication headers are included automatically

Zapier will apply these optional headers and values to the request in addition to any headers created as part of the authentication mechanism.

Zapier will pass this along raw. If you would like to provide complex JSON, try a "Code by Zapier" step to build the structure and pass it along here. For example, {"foo": "bar"} is perfectly valid.

Search is case-insensitive

For most responses, we prettify the result we get from Slack. If we're missing a field you're expecting, set this to true

We search the normalized name, so don't worry about accents

For most responses, we prettify the result we get from Slack. If we're missing a field you're expecting, set this to true

The participant/contact ID of whom the action/matter will be assigned to. If omitted, it will default to the current API user.

File reference can be used for cross-referencing an action/matter between Actionstep and another system.

An arbitrary value you can attach to a created matter.

The action/matter to associate the file note with.

The Rate Sheet ID to assign to this task (leave blank for non-billable tasks).

The Participant ID that the task is to be assigned to.

The Action ID to associate the task with.

The name of the tas.

The status of the Task.

The priority of the Task.

The Due Date/time for the task being created.

The actual number of hours (decimal value, ie 1.5 = 1 hour 30 minutes) worked for this task (use 0 when task status is 'Not Started').

The number of hours worked (as a decimal) that should be billed for this task (use 0 for non-billable tasks or incomplete tasks).

The date/time the task was Started (only required if the task status is 'Complete' or 'In Progress').

The date/time the task was Completed (only required when the task Status is 'Complete').

The description (or additional information) of the task being created.

Date applicable to this time entry.

The description for this time entry

The number of actual hours (specified as a decimal, e.g. 1.50) for this time entry.

The number of billable hours (specified as a decimal, e.g. 2.50) for this time entry.

The rate applicable to this time entry.

The id of the matter to which this time entry is related.

The unique identifier for the matter file note you wish to update.

The content you wish to update the file note with.

The unique id for the matter to be updated.

The participant to which this matter is assigned.

The name for this matter.

The status for this matter.

The reference for this matter.

The priority for this matter.

An arbitrary string value to assign to this matter.

The unique Id for the task you wish to update.

The status for the task.

The priority for the task.

The Participant Id that the task is to be assigned to.

The date this task is due.

The actual number of hours worked for this task (use 0 when task status is 'Not Started'). Specify as a decimal value, i.e. 1.5 = 1 hour 30 minutes.

The number of hours worked (as a decimal) that should be billed for this task (use 0 for non-billable tasks or incomplete tasks).

The date/time the task was Completed (only required when the task Status is 'Complete').

Enter the code for the tax code record you are searching for, e.g. "Z", or "N-T"

The property of a participant on which you want to search. For example, firstName, or lastName.

Set participant/contact as a Company or an Individual.

Required for a Company participant/contact. Optional for an Individual participant/contact. This serves as the Employer field if used on an Individual.

Not used by Company participant/contact.

Not used by Company participant/contact.

Required for an Individual participant/contact. Not used by Company participant/contact.

Follows the full name of an Individual participant/contact. (e.g. MD, Ph.D.). Not used by Company participant/contact.

Not used by Company participant/contact.

The two letter country code (US = United States, AU = Australia, NZ = New Zealand etc). If omitted will default to the country of your organization's participant/contact record.

The two letter country code (US = United States, AU = Australia, NZ = New Zealand etc). If omitted will default to the country of your organization participant record.

For example, an international phone number format +64 234 5678 has "64" as the country code, "234" as the local area code and "5678" as the local phone number.

For example, an international phone number format +64 234 5678 has "64" as the country code, "234" as the local area code and "5678" as the local phone number.

The local phone number (excludes country code and local area code). For example, an international phone number format +64 234 5678 has "64" as the country code, "234" as the local area code and "5678" as the local phone number.

Not used by Company participant/contact.

Optional - if using multiple divisions, set this to specify which division this contact record belongs to.

For example, an international phone number format +64 234 5678 has "64" as the country code, "234" as the local area code and "5678" as the local phone number.

For example, an international phone number format +64 234 5678 has "64" as the country code, "234" as the local area code and "5678" as the local phone number.

The local phone number (excludes country code and local area code). For example, an international phone number format +64 234 5678 has "64" as the country code, "234" as the local area code and "5678" as the local phone number.

For example, an international phone number format +64 234 5678 has "64" as the country code, "234" as the local area code and "5678" as the local phone number.

For example, an international phone number format +64 234 5678 has "64" as the country code, "234" as the local area code and "5678" as the local phone number.

The local phone number (excludes country code and local area code). For example, an international phone number format +64 234 5678 has "64" as the country code, "234" as the local area code and "5678" as the local phone number.

For example, an international phone number format +64 234 5678 has "64" as the country code, "234" as the local area code and "5678" as the local phone number.

For example, an international phone number format +64 234 5678 has "64" as the country code, "234" as the local area code and "5678" as the local phone number.

The local phone number (excludes country code and local area code). For example, an international phone number format +64 234 5678 has "64" as the country code, "234" as the local area code and "5678" as the local phone number.

An arbitrary data value to store against this participant.

Set participant/contact as a Company or an Individual.

Required for a Company participant/contact. Optional for an Individual participant/contact. This serves as the Employer field if used on an Individual.

Not used by Company participant/contact.

Not used by Company participant/contact.

Required for an Individual participant/contact. Not used by Company participant/contact.

Follows the full name of an Individual participant/contact. (e.g. MD, Ph.D.). Not used by Company participant/contact.

Not used by Company participant/contact.

The two letter country code (US = United States, AU = Australia, NZ = New Zealand etc). If omitted will default to the country of your organization's participant/contact record.

The two letter country code (US = United States, AU = Australia, NZ = New Zealand etc). If omitted will default to the country of your organization participant record.

For example, an international phone number format +64 234 5678 has "64" as the country code, "234" as the local area code and "5678" as the local phone number.

For example, an international phone number format +64 234 5678 has "64" as the country code, "234" as the local area code and "5678" as the local phone number.

The local phone number (excludes country code and local area code). For example, an international phone number format +64 234 5678 has "64" as the country code, "234" as the local area code and "5678" as the local phone number.

Not used by Company participant/contact.

Optional - if using multiple divisions, set this to specify which division this contact record belongs to.

For example, an international phone number format +64 234 5678 has "64" as the country code, "234" as the local area code and "5678" as the local phone number.

For example, an international phone number format +64 234 5678 has "64" as the country code, "234" as the local area code and "5678" as the local phone number.

The local phone number (excludes country code and local area code). For example, an international phone number format +64 234 5678 has "64" as the country code, "234" as the local area code and "5678" as the local phone number.

For example, an international phone number format +64 234 5678 has "64" as the country code, "234" as the local area code and "5678" as the local phone number.

For example, an international phone number format +64 234 5678 has "64" as the country code, "234" as the local area code and "5678" as the local phone number.

The local phone number (excludes country code and local area code). For example, an international phone number format +64 234 5678 has "64" as the country code, "234" as the local area code and "5678" as the local phone number.

For example, an international phone number format +64 234 5678 has "64" as the country code, "234" as the local area code and "5678" as the local phone number.

For example, an international phone number format +64 234 5678 has "64" as the country code, "234" as the local area code and "5678" as the local phone number.

The local phone number (excludes country code and local area code). For example, an international phone number format +64 234 5678 has "64" as the country code, "234" as the local area code and "5678" as the local phone number.

An arbitrary data value to store against this participant.