ADF Linked Service with Salesforce connector latest version unavailable

Ramamoorthy, Kesavan 56 Reputation points
2021-05-12T09:15:01.267+00:00

Hi Experts,

As per update from salesforce, SOQL query supports the querying of all fields starting from api version 51 and later. Pls see below link.

https://developer.salesforce.com/docs/atlas.en-us.soql_sosl.meta/soql_sosl/sforce_api_calls_soql_select_fields.htm

I am trying to write below query in the ADF copy activity but it fails with syntax error.

SELECT FIELDS(ALL) FROM Order

In the linked service definition, we could only see the version 50.0 as shown in the below snip. We need to have atleast version 51.0 in order to use the Select statement with FIELDS(ALL).

Could you pls check it and let me know if this is something that needs to be fixed in Azure Linked Service definition.

//Kesavan.

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,101 questions
{count} votes

Accepted answer
  1. PRADEEPCHEEKATLA-MSFT 73,731 Reputation points Microsoft Employee
    2021-05-13T10:39:19.097+00:00

    Hello @Ramamoorthy, Kesavan ,

    UPDATE (June 9, 2021): The latest version are now available in the drop down list.

    103836-image.png

    -------------------------------------------

    The UI control for API version is typeable, you can directly input desirable API version regardless of dropdown option list.

    96299-salesforce.gif

    Note: And the option list for API version (51.0 & 52.0) will be filled with the newest supported version soon.

    One side query, could you please confirm what’s the blocker for you to detect it’s an editable UI control?

    This helps us identify what we can improve in the future.

    Hope this helps. Do let us know if you any further queries.

    ------------

    Please don’t forget to Accept Answer and Up-Vote wherever the information provided helps you, this can be beneficial to other community members.

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful