ADF Linked Service with Salesforce connector latest version unavailable

Question

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.

Answer 1

Hello @Ramamoorthy, Kesavan ,

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

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

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

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.