Hi All,
I'm working on an integration between NetSuite, SalesForce and D365FO (V29).
Created new data entities etc. and on my DevBox I have everything working as expected. After I moved my changes to the TEST and ACC environments, I noticed that the Queries did not return any data in these environments. Part of the integration is creating sales orders in D365FO. This works Ok, so the security, client id's etc. are OK. It's only querying the data that gives issues.
I'm using Boomi to integrate all the data. After I discovered the above I started testing the same with Postman. In Postman I have the same issues. Data is not returned from TEST and ACC. Not for custom data entities, but also not for standard D365FO entities.
Example (with a standard D365FO entity):
Executed on my Dev box and you see I have a result.
When I execute it on ACC:
and empty result as you can see.
Tried several things like giving the service account user System Administrator privileges in ACC, truncate and refresh the data entities list in D365FO. Using cross-company=true etc., But without any result.
I have no idea what it is I'm missing here. Any thoughts ?
Thanks a lot !!!
Cheers,
Gerard
Indeed Martin: In my dev box the service account had a default company set. In ACC it didn't.
Much obliged ! I can proceed with further testing.
This thread is about OData services, not about export through data management.
Check Framework Parameters from The Data Management module. On one of the tabs there is a general setting (a toggle) that activates export for all companies.
This however does not work for MSFT entities of the 'master' type. You still need to export across companies, but you can set this in the export group definition
You aren't done yet.
Most tables in F&O can store data "per company". You're logged in a particular company (e.g. USMF in the demo data) and what you see in forms and reports is data related just to this company. For example, not all records in CustGroup table, but just those with DataAreaId = "USMF".
The same happens with OData. By default, you see only data from the default company associated with the user making the request.
With cross-company=true, you're getting data from all companies, i.e. regardless of the value in DataAreaId field. But you typically don't want that; you want data from a single company. If that's the case, you can either use cross-company=true and filter by a particular DataAreaId, or change the default company of the user.
That did the trick Martin !
Can you explain to me why I need this in ACC/TEST and not in my DevBox ? Or point me to some documentation regarding this ? I have to go offline now, but will see your reply tomorrow.
Thanks a lot !!
Please try it once more without the dollar sign ($).
Thanks Martin,
Nope; tried that with the same result:
Cheers,
Gerard
Will the result change if you add cross-company=true parameter to the URL?
André Arnaud de Cal...
292,031
Super User 2025 Season 1
Martin Dráb
230,868
Most Valuable Professional
nmaenpaa
101,156