Connector operation guide

Basic

Processing

Operation name

Description

Assign Variables

Performs variable assignment.

Call Script

Calls a script in a project.

Wait

Waits for the specified time.

Garbage Collection

Releases unused memory.

Raise Exception

Throws an exception.

Data Check

Checks the values and formats of input data and outputs the result in selected format.

Get Data Check Error Details

Gets detailed information about the input data that caused an error in the Data Check operation executed before.

Validate with XML Schema

Validates data with XML Schema.

Validate with DTD

Validates data with DTD.

Output Table Model Data Log

Writes values of the specified columns from the table model type input data to the execution logs at the selected log level.

Output XML Data Log

Writes the XML type input data to the execution logs at the selected log level.

Flow

Operation name

Description

Loop

Repeats processing for the specified number of times.

Conditional Loop

Repeats processing while the specified conditions are satisfied.

Loop by Number of Data

Repeats processing for the number of input data items.

Records are the loop unit when table model type data (database, Excel, etc.) is input.

All elements are the loop unit when XML type data is input.

Conditional Branch

Performs conditional branch.

Monitor Exception

Monitors and handles exceptions for target operations.

Thread

Executes operations placed between a Start Thread icon and an End Thread icon on another thread.

Transaction

Performs a transaction.

Flows enclosed by the Transaction operation will start a new transaction. (The same behavior as REQUIRES_NEW)

end

Shows the end of a script and returns a return value.

break

Gets out of a loop.

continue

Skips the subsequent processes in a loop operation and moves on to the processing to evaluate whether the loop continuation conditions are met.

Event Notification

Operation name

Description

Notify Event(Amazon EventBridge)

Sends an event to an event bus registered to Amazon EventBridge.

Assertion

Operation name

Description

Compare Table Model

Compares the table model type data of the input source with the expected values of the CSV file based on specified conditions.

Compare XML File

Checks whether the contents of the input data and the contents of the specified file match as XML.

Note

Executed only when the log level is FINFO or lower. Not executed when the log level is INFO or higher. When you don't want it to be executed in operation phase, set the log level to INFO or higher.

Compare XML Data

Checks whether the contents of the input data and the contents of the specified data match as XML.

Note

Executed only when the log level is FINFO or lower. Not executed when the log level is INFO or higher. When you don't want it to be executed in operation phase, set the log level to INFO or higher.

Compare File

Compares a file with another file as binary, and when it doesn't match, throws an assertion exception.

Compare Variable

Compares variables or fixed values based on conditions.

Assertion Exception

Throws an assertion exception.

Note

Executed only when the log level is FINFO or lower. Not executed when the log level is INFO or higher. When you don't want it to be executed in operation phase, set the log level to INFO or higher.

Others

Operation name

Description

Group

Groups flows.

Memo

Places a memo on the script.

Conversion

Basic

Operation name

Description

Mapping

Performs conversion on input data.

Join

Joins the two input data.

Aggregate

Aggregates the input data.

Sort

Sorts the input data.

Merge

Unites two or more input data.

Character

Operation name

Description

Convert CP932 to SJIS

Converts specific characters encoded with CP932 of input data to SJIS character code.

Convert SJIS to CP932

Converts specific characters encoded with SJIS of input data to CP932 character code.

Remove Invalid XML Characters

Removes invalid characters for XML from input data.

Table

Operation name

Description

Switch Row/Column

Switches the rows and the column of the input data.

XSLT

Operation name

Description

Convert XSLT Structure

Converts input data with XSLT.

Database

Common

Operation name

Description

Read Table

Reads data stored in a table.

Execute Select SQL

Reads data using a SQL statement.

Write Table

Writes input data to a table.

Execute Update SQL

Writes data using a SQL statement.

Execute Stored Procedure

Executes a stored procedure.

File

CSV

Operation name

Description

Read CSV File

Reads files of formats such as CSV (Comma Separated Values), TSV (Tab Separated Values), etc.

Write CSV File

Writes input data to a file of format such as CSV (Comma Separated Values), TSV (Tab Separated Values), etc.

Excel

Operation name

Description

Read from Sheet

Reads Excel data from a sheet.

Read from Named Range

Reads Excel data from a named range.

Read Specified Cell

Reads Excel data from specified cells.

Get Sheet Names

Gets a list of sheet names included in an Excel file.

Write

Writes input data to an Excel file.

Write Specified Cell

Writes input data to specified cells of an Excel file.

Protect Workbook and Sheet

Protects an Excel workbook and its sheets with a write password.

Show/Hide Sheets/Rows/Columns

Shows/Hides sheets, rows, and columns in an Excel workbook.

Rename Sheet

Renames the sheet of the specified Excel workbook.

Delete Sheet

Deletes the sheet from the specified Excel workbook.

Copy Sheet

Copies the sheet of the specified Excel workbook.

Excel(POI)

Operation name

Description

Write Sheet

Writes input data to an Excel file.

Write Specified Cell

Writes input data to a specified cell of an Excel file.

XML

Operation name

Description

Read XML File

Reads the XML file.

Write XML File

Writes input data to an XML file.

Fixed-Length

Operation name

Description

Read Fixed-Length File

Reads a fixed-length file.

Write Fixed-Length File

Writes the input data to a text file in fixed-length format.

Variable-Length

Operation name

Description

Read Variable-Length File

Reads a variable-length file.

Write Variable-Length File

Writes the input data to a text file in variable-length format.

File Operation

Operation name

Description

Create File

Creates a new file.

Create Directory

Creates a new directory.

Copy

Duplicates a file or directory.

Delete File/Directory

Deletes the file or directory.

Move

Moves the file or directory.

Get List of File Names

Gets a list of file names in a directory.

Check File/Directory Exists

Determines whether a file or directory exists.

Compress ZIP

Compresses a file or directory into a ZIP file.

Extract ZIP

Extracts the ZIP file.

Compress GZIP

Compresses a file into a GZIP file.

Extract GZIP

Extracts the GZIP file.

Filesystem

Operation name

Description

Read Filesystem

Reads the data structure of files and directories in the directory.

Write Filesystem

Creates or updates files and directories from the input data.

Application

Dynamics 365 for Customer Engagement

Operation name

Description

Read Entity

Reads an entity.

Write Entity

Writes input data to entity.

Delete Entity

Deletes entity.

Salesforce(deprecated)

Operation name

Description

Read Data (execute SOQL) (deprecated)

This operation is to read data, using the query() or queryAll() call of the SOAP API.

You an directly input SOQL(Sforce Object Query Language).

Therefore you must understand SOQL syntax.

= Remarks =

For details about the API specification used in this component, refer to the API documentation of the selected version in the connection resource from the following link destination page.

  • "Salesforce Developer Documentation"-(https://developer.salesforce.com/docs)

    • SOAP API Developer's Guide

    • Salesforce Object Query Language (SOQL)

Write Data(Insert) (deprecated)

This operation is to add data using the SOAP API create() call.

You can retrieve the results of each record corresponding to the input data from the output schema.

= Remarks =

For details about the API specification used in this operation, refer to the API documentation of the selected version in the connection resource from the following link destination page.

  • "Salesforce Developer Documentation"-(https://developer.salesforce.com/docs)

    • SOAP API Developer's Guide

Write Data(Update) (deprecated)

This operation is to update data using the SOAP API update() call.

You must specify each records ID to use update().

However, with this component you may use a field other than ID as the key. In this case query() will be used to lookup the IDs based on the key.

In addition, if no corresponding record is found, it is possible to automatically add it using processing which makes use of create().

You can retrieve the results of each record corresponding to the input data from the output schema.

= Remarks =

For details about the API specification used in this operation, refer to the API documentation of the selected version in the connection resource from the following link destination page.

  • "Salesforce Developer Documentation"-(https://developer.salesforce.com/docs)

    • SOAP API Developer's Guide

Write Data(Delete) (deprecated)

This operation is to delete data using the SOAP API delete() call.

You must specify each records ID to use delete().

However, with this component you may use a field other than ID as the key. In this case query() will be used to lookup the IDs based on the key.

You can retrieve the results of each record corresponding to the input data from the output schema.

= Remarks =

For details about the API specification used in this operation, refer to the API documentation of the selected version in the connection resource from the following link destination page.

  • "Salesforce Developer Documentation"-(https://developer.salesforce.com/docs)

    • SOAP API Developer's Guide

Write Data(Upsert) (deprecated)

This operation is to insert/update data using the SOAP API upsert() call.

upsert() uses an external id (*) custom field index to determine if a new record should be created or if an existing record should be updated.

We recommend that in most cases to prevent many unnecessary duplicate records upsert() should be used instead of create().

(*) External ID needs to be defined beforehand, using the customization feature of Salesforce.

You can retrieve the results of each record corresponding to the input data from the output schema.

= Remarks =

For details about the API specification used in this operation, refer to the API documentation of the selected version in the connection resource from the following link destination page.

  • "Salesforce Developer Documentation"-(https://developer.salesforce.com/docs)

    • SOAP API Developer's Guide

Read Data(Child-Parent Relation) (deprecated)

This operation is to read data, using the query() or queryAll() call of the SOAP API.

We will specify filter criteria with SOQL(Sforce Object Query Language) but with this component, you may set the filters without directly writing SOQL.

However, you can still directly write after the WHERE clause.

This component can make use of child-to-parent relationships and functions.

Furthermore, aggregate functions can be used in the items selected in the schema definition, and by using it in combination with aggregate conditions (GROUP BY clause, etc.), the results of the aggregate functions, based on the aggregate conditions, can be obtained.

Note

child-to-parent relationships beyond 2 levels cannot be used.

= Remarks =

For details about the API specification used in this component, refer to the API documentation of the selected version in the connection resource from the following link destination page.

  • "Salesforce Developer Documentation"-(https://developer.salesforce.com/docs)

    • SOAP API Developer's Guide

    • Salesforce Object Query Language (SOQL)

Bulk Write Data(Insert) (deprecated)

This operation performs a Insert operation, based on input data, using Bulk API.

Job Creation, batch creation, batch result obtainment, and job closing will be done subsequently as one operation.

= Remarks =

For details about the API specification used in this operation, refer to the API documentation of the selected version in the connection resource from the following link destination page.

  • "Salesforce Developer Documentation"-(https://developer.salesforce.com/docs)

    • Bulk API Developer's Guide

Bulk Write Data(Update) (deprecated)

This operation performs a Update operation, based on input data, using Bulk API.

Job Creation, batch creation, batch result obtainment, and job closing will be done subsequently as one operation.

In the Update processing, Salesforce ID must be speficied as a key when updating data.

= Remarks =

For details about the API specification used in this operation, refer to the API documentation of the selected version in the connection resource from the following link destination page.

  • "Salesforce Developer Documentation"-(https://developer.salesforce.com/docs)

    • Bulk API Developer's Guide

Bulk Write Data(Delete) (deprecated)

This operation performs a Delete operation, based on input data, using Bulk API.

Job Creation, batch creation, batch result obtainment, and job closing will be done subsequently as one operation.

In the Delete operation, the Salesforce ID is set as the key item when deleting data.

= Remarks =

For details about the API specification used in this operation, refer to the API documentation of the selected version in the connection resource from the following link destination page.

  • "Salesforce Developer Documentation"-(https://developer.salesforce.com/docs)

    • Bulk API Developer's Guide

Bulk Write Data(Upsert) (deprecated)

This operation performs a Upsert operation, based on input data, using Bulk API.

Job Creation, batch creation, batch result obtainment, and job closing will be done subsequently as one operation.

The Upsert processing checks the existence of data corresponding to the external ID(*) of Salesforce, and update the data if it exists, or add data if not. Also, the data update by specifying ID can be performed. (*) External ID needs to be defined beforehand, using the customization feature of Salesforce.

 

= Remarks =

For details about the API specification used in this operation, refer to the API documentation of the selected version in the connection resource from the following link destination page.

  • "Salesforce Developer Documentation"-(https://developer.salesforce.com/docs)

    • Bulk API Developer's Guide

Bulk Get Data(Query) (deprecated)

This operation performs a Query operation with Bulk API and creates CSV file.

Job Creation, batch creation, batch result obtainment, and job closing will be done subsequently as one operation.

 

= Remarks =

For details about the API specification used in this operation, refer to the API documentation of the selected version in the connection resource from the following link destination page.

  • "Salesforce Developer Documentation"-(https://developer.salesforce.com/docs)

    • Bulk API Developer's Guide

Network

FTP

Operation name

Description

Get List and Data

Gets a file list and the contents of the files.

Read List

Gets a list of files.

Update

Transfers the specified files in HULFT Square Storage to FTP server.

Delete

Deletes the specified files in FTP server.

Rename

Renames the specified files on FTP server.

REST

Operation name

Description

Execute GET

Executes HTTP GET method request.

Execute POST

Executes HTTP POST method request.

Execute PUT

Executes HTTP PUT method request.

Execute PATCH

Executes HTTP PATCH method request.

Execute DELETE

Executes HTTP DELETE method request.

Mail

Operation name

Description

Receive E-mail (POP3)

Receives emails from the POP3 server.

Receive E-mail (IMAP4)

Receives emails from the IMAP4 server.

Send Multiple E-mails

Based on the contents of the input data, sends emails to SMTP server.

Send One E-mail

Sends an email to SMTP server.

Cloud

Amazon Athena

Operation name

Description

For details on the script components for Cloud > Amazon Athena, refer to the operations described in "Common".

Amazon Aurora for MySQL

Operation name

Description

For details on the script components for Cloud > Amazon Aurora for MySQL, refer to the operations described in "Common".

Amazon DynamoDB

Operation name

Description

Get Item (Scan)

Gets items stored in an Amazon DynamoDB table.

= Remarks =

This operation uses Scan API. For more details on API specifications, refer to the following page:

  • "Scan" (http://docs.aws.amazon.com/en_us/amazondynamodb/latest/APIReference/API_Scan.html)

Get Item (Query)

Gets items stored in an Amazon DynamoDB table.

= Remarks =

This operation uses Query API. For more details on API specifications, refer to the following page:

  • "Query" (http://docs.aws.amazon.com/en_us/amazondynamodb/latest/APIReference/API_Query.html)

Add/Replace Item

Writes input data to an Amazon DynamoDB table.

= Remarks =

This operation uses PutItem API or BatchWriteItem API. For more details on API specifications, refer to the following pages:

  • "PutItem" (http://docs.aws.amazon.com/en_us/amazondynamodb/latest/APIReference/API_PutItem.html)

  • "BatchWriteItem" (http://docs.aws.amazon.com/en_us/amazondynamodb/latest/APIReference/API_BatchWriteItem.html)

Delete Item

Deletes items in an Amazon DynamoDB table where the primary key matches with the primary key received from input data.

= Remarks =

This operation uses DeleteItem API or BatchWriteItem API. For more details on API specifications, refer to the following pages:

  • "DeleteItem" (http://docs.aws.amazon.com/en_us/amazondynamodb/latest/APIReference/API_DeleteItem.html)

  • "BatchWriteItem" (http://docs.aws.amazon.com/en_us/amazondynamodb/latest/APIReference/API_BatchWriteItem.html)

Amazon EC2

Operation name

Description

Start Instances

Starts instances of Amazon EC2.

Stop Instances

Stops instances of Amazon EC2.

Describe Instances

Gets information about instances in Amazon EC2.

Amazon RDS for MySQL

Operation name

Description

For details on the script components for Cloud > Amazon RDS for MySQL, refer to the operations described in "Common".

Amazon RDS for Oracle

Operation name

Description

For details on the following script components for Cloud > Amazon RDS for Oracle, refer to the operations described in "Common".

Amazon RDS for PostgreSQL

Operation name

Description

For details on the script components for Cloud > Amazon RDS for PostgreSQL, refer to the operations described in "Common".

Amazon RDS for SQL Server

Operation name

Description

For details on the script components for Cloud > Amazon RDS for SQL Server, refer to the operations described in "Common".

Amazon Redshift

Operation name

Description

Execute COPY Command

Executes COPY command to Amazon Redshift.

= Remarks =

For details on COPY command specifications of this component, refer to the following link page:

  • "Amazon Redshift document-developers' guide (Japanese language only)- COPY"-(http://docs.aws.amazon.com/ja_jp/redshift/latest/dg/r_COPY.html)

Amazon S3

Operation name

Description

Get Bucket List

Gets the bucket list.

Get File/Folder List

Gets file/folder list on Amazon S3.

Read File/Folder

Retrieves files/folders that are on Amazon S3 and writes them to the directory on HULFT Square Storage.

Write File/Folder

Writes file/folder on HULFT Square Storage to Amazon S3.

Copy File/Folder

Copies the file/folder on Amazon S3 to the specified bucket folder on Amazon S3.

Delete File/Folder

Deletes the folder/files on Amazon S3.

Read File/Folder (Data)

Reads the files/folder on Amazon S3.

Write File/Folder (Data)

Writes file/folder to Amazon S3.

Amazon SQS

Operation name

Description

Receive Message

Receives messages from Amazon SQS.

Send Message

Sends messages for Amazon SQS.

Delete Message

Deletes messages in Amazon SQS.

AWS Lambda

Operation name

Description

Invoke Lambda Function

Invokes the Lambda function.

Azure SQL Database

Operation name

Description

For details on the script components for Cloud > Azure SQL Database, refer to the operations described in "Common".

Azure BLOB Storage

Operation name

Description

Get Container List

Gets container list of the specified destination.

Read File/Directory

Writes the specified file or directory which exists in Microsoft Azure BLOB Storage to another specified directory in HULFT Square Storage.

Write File/Directory

Writes the specified file or a directory which exists in HULFT Square Storage to the specified container in Microsoft Azure BLOB Storage.

Delete File/Directory/Container

Deletes the specified file, directory, or container in Microsoft Azure BLOB Storage.

Azure Cosmos DB

Operation name

Description

Read Document

Gets documents stored in Microsoft Azure Cosmos DB collection.

Read Document by SQL

Gets documents stored in Microsoft Azure Cosmos DB collection using a SQL statement.

Write Document

Writes input data to Microsoft Azure Cosmos DB collection.

Delete Document

Deletes documents stored in Microsoft Azure Cosmos DB collection.

Azure HDInsight

Operation name

Description

Create Cluster

Creates an Azure HDInsight cluster.

Delete Cluster

Deletes an Azure HDInsight cluster.

Execute Hive Job

Executes a Hive job.

Azure Queue Storage

Operation name

Description

Receive Message

Receives messages from Azure Queue Storage.

Send Message

Sends messages to Azure Queue Storage.

Delete Message

Deletes messages in Azure Queue Storage.

Gmail

Operation name

Description

Receive E-mail (POP3)

Receives emails from Gmail POP3 server.

Receive E-mail (IMAP4)

Receives emails from Gmail IMAP4 server.

Send Multiple E-mails

Based on the contents of the input data, sends emails to Gmail SMTP server.

Send One E-mail

Sends an email to Gmail SMTP server.

Google BigQuery

Operation name

Description

Load table data

Gets data from the file on Google Cloud Storage, and writes the data to the table on Google BigQuery.

Extract table data

Obtains data from a table on Google BigQuery, and outputs it to a file on Google Cloud Storage.

Execute Select SQL

On Google BigQuery, writes data to a table using a SQL statement.

Google Cloud Storage

Operation name

Description

Read File/Folder

Reads data from a file/folder on Google Cloud Storage onto HULFT Square Storage.

Write File/Folder

Writes a file/folder on HULFT Square Storage to Google Cloud Storage.

Delete File/Folder

Deletes files/folders on Google Cloud Storage.

Google Drive

Operation name

Description

Get File/Folder List

Gets file/folder list on Google Drive.

Read File/Folder

Obtains file/folder on Google Drive, then writes to the directory on HULFT Square Storage.

Write File/Folder

Writes file/folder on HULFT Square Storage to Google Drive.

Delete File/Folder

Deletes file/folder on Google Drive.

Google Sheets

Operation name

Description

Read Sheet

Reads a worksheet from the spreadsheet on Google Drive.

Retrieve Sheets

Lists the names of worksheets in a spreadsheet on Google Drive.

Writing

Writes the input data to the specified spreadsheet on Google Drive.

kintone

Operation name

Description

Get Record

Gets Kintone records.

Add Record

Adds Kintone records.

Update Record

Updates Kintone records.

Delete Record

Deletes Kintone records.

Read Table

Reads the data stored in Kintone table.

Write Table

Writes the input data to Kintone table.

Delete Table Data

Deletes the data stored in Kintone table.

Call API

Calls Kintone API (REST API).

For details on Kintone API, refer to the developer website of Cybozu company (https://developer.kintone.io/hc/en-us/).

This operation is based on Kintone API as of April 10, 2014.

Note

Depending on improvement and addition of Kintone API in the future, it might not execute correctly.

Box

Operation name

Description

Create Folder

In Box, creates the folder specified in the input data.

Copy File Request

Copies a file request specified in the input data and applies it to another folder on Box.

= Remarks =

For details on API specifications used by this component, refer to the Box API reference at the following URL:

  • https://developer.box.com/reference/post-file-requests-id-copy/

Move Contents

Moves the contents (files or folders) in Box specified in input data.

= Remarks =

For details on API specifications used by this component, refer to the Box API reference at the following URLs:

  • https://developer.box.com/reference/put-files-id/

  • https://developer.box.com/reference/put-folders-id/

Copy Contents

Copies the contents (files or folders) specified in input data to Box.

= Remarks =

For details on API specifications used by this component, refer to the Box API reference at the following URLs:

  • https://developer.box.com/reference/post-files-id-copy/

  • https://developer.box.com/reference/post-folders-id-copy/

Delete Contents

Deletes the Box contents (files or folders) specified in the input data.

= Remarks =

For details on API specifications used by this component, refer to the Box API reference at the following URLs:

  • https://developer.box.com/reference/delete-files-id/

  • https://developer.box.com/reference/delete-folders-id/

Upload Contents

Uploads the contents (files or folders) specified in input data to Box.

= Remarks =

For details on API specifications used by this component, refer to the Box API reference at the following URLs:

  • https://developer.box.com/reference/post-files-content/

  • https://developer.box.com/reference/post-files-id-content/

Download Contents

Downloads the Box contents (files or folders) from the path specified in the input data.

= Remarks =

For details on API specifications used by this component, refer to the Box API reference at the following URL:

  • https://developer.box.com/reference/get-files-id-content/

Get Contents List

Acquires an information list of contents (files or folders) specified in input data from Box.

= Remarks =

For details on API specifications used by this component, refer to the Box API reference at the following URL:

  • https://developer.box.com/reference/get-folders-id-items/

Get Content Attributes

In Box, gets the attribute information of the content (file or folder) by using the content ID specified in the input data.

= Remarks =

For details on API specifications used by this component, refer to the Box API reference at the following URLs:

  • https://developer.box.com/reference/get-files-id/

  • https://developer.box.com/reference/get-folders-id/

Get Shared Link

In Box, gets the shared link to the content (file or folder) specified in the input data.

= Remarks =

For details on API specifications used by this component, refer to the Box API reference at the following URLs:

  • https://developer.box.com/reference/put-files-id--add-shared-link/

  • https://developer.box.com/reference/put-folders-id--add-shared-link/

Create Shared Link

In Box, creates a shared link to the content (file or folder) specified in the input data.

Or, if a shared link already exists for the target content, updates the settings.

= Remarks =

For details on API specifications used by this component, refer to the Box API reference at the following URLs:

  • https://developer.box.com/reference/put-files-id--add-shared-link/

  • https://developer.box.com/reference/put-folders-id--add-shared-link/

Delete Shared Link

In Box, deletes the shared link to the content (file or folder) specified in the input data.

= Remarks =

For details on API specifications used by this component, refer to the Box API reference at the following URLs:

  • https://developer.box.com/reference/put-files-id--remove-shared-link/

  • https://developer.box.com/reference/put-folders-id--remove-shared-link/

Create User

In Box, creates the user specified in the input data.

= Remarks =

For details on API specifications used by this component, refer to the Box API reference at the following URL:

  • https://developer.box.com/reference/post-users/

Update User

Updates the users of Box specified in the input data.

= Remarks =

For details on API specifications used by this component, refer to the Box API reference at the following URL:

  • https://developer.box.com/reference/put-users-id/

Delete User

Deletes the Box user specified in the input data.

= Remarks =

For details on API specifications used by this component, refer to the Box API reference at the following URL:

  • https://developer.box.com/reference/delete-users-id/

Create Group

In Box, creates the group specified in the input data.

= Remarks =

For details on API specifications used by this component, refer to the Box API reference at the following URL:

  • https://developer.box.com/reference/post-groups/

Update Group

Updates the group of Box specified in the input data.

= Remarks =

For details on API specifications used by this component, refer to the Box API reference at the following URL:

  • https://developer.box.com/reference/put-groups-id/

Delete Group

Deletes the Box group specified in the input data.

= Remarks =

For details on API specifications used by this component, refer to the Box API reference at the following URL:

  • https://developer.box.com/reference/delete-groups-id/

Add Membership

Based on the input data, adds the user to Box as a member of the group.

= Remarks =

For details on API specifications used by this component, refer to the Box API reference at the following URL:

  • https://developer.box.com/reference/post-group-memberships/

Delete Membership

Based on the input data, deletes the Box user from members of the group.

= Remarks =

For details on API specifications used by this component, refer to the Box API reference at the following URL:

  • https://developer.box.com/reference/delete-group-memberships-id/

Add Collaboration

Adds the collaboration specified in the input data to Box.

= Remarks =

For details on API specifications used by this component, refer to the Box API reference at the following URL:

  • https://developer.box.com/reference/post-collaborations/

Delete Collaboration

Deletes the collaboration of Box specified in the input data.

= Remarks =

For details on API specifications used by this component, refer to the Box API reference at the following URL:

  • https://developer.box.com/reference/delete-collaborations-id/

Slack

Operation name

Description

Post Message

Posts messages to a specific channel in Slack.

SharePoint

Operation name

Description

Download document

Downloads documents on SharePoint.

Get file path list

Obtains the file path list of files specified on SharePoint.

Upload document

Uploads documents to SharePoint.

Salesforce

Operation name

Description

Read Records

Reads records from an object.

This component uses "query" for REST API.

To check technical details, go to salesforce.com and check the page for SOQL queries and other related pages in the REST API Developer Guide.

Read Records (Child-to-parent relationship)

Reads records from an object (child-to-parent relationship).

For reference-type fields for the object, reference record information is retrieved.

This component uses "query" for REST API.

To check technical details, go to salesforce.com and check the page for SOQL queries and other related pages in the REST API Developer Guide.

Insert Records

Writes records to an object.

This component uses "insert" for REST API.

To check technical details, go to salesforce.com and check the page for SOQL queries and other related pages in the REST API Developer Guide.

Update Records

Updates records based on object IDs.

This component uses "insert" for REST API.

To check technical details, go to salesforce.com and check the page for SOQL queries and other related pages in the REST API Developer Guide.

Upsert Records

Inserts records when the records don't exist in an object, or updates records when the records exist in an object.

This component uses "upsert" for REST API.

To check technical details, go to salesforce.com and check the page for SOQL queries and other related pages in the REST API Developer Guide.

Delete Records

Deletes records based on object IDs.

This component uses "delete" for REST API.

To check technical details, go to salesforce.com and check the page for SOQL queries and other related pages in the REST API Developer Guide.

Bulk Read Records

Reads records from an object all at once using Salesforce Bulk API 2.0.

This component uses "query" for REST API.

To check technical details, go to salesforce.com and check the page for SOQL queries and other related pages in the REST API Developer Guide.

Bulk Read Records (Child-to-parent relationship)

Reads records all at once from an object using Salesforce Bulk API 2.0 (child-to-parent relationship).

For reference-type fields for the object, reference record information is retrieved.

This component uses "query" for REST API.

To check technical details, go to salesforce.com and check the page for SOQL queries and other related pages in the REST API Developer Guide.

Bulk Insert Records

Writes records all at once to an object using Salesforce Bulk API 2.0.

This component uses "insert" for REST API.

To check technical details, go to salesforce.com and check the page for SOQL queries and other related pages in the REST API Developer Guide.

Bulk Update Records

Updates records all at once based on their object IDs using Salesforce Bulk API 2.0.

This component uses "insert" for REST API.

To check technical details, go to salesforce.com and check the page for SOQL queries and other related pages in the REST API Developer Guide.

Bulk Upsert Records

Inserts records all at once when the records don't exist in an object, or updates records all at once when the records exist in an object using Salesforce Bulk API 2.0.

This component uses "upsert" for REST API.

To check technical details, go to salesforce.com and check the page for SOQL queries and other related pages in the REST API Developer Guide.

Bulk Delete Records

Deletes records all at once based on their object IDs using Salesforce Bulk API 2.0.

This component uses "delete" for REST API.

To check technical details, go to salesforce.com and check the page for SOQL queries and other related pages in the REST API Developer Guide.

ServiceNow

Operation name

Description

Export

By using "HULFT Square Connector for ServiceNow" with ServiceNow, outputs data from the target table that is registered to the table list of "HULFT Square Connector for ServiceNow".

Import multiple

By using "HULFT Square Connector for ServiceNow" with ServiceNow, imports the data to the Source Table that is registered to the table list of "HULFT Square Connector for ServiceNow".

Cryptography

PGP

Operation name

Description

Encrypt

Encrypts the file and outputs it to the specified directory.

Decrypt

Decrypts the encrypted file and outputs it to the specified directory.

HULFT

Request Issuance

Operation name

Description

Send File

Runs the Send File command (utlsend).