How to solve the issue of field(all)

Question

How to solve the issue of field(all)

Mayur Patil 15

The previous Salesforce legacy connector allowed SQL queries, which was useful for handling data issues in certain objects. The new connector only supports SOQL queries e.g.,select fields(standard) from xyz ,lacking support for custom field selection or retrieving all fields ( select fields(custom ) from xyz or select fields(all) from xyz).We require the equivalent of select * from xyz but encounter 'outer bounds' errors when using fields(all).

AnnuKumari-MSFT 34,351 Reputation points Microsoft Employee

2024-08-09T05:43:11.4333333+00:00
Hi Mayur Patil ,

SELECT * is supported in addition to column selection for SQL mode , however , for SOQL mode , we need to enumerate the fields to be copied in the query, e.g. SELECT field1, filed2 FROM objectname

Using a field list in a SOQL SELECT statement (for example, SELECT Id, Name FROM Account) can be complicated if you need to retrieve many fields. And if you don’t know what fields an object has, you must first get a description of the object. Typically, you use a call to first get a description of the object, then parse the description to identify the fields. Then you construct a SOQL query that specifies the fields, and then make another call to submit the query.

To simplify this process, the FIELDS() keyword lets you select fields easily, without knowing their names in advance. The FIELDS() keyword eliminates the need for a round trip to the server to prepare a SOQL statement, simplifies query statements, and makes it much easier to explore the shape of your objects. It also helps avoid exceeding the character limits on SOQL queries and the URI length limit for REST calls.

You can include any of these in the field list:

FIELDS(ALL)—select all the fields of an object.

FIELDS(CUSTOM)—select all the custom fields of an object.

FIELDS(STANDARD)—select all the standard fields of an object.

Example: SELECT FIELDS(ALL) FROM Account LIMIT 200

For more details, kindly checkout the salesforce documentation: https://developer.salesforce.com/docs/atlas.en-us.soql_sosl.meta/soql_sosl/sforce_api_calls_soql_select_fields.htm

Hope it helps. Kindly accept the answer by clicking on Accept answer button. Thankyou
Mayur Patil 15 Reputation points

2024-08-09T06:08:29.5333333+00:00

field(all ) considered as a unbound and bulk API 2.0 is not support unbounded query.So please suggest any other methods to retrieve all fields using bulk api 2.0

Your answer

AnnuKumari-MSFT 34,351 Reputation points Microsoft Employee

2024-08-09T05:43:11.4333333+00:00

Hi Mayur Patil ,

SELECT * is supported in addition to column selection for SQL mode , however , for SOQL mode , we need to enumerate the fields to be copied in the query, e.g. SELECT field1, filed2 FROM objectname

Using a field list in a SOQL SELECT statement (for example, SELECT Id, Name FROM Account) can be complicated if you need to retrieve many fields. And if you don’t know what fields an object has, you must first get a description of the object. Typically, you use a call to first get a description of the object, then parse the description to identify the fields. Then you construct a SOQL query that specifies the fields, and then make another call to submit the query.

To simplify this process, the FIELDS() keyword lets you select fields easily, without knowing their names in advance. The FIELDS() keyword eliminates the need for a round trip to the server to prepare a SOQL statement, simplifies query statements, and makes it much easier to explore the shape of your objects. It also helps avoid exceeding the character limits on SOQL queries and the URI length limit for REST calls.

You can include any of these in the field list:

FIELDS(ALL)—select all the fields of an object.

FIELDS(CUSTOM)—select all the custom fields of an object.

FIELDS(STANDARD)—select all the standard fields of an object.

Example: SELECT FIELDS(ALL) FROM Account LIMIT 200

For more details, kindly checkout the salesforce documentation: https://developer.salesforce.com/docs/atlas.en-us.soql_sosl.meta/soql_sosl/sforce_api_calls_soql_select_fields.htm

Hope it helps. Kindly accept the answer by clicking on Accept answer button. Thankyou
Mayur Patil 15 Reputation points

2024-08-09T06:08:29.5333333+00:00

field(all ) considered as a unbound and bulk API 2.0 is not support unbounded query.So please suggest any other methods to retrieve all fields using bulk api 2.0

Share via

How to solve the issue of field(all)

Your answer