How to programmatically retrieve records imported in Dynamics 365?
up vote
0
down vote
favorite
I have written a C# console app that pulls data from our legacy system using SQL, converts it to a CSV file, and then loads it into Dynamics 365 using an Import Map stored in the system.
After I load the Accounts and Contacts, I need to import the records for the N:N relationship. To do this, I need to know the IDs for the Accounts and Contacts that I have imported.
If I have the Import.ID of the import I did, is there a way I can query to get the records that were inserted during that import?
When you import data using the UI, you are able to see the list of records created or updated during an import. How do I do that programmatically?
dynamics-crm data-migration dynamics-crm-365
asked Nov 19 at 22:56
devdev
233
add a comment |
up vote
0
down vote
favorite
I have written a C# console app that pulls data from our legacy system using SQL, converts it to a CSV file, and then loads it into Dynamics 365 using an Import Map stored in the system.
After I load the Accounts and Contacts, I need to import the records for the N:N relationship. To do this, I need to know the IDs for the Accounts and Contacts that I have imported.
If I have the Import.ID of the import I did, is there a way I can query to get the records that were inserted during that import?
When you import data using the UI, you are able to see the list of records created or updated during an import. How do I do that programmatically?
dynamics-crm data-migration dynamics-crm-365
asked Nov 19 at 22:56
devdev
233
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
I have written a C# console app that pulls data from our legacy system using SQL, converts it to a CSV file, and then loads it into Dynamics 365 using an Import Map stored in the system.
After I load the Accounts and Contacts, I need to import the records for the N:N relationship. To do this, I need to know the IDs for the Accounts and Contacts that I have imported.
If I have the Import.ID of the import I did, is there a way I can query to get the records that were inserted during that import?
When you import data using the UI, you are able to see the list of records created or updated during an import. How do I do that programmatically?
dynamics-crm data-migration dynamics-crm-365
asked Nov 19 at 22:56
devdev
233
I have written a C# console app that pulls data from our legacy system using SQL, converts it to a CSV file, and then loads it into Dynamics 365 using an Import Map stored in the system.
After I load the Accounts and Contacts, I need to import the records for the N:N relationship. To do this, I need to know the IDs for the Accounts and Contacts that I have imported.
If I have the Import.ID of the import I did, is there a way I can query to get the records that were inserted during that import?
When you import data using the UI, you are able to see the list of records created or updated during an import. How do I do that programmatically?
dynamics-crm data-migration dynamics-crm-365
dynamics-crm data-migration dynamics-crm-365
asked Nov 19 at 22:56
devdev
233
asked Nov 19 at 22:56
devdev
233
asked Nov 19 at 22:56
devdev
233
asked Nov 19 at 22:56
devdev
233
asked Nov 19 at 22:56
devdev
233
233
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
up vote
0
down vote
accepted
When you import records via the bulk import tool the out-of-box field importsequencenumber should get populated.
Alternatively, you can write some info about the import to an unused field like ftpsiteurl, or create a custom field to contain info about the import.
answered Nov 20 at 13:27
Aron
1,8222917
add a comment |
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
0
down vote
accepted
When you import records via the bulk import tool the out-of-box field importsequencenumber should get populated.
Alternatively, you can write some info about the import to an unused field like ftpsiteurl, or create a custom field to contain info about the import.
answered Nov 20 at 13:27
Aron
1,8222917
add a comment |
up vote
0
down vote
accepted
When you import records via the bulk import tool the out-of-box field importsequencenumber should get populated.
Alternatively, you can write some info about the import to an unused field like ftpsiteurl, or create a custom field to contain info about the import.
answered Nov 20 at 13:27
Aron
1,8222917
add a comment |
up vote
0
down vote
accepted
up vote
0
down vote
accepted
When you import records via the bulk import tool the out-of-box field importsequencenumber should get populated.
Alternatively, you can write some info about the import to an unused field like ftpsiteurl, or create a custom field to contain info about the import.
answered Nov 20 at 13:27
Aron
1,8222917
When you import records via the bulk import tool the out-of-box field importsequencenumber should get populated.
Alternatively, you can write some info about the import to an unused field like ftpsiteurl, or create a custom field to contain info about the import.
answered Nov 20 at 13:27
Aron
1,8222917
answered Nov 20 at 13:27
Aron
1,8222917
answered Nov 20 at 13:27
Aron
1,8222917
answered Nov 20 at 13:27
Aron
1,8222917
1,8222917
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53383835%2fhow-to-programmatically-retrieve-records-imported-in-dynamics-365%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
