Skip to main content
All CollectionsCommon Errors
SOQL Query HTTP Error

SOQL Query HTTP Error

SOQL Query HTTP Error explained.

Praise Magidi avatar
Written by Praise Magidi
Updated over a week ago

Step

Salesforce (All steps that accept SOQL queries).

Message

The SOQL FIELDS function must have a LIMIT of at most 200.

Cause

When using the `FIELDS(ALL)` function in a SOQL query, you also have to specify a limit, which cannot be greater that 200.

Resolution

1. Explicitly list only the fields you need instead of using FIELDS(ALL).

  sql
SELECT Id, Name, Field1, Field2, ... FROM Object

2. Use FIELDS(STANDARD) or FIELDS(CUSTOM) instead of FIELDS(ALL). These two do not have the `limit 200` limitation.

  sql
SELECT FIELDS(STANDARD), Field1, Field2 FROM Object

Did this answer your question?