Finance | Project Operations, Human Resources, ...

Import data through odata in a specific company

(0) Share

Report

Posted on by Dev

400

Hi,

I am using postman to import data into D365FO but the data is created into the default user company.

I see we can filter based on company while performing GET request but not while POST:https://<D365URL>/data/<DataEntity>.

I am trying to give dataareaid as different company in the body but it doesn't work as well.

Thanks!

All responses (11)

Answers (0)

Layan Jwei 7,679 Super User 2025 Season 1 on at

Like (0)

Report

Import data through odata in a specific company

Hi Dev,

Can you try with a different environment that is not a Demo? To see if it's a limitation in demo environments.

Thanks,

Layan Jweihan
Please mark this answer as "Verified" if it solved your issue. In order to help others who will face a similar issue in the future
Dev 400 on at

Like (1)

Report

Import data through odata in a specific company

Hi Layan,

You are right. I tried to post to usmf with empty default company then it posted to DAT.

Also, I tried to change the crosscompany position as u said but still got the wrong result.

Now I am wondering what could be the issue as it is a demo env and I do not have dev access to debug.

Thanks!
Layan Jwei 7,679 Super User 2025 Season 1 on at

Like (0)

Report

Import data through odata in a specific company

Hi Dev,

This shouldn't be the issue. True, Odata returns the data by the user default company,

However, if you want a different dataArea then you use the cross-company.

The only difference i can see that you put cross-company after filter while i did it before (not sure if this is the cause)

And it worked with me even though my user has a default company.

And what if it worked with you because it considered Empty default company as DAT. Try to actually release to usmf now (without default company for the user) and see if it returns dat or usmf.

Thanks,

Layan Jweihan

Please mark this answer as "Verified" if it solved your issue. In order to help others who will face a similar issue in the future
Dev 400 on at

Like (0)

Report

Import data through odata in a specific company

Hi Layan,

The issue was as the default company was set for the user when I removed that it worked !
Suggested answer

Layan Jwei 7,679 Super User 2025 Season 1 on at

Like (0)

Report

Import data through odata in a specific company

Hi Dev,

I just tried it and it works perfectly. (Make sure you are using the correct url)

1. I went to product masters and created an item manually of type Product called Test2.

2. I went to postman, and called the link (url/data/ReleasedProductsV2?cross-company=true&$filter=dataAreaId eq 'dat') as you can see below -- and it returned DAT

If you are still facing the same issue, maybe try to debug and see why it's not behaving properly of if there is any customization

Thanks,
Layan Jweihan
Please mark this answer as "Verified" if it solved your issue. In order to help others who will face a similar issue in the future
Dev 400 on at

Like (1)

Report

Import data through odata in a specific company

HI Layan,
Layan Jwei 7,679 Super User 2025 Season 1 on at

Like (1)

Report

Import data through odata in a specific company

Hi Dev,

Can you share the "body" here

Thanks,
Layan Jweihan
Dev 400 on at

Like (1)

Report

Import data through odata in a specific company

Hi Layan,

This is what is happening for me I set the dataareaid as DAT but the data is still populated in USMF.

Thanks!
Suggested answer

Layan Jwei 7,679 Super User 2025 Season 1 on at

Like (0)

Report

Import data through odata in a specific company

Hi Dev,

It also works for posting. can you please show us what you did? what's the url you used and what did you fill the body with? and if you are getting an error show it to us.

I did an example for creating contacts and it works fine (i specified dataArea in the url and not the body)

Thanks,
Layan Jweihan

Please mark this answer as "Verified" if it solved your issue. In order to help others who will face a similar issue in the future
Dev 400 on at

Like (1)

Report

Import data through odata in a specific company

Hi Layan,

This works to get the data from F&O using GET. I am need the similar thing to import data into F&O using POST (in postman).

Thanks!