Need to replicate ContentDocumentLink from Salesforce

Hi, thanks for reaching out to us at the CData Community!

That error simply indicates that the query you’re currently using is invalid. Some tables for certain data sources requires a specific filter in order to retrieve data via the API. In this case, ContentDocumentLink requires an Id to be specified in a WHERE clause before it is able to retrieve data. I’d like to emphasize that this is a limitation of the API itself, which isn’t something we have direct control over.

For example, the query would need to look something like this using a WHERE clause:

SELECT * FROM ContentDocumentLink WHERE Id = '12345'

SELECT * FROM ContentDocumentLink WHERE Id IN (SELECT Id FROM ContentDocument)

In order to include this information, you’d need to edit the “Query” from the task itself. The end result should look like this:

I hope that this clears up the issue! If you continue encountering issues, then I’d recommending reaching out to our support team at support@cdata.com for more detailed assistance.