How to get user id from kingswaysoft.integration.toolkit.dynamicscrm

(0) Share

Report

Posted on by pavankumar

HI,

I am using SSIS package to update data from dynamics crm to Database. I have connected dynamics crm using application id and secret. How to get connected dynamics user GUID in derived column?

Thanks,

Pavan N

All responses (5)

Answers (0)

Suggested answer

a33ik 84,325 Most Valuable Professional on at

Like (1)

Report

RE: How to get user id from kingswaysoft.integration.toolkit.dynamicscrm

Hello,

You can do a query to the systemuser table and user equal-userid condition - one record returned will be your app user so you can get your id, put it to the variable and use it in your package.

Good luck.
pavankumar 95 on at

Like (0)

Report

RE: How to get user id from kingswaysoft.integration.toolkit.dynamicscrm

I want to pass this information back to CRM. who is updating the record. its a custom field.
Pradeep Rai 5,482 Super User 2025 Season 1 on at

Like (0)

Report

RE: How to get user id from kingswaysoft.integration.toolkit.dynamicscrm

Just question why you want to use connected user id in SSIS?
pavankumar 95 on at

Like (0)

Report

RE: How to get user id from kingswaysoft.integration.toolkit.dynamicscrm

No, due to we are using different application id for production environment.
Pradeep Rai 5,482 Super User 2025 Season 1 on at

Like (0)

Report

RE: How to get user id from kingswaysoft.integration.toolkit.dynamicscrm

Did you tried by hardcoding GUID?