The following query, when run over the REST API, gives me an error:
SELECT Id
WhatId,
WhoId ,
TaskWhoIds ,
Subject,
ActivityDate,
Status,
Priority,
Owner.Name,
Description,
CreatedDate,
CreatedBy.Name,
TaskSubtype,
PlaybookStepId__c,
Finish_Playbook_Step__c
FROM Task
WHERE WhatId IN ('0063200001mGOA4AAO',
'0063200001mMfQGAA0',
'0063200001mfbNrAAI',
'0063200001lt0sWAAQ',
'0063200001mfayDAAQ',
'0063200001mfrIyAAI',
'0063200001meKVTAA2',
'0063200001lUbMTAA0',
'0063200001mFPNyAAO',
'0063200001n1go2AAA',
'0063200001kxB5KAAU',
'0063200001mg50EAAQ',
'0063200001mfGrKAAU',
'0063200001mUE8FAAW',
'0063200001mg8MXAAY',
'0063200001mGAgYAAW',
'0063200001mfxE8AAI',
'0063200001merQdAAI',
'0063200001mOICLAA4',
'0063200001mg14KAAQ',
'0063200001kwmoRAAQ',
'0063200001ml94FAAQ',
'0063200001mEGplAAG',
'0063200001mkT5lAAE',
'0063200001mO4SZAA0',
'0063200001lucmOAAQ',
'0063200001mf72QAAQ',
'0063200001n1dUdAAI',
'0063200001mGHaLAAW',
'0063200001n1gfOAAQ',
'0063200001n2CtIAAU',
'0063200001mOBhgAAG',
'0063200001mFfGaAAK',
'0063200001meQpuAAE',
'0063200001n1ebCAAQ',
'0063200001n24N4AAI',
'0063200001mg4YrAAI',
'0063200001n1VwGAAU',
'0063200001n1BiRAAU',
'0063200001n26yGAAQ',
'0063200001mEYy3AAG',
'0063200001mEHGpAAO',
'0063200001lutntAAA',
'0063200001n2B86AAE',
'0063200001mfBs5AAE',
'0063200001mfE2aAAE',
'0063200001mfWSUAA2',
'0063200001mOyAjAAK',
'0063200001mO4oDAAS',
'0063200001meH6RAAU')
ORDER BY CreatedDate
The response from the REST endpoint is this:
[
{
"message": "Truncated",
"errorCode": "MALFORMED_QUERY"
}
]
However, the following query, which is identical except for the IDs, successfully returns the requested records.
SELECT Id,
WhatId,
WhoId,
TaskWhoIds,
Subject,
ActivityDate,
Status,
Priority,
Owner.Name,
Description,
CreatedDate,
CreatedBy.Name,
TaskSubtype,
PlaybookStepId__c,
Finish_Playbook_Step__c
FROM Task
WHERE WhatId IN ('0063200001meDmbAAE',
'0063200001mfEikAAE',
'0063200001mfENWAA2',
'0063200001mf6iyAAA',
'0063200001mfsM7AAI',
'0063200001n1LinAAE',
'0063200001mEVMpAAO',
'0063200001mEYnPAAW',
'0063200001mfXn4AAE',
'0063200001mNVpYAAW',
'0063200001mNKdFAAW',
'0063200001mNMBmAAO',
'0063200001mUYnVAAW',
'0063200001mNuZdAAK',
'0063200001mNvuCAAS',
'0063200001mNmUHAA0',
'0063200001mNsuwAAC',
'0063200001mOcGjAAK',
'0063200001mOE7AAAW',
'0063200001mOTfVAAW',
'0063200001mOruuAAC',
'0063200001mOd8nAAC',
'0063200001mOhruAAC',
'0063200001mP7eoAAC',
'0063200001mUglmAAC',
'0063200001mOeTqAAK',
'0063200001mFxnUAAS',
'0063200001mfEgPAAU',
'0063200001mfcbNAAQ',
'0063200001mfa7eAAA',
'0063200001mfaEKAAY',
'0063200001meH7yAAE',
'0063200001mkZaAAAU',
'0063200001n1mOSAAY',
'0063200001mfedjAAA',
'0063200001mfoAJAAY',
'0063200001mfjkUAAQ',
'0063200001n1k5SAAQ',
'0063200001n1EuFAAU',
'0063200001mfpFQAAY',
'0063200001mUVHRAA4',
'0063200001n1EsiAAE',
'0063200001n1CEUAA2',
'0063200001mONB0AAO',
'0063200001mfvP7AAI',
'0063200001mg6xjAAA',
'0063200001mg8EPAAY',
'0063200001mg7VUAAY',
'0063200001mf6yIAAQ',
'0063200001mPCZtAAO')
ORDER BY CreatedDate
I'm not sure how one query is "malformed" but the other is okay. I'm also not sure what the message "Truncated" means, except maybe that the result itself is too long and is truncated? But I've definitely made queries with more resulting records than this before, successfully.
(edit) Additional info: If I split up the failing query into two queries (for half the IDs each), the queries each succeed. The total records returned is something like 500.
What could be going wrong here?