How to extract ProcessInstanceHistory object records using new Salesforce connector from ADF

S D, Sudevika 40

We are trying to extract the data from Salesforce for the ProcessInstanceHistory object through the new Salesforce connector. There is a limitation for the new connector as it doesn't allow inner SOQL query for Bulk API. We have tried using REST API but it doesn't help to extract the nested records.

1 answer

Ganesh Gurram 3,025 Reputation points Microsoft Vendor

2025-01-08T11:25:19.58+00:00

Hi @S D, Sudevika

Thanks for the question and using MS Q&A platform.

The BulkAPI has limitations which do no allow for Select * or Select Fields(ALL) as a query, and additionally there is no connector to a salesforce API that could be used to dynamically identify columns.

Appreciate if you could share the feedback on our feedback channel. Which would be open for the user community to upvote & comment on. This allows our product teams to effectively prioritize your request against our existing feature backlog and gives insight into the potential impact of implementing the suggested feature.

Reference: https://learn.microsoft.com/en-us/answers/questions/1858944/how-to-solve-issue-with-salesforce-connector

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

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.
Please sign in to rate this answer.
S D, Sudevika 40 Reputation points

2025-01-08T11:40:26.1133333+00:00

thanks @ganesh gurram for the response, but the problem here is about extracting this particular object as we cannot directly query it. The ProcessInstanceHistory object can be queried only though child relationship -StepandWorkitems. Please find the SOQL query. The new Salesforce connector doesnt allow this type of querying for BULK API. Is there any resolution or workaround?

SELECT (SELECT ActorId, Comments, CreatedById, CreatedDate, ElapsedTimeInDays, ElapsedTimeInHours, ElapsedTimeInMinutes, Id, IsDeleted, IsPending, OriginalActorId, ProcessInstanceId, ProcessNodeId, RemindersSent, StepStatus, SystemModstamp, TargetObjectId FROM StepsAndWorkitems) FROM ProcessInstance

Ganesh Gurram 3,025 Reputation points Microsoft Vendor

2025-01-09T12:31:23.69+00:00

@S D, Sudevika
Please check the similar issues from Microsoft Q&A platform which might be helpful:
https://learn.microsoft.com/en-us/answers/questions/1685375/issue-with-the-new-salesforce-connector-v2

https://learn.microsoft.com/en-us/answers/questions/1858944/how-to-solve-issue-with-salesforce-connector

https://learn.microsoft.com/en-us/answers/questions/1669230/salesforce-v2-link-service-doenst-work-error-messa
As previously mentioned, sharing your feedback on the Microsoft feedback channel can help prioritize this feature request. You can also check for any updates or workarounds provided by the community.

Thank you.

Ganesh Gurram 3,025 Reputation points Microsoft Vendor

2025-01-10T09:19:03.98+00:00

@S D, Sudevika - We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

How to extract ProcessInstanceHistory object records using new Salesforce connector from ADF

1 answer

Your answer