Import From Package API vs Import through UI

(0) Share

Report

Posted on by rah_barheyan

I am new to D365 FO and implementing integration to import Data into D365 based on the Import Project Definition

In the UI it seems, as you can select you Import Project and Click Run Project and then upload the file to import and start importing (import starts and ends with success or failure).

On the other hand testing ImportFromPackage API seems to be different, it requires you upload a zip file that contains the input and Manifest and PackageHeader files.

Is there an API that can be used to basically mimic the UI behavior? I want the integration to only send a file and Import Project Name

Thanks,

Rah

I have the same question (0)

All responses (7)

Answers (1)

rah_barheyan 30 on at

Like (0)

Report

After Further testing it looks like the ImportFromPackage is creating an new import package, which makes sense why Manifest and PackageHeader need to be supplied.

docs.microsoft.com/.../data-management-api

Is there a way to use the Package API and Import using existing Data Project defined in D365 rather than the above

Was this reply helpful? Yes No
Verified answer

zhifeng on at

Like (1)

Report

Please check if "Recurring integrations" is what you need. It is recommend to use Package API.

docs.microsoft.com/.../recurring-integrations

Was this reply helpful? Yes No
rah_barheyan 30 on at

Like (0)

Report

Thanks Kevin, this looks very promising. I have two questions.

Is there a way to trigger the message processing dynamically instead of waiting on the schedule to pick it up?

How can I get the the ExecutionId of the Import Project to get see if there are any errors?

Edit: Import Project gets created with a timestamp, was hoping it gets created with the same id as the message, so is there a way to query the API to get Execution Id that was created as part of the message processing?

[quote user="Kevin"]
Please check if "Recurring integrations" is what you need. It is recommend to use Package API.

docs.microsoft.com/.../recurring-integrations
[/quote]

Was this reply helpful? Yes No
nmaenpaa 101,160 Moderator on at

Like (0)

Report

Recurring data jobs are scheduled and triggered by the D365 batch job. If you want to trigger the import from the caller system you should use the Data Package API.

Was this reply helpful? Yes No
rah_barheyan 30 on at

Like (0)

Report

Thanks Nikolaos for your comment.

For the Package API, I have to provide import definition, I want my integration to be dynamic, and allow the users to modify mapping fields in D365, and add extra fields in their input files, without having to update the code or the add complexity of defining a dynamic package in the integration.

The scheduler seems to allow you to provide a csv,excel file to use with an existing Import Project, the only issue I am having is I can't trigger it immediately (I have to wait for the scheduler to pick it up it seems) and also I need to figure out how to get the execution id back from the scheduler when it creates the import job.

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,160 Moderator on at

Like (0)

Report

You can schedule it to run every minute if you want to avoid waiting. What exactly do you need to achieve when you talk about getting the Execution id? What would you use it for?

Was this reply helpful? Yes No
rah_barheyan 30 on at

Like (0)

Report

I am trying to implement the an interface that takes file and send it to existing Import Project. The recurring integration seems to be what I need to use, I have to reduce the recurrence to every minute.

Once the recurrence takes a DMF execution occur as result, Seems the execution contains the name of the recurrence but not the id of the message the recurrence processed so I built a logic handle that through OData

once I get the execution id back after know the message is processed (with/without errors), I expose the errors to the users using the interface

Was this reply helpful? Yes No

Join the conversation

Community site session details

Import From Package API vs Import through UI

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

Import From Package API vs Import through UI

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates