How to create a SOQL from the developer console

summary

When specifying Salesforce as the destination, SOQLs must be prepared for forwarding settings.
This page explains how to create SOQLs from within the Salesforce developer console.

1. Log in to Salesforce.
2. Click on Developer Console from the menu in the upper right corner.

3. Select File → Open Resource.

4. Select the object to be acquired from the Open Resource screen.

5. A SOQL is created by selecting the columns to be retrieved and clicking Query. Please note that "*" cannot be used in SOQL due to syntax restrictions. To execute the query, click on execute in the lower left corner.

Please note the following two points about SOQL

1. Due to the limitations of the Bulk API, only a single object can be used, so table joins are not possible.
2. Please note that object-type columns cannot be obtained due to Bulk API limitations. For example, an Apex Type of address is an object type as follows.

TIPS

• Apex Type is datetime, it can be linked to TROCCO as timestamp type by passing through the format function.