Data type format

Summary

The data type is defined for the fields of an object. The API sends and receives data according to the defined data type format rules, but this connector has extended rules for some data types.

= Remarks =

For details on rules not described on this page, refer to the API documents at the following link page.

Salesforce Developer Documentation-(https://developer.salesforce.com/docs)
- SOAP API Developer's Guide
- Bulk API Developer's Guide

Write Data

Boolean type

The rules vary between Salesforce (deprecated) connector and Salesforce Bulk (deprecated) connector.

Variable type for input data	Value for input data	Update value	Salesforce connector	Salesforce Bulk connector	Remarks
Boolean	true	true	Available	Available
Boolean	false	false	Available	Available
Number	1	true	Available	Available	Note Can't be used in Bulk Write Data(Delete) operation.
Number	0	false	Available	Available	Note Can't be used in Bulk Write Data(Delete) operation.
String	true	true	Available	Available	Case insensitive.
	yes	true	Available	Not available	Case insensitive. Note Can't be used in Bulk Write Data(Delete) operation.
	y	true	Available	Not available	Case insensitive. Note Can't be used in Bulk Write Data(Delete) operation.
	on	true	Available	Not available	Case insensitive. Note Can't be used in Bulk Write Data(Delete) operation.
	false	false	Available	Available	Case insensitive.
	no	false	Available	Not available	Case insensitive. Note Can't be used in Bulk Write Data(Delete) operation.
	n	false	Available	Not available	Case insensitive. Note Can't be used in Bulk Write Data(Delete) operation.
	off	false	Available	Not available	Case insensitive. Note Can't be used in Bulk Write Data(Delete) operation.

Date type

The rules are the same for both Salesforce (deprecated) connector and Salesforce Bulk (deprecated) connector.

Variable type for input data	Format	Sample	Remarks
Date	—	—	Information other than the date is omitted.
String	yyyy-MM-dd'T'HH:mm:ss.SSS'Z'	2020-3-14T12:34:56.000Z
	yyyy/MM/dd'T'HH:mm:ss.SSS'Z'	2020/3/14T12:34:56.000Z
	yyyy-MM-dd'T'HH:mm:ss.SSSz	2020-3-14T12:34:56.000JST
	yyyy/MM/dd'T'HH:mm:ss.SSSz	2020/3/14T12:34:56.000JST
	yyyy-MM-dd' 'HH:mm:ss	2020-3-14 12:34:56
	yyyy/MM/dd' 'HH:mm:ss	2020/3/14 12:34:56
	yyyy-MM-dd'T'HH:mm:ss	2020-3-14T12:34:56
	yyyy/MM/dd'T'HH:mm:ss	2020/3/14T12:34:56
	yyyy-MM-dd' 'HH:mm	2020-3-14 12:34
	yyyy/MM/dd' 'HH:mm	2020/3/14 12:34
	yyyy-MM-dd	2020-3-14
	yyyy/MM/dd	2020/3/14

Date/Time type

The rules are the same for both Salesforce (deprecated) connector and Salesforce Bulk (deprecated) connector.

Variable type for input data	Format	Sample
Date	—	—
String	yyyy-MM-dd'T'HH:mm:ss.SSS'Z'	2020-3-14T12:34:56.000Z
	yyyy/MM/dd'T'HH:mm:ss.SSS'Z'	2020/3/14T12:34:56.000Z
	yyyy-MM-dd'T'HH:mm:ss.SSSz	2020-3-14T12:34:56.000JST
	yyyy/MM/dd'T'HH:mm:ss.SSSz	2020/3/14T12:34:56.000JST
	yyyy-MM-dd' 'HH:mm:ss	2020-3-14 12:34:56
	yyyy/MM/dd' 'HH:mm:ss	2020/3/14 12:34:56
	yyyy-MM-dd'T'HH:mm:ss	2020-3-14T12:34:56
	yyyy/MM/dd'T'HH:mm:ss	2020/3/14T12:34:56
	yyyy-MM-dd' 'HH:mm	2020-3-14 12:34
	yyyy/MM/dd' 'HH:mm	2020/3/14 12:34
	yyyy-MM-dd	2020-3-14
	yyyy/MM/dd	2020/3/14

Time type

The rules are the same for both Salesforce (deprecated) connector and Salesforce Bulk (deprecated) connector.

Note

For API 40.0 and before, in the following components, you can't specify time type for key fields in query searches to get records to process.

Write Data(Update) operation
Write Data(Delete) operation

Variable type for input data	Format	Sample	Remarks
String	H:m:s	1:3:5	Available on API 43.0 or later.
	HH:mm:ss	12:34:56
	HH:mm:ss.S	12:34:56.1
	HH:mm:ss.SS	12:34:56.12
	HH:mm:ss.SSS	12:34:56.123
	HH:mm:ss.S'z'	12:34:56.1z	Available on API 43.0 or later.
	HH:mm:ss.SS'z'	12:34:56.12z	Available on API 43.0 or later.
	HH:mm:ss.SSS'z'	12:34:56.123z	Available on API 43.0 or later.
	HH:mm:ss.S'Z'	12:34:56.1Z
	HH:mm:ss.SS'Z'	12:34:56.12Z
	HH:mm:ss.SSS'Z'	12:34:56.123Z
	HH:mm:ss'z'	12:34:56z	Available on API 43.0 or later.
	HH:mm:ss'Z'	12:34:56Z