How to create SOQL from the Developer Console
  • 07 Dec 2022
  • PDF

How to create SOQL from the Developer Console

  • PDF

Article summary

Note

This is a machine-translated version of the original Japanese article.
Please understand that some of the information contained on this page may be inaccurate.

summary

When specifying Salesforce as the linkage destination, you need to prepare SOQL for forwarding settings.
This page explains how to create SOQL from the Salesforce developer console.

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

image.png

  1. Select FileOpen Resource.

image.png

  1. Select the object to be retrieved from the Open Resource screen.

image.png

  1. Select the column to be retrieved and click Query to create SOQL. Please note that SOQL cannot use "*" due to syntax restrictions. To execute the query, click execute in the lower left.

image.png

Please note the following two points about SOQL.

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

image.png

TIPS

  • If the Apex Type is datetime, it is possible to link it with trocco as a timestamp type by passing the format function.

image.png


Was this article helpful?