Data Type Format

Function Overview

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

For rules that are not described on this page, please refer to the API document from the following linked page.

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

Write Data

Boolean Type

The different rules apply to the Salesforce adapter and the Salesforce Bulk adapter.

Input data variable type	Input data value	Update Value	Salesforce adapter	Salesforce Bulk adapter	Supplement
boolean Value	true	true	Available	Available
boolean Value	false	false	Available	Available
Numerical Value	1	true	Available	Available	Cannot be used with [Write Data(Delete)]process.
Numerical Value	0	false	Available	Available	Cannot be used with [Write Data(Delete)]process.
String Value	true	true	Available	Available	It is not case sensitive.
	yes	true	Available	Not Available	It is not case sensitive. Cannot be used with [Write Data(Delete)]process. Cannot be used with [Write Multi Data]process of resource type is API 23.0.
	y	true	Available	Not Available	It is not case sensitive. Cannot be used with [Write Data(Delete)]process. Cannot be used with [Write Multi Data]process of resource type is API 23.0.
	on	true	Available	Not Available	It is not case sensitive. Cannot be used with [Write Data(Delete)]process. Cannot be used with [Write Multi Data]process of resource type is API 23.0.
	false	false	Available	Available	It is not case sensitive.
	no	false	Available	Not Available	It is not case sensitive. Cannot be used with [Write Data(Delete)]process. Cannot be used with [Write Multi Data]process of resource type is API 23.0.
	n	false	Available	Not Available	It is not case sensitive. Cannot be used with [Write Data(Delete)]process. Cannot be used with [Write Multi Data]process of resource type is API 23.0.
	off	false	Available	Not Available	It is not case sensitive. Cannot be used with [Write Data(Delete)]process. Cannot be used with [Write Multi Data]process of resource type is API 23.0.

Date Type

The same rules apply to the Salesforce adapter and the Salesforce Bulk adapter.

Input data variable type	Format	Sample	Supplement
Date	-	-	Information other than the date is truncated.
String Value	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

DateTime Type

The same rules apply to the Salesforce adapter and the Salesforce Bulk adapter.

Input data variable type	Format	Sample
Date	-	-
String Value	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 same rules apply to the Salesforce adapter and the Salesforce Bulk adapter.

If the resource type is API 40.0 or earlier, you cannot specify the Time Type in the key item of the query search that retrieves records to be processed with the following component.

[Write Data(Update)]process
[Write Data(Delete)]process

Input data variable type	Format	Sample	Supplement
String Value	H:m:s	1:3:5	Available on API 43.0 or later versions.
	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 versions.
	HH:mm:ss.SS'z'	12:34:56.12z	Available on API 43.0 or later versions.
	HH:mm:ss.SSS'z'	12:34:56.123z	Available on API 43.0 or later versions.
	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 versions.
	HH:mm:ss'Z'	12:34:56Z