Developer forum

Forum » Dynamicweb 10 » Tables not found in schema when exporting with OData v4 blueprint

Tables not found in schema when exporting with OData v4 blueprint

E-mail notifications
Jóhannes Þorkell Tómasson
Reply
Posted on 23/06/2025 16:04:09

Hi.

We setup OData v4 blueprints for a client but we can't export anything (the tables/pages aren't found in the export schema). I've tried using the base api url with and without specifying the company i.e. https://api.businesscentral.dynamics.com/v2.0/[TENANT_ID]/[ENVIROMENT_NAME]/ODataV4/Company(['COMPANY_ID']) and https://api.businesscentral.dynamics.com/v2.0/[TENANT_ID]/[ENVIROMENT_NAME]/ODataV4. We really just need to export orders but none of the export activities seem to work.

The imports work fine (indcluding the orders) and I can send orders through postman to specific endpoints (e.g. DynamicwebSalesOrder etc.) with the same credentials we use for our endpoint collection. 

Best regards, Jóhannes


Replies

 
Matthias Sebastian Sort Dynamicweb Employee
Matthias Sebastian Sort
Posted on 24/06/2025 09:27:36
Reply

Hi Jóhannes Þorkell Tómasson,

We've implemented a feature in DW10 called "Schema management", if this is set to be active in your solution, then after you've updated your activity (set the endpoint that the OData Provider should use), then for updating the schema go to SETTINGS --> Areas --> Integration --> Schemas and find/update it there (look for the endpoint name in the "Details" tap)

Your endpoint URL should contain your company_name (when doing V4 blueprints), this is what I use for our own/local BC https://api.businesscentral.dynamics.com/v2.0/[TENANT_ID]/[ENVIROMENT_NAME]/ODataV4/Company('CRONUS%20UK%20Ltd.')/

If you want to use default API the URL should look like this (containing the company_ID)  https://api.businesscentral.dynamics.com/v2.0/[TENANT_ID]/[ENVIROMENT_NAME]/api/v2.0/companies(0f8058e0-affd-ea11-bb48-000d3a2fece2)

Have you looked at the conditionals added to the table mappings in the blueprints, maybe your orders does not meet thoese conditionals and therefor nothing is exported? If you've already checked that, or your orders that you want to export meets the conditionals, then I need some more informations, like what version of the blueprints are you using and DW version.

BR

Matthias Sort

 
Jóhannes Þorkell Tómasson
Posted on 29/06/2025 16:50:31
Reply

Hi Matthias, thanks for your reply.

I Activated the Schema Management feature and the order exports started working. Our imports, however, stopped working but deactivating the feature again fixed the imports and the Order exports still seem to work so I think we're good.

Best Regards

Jóhannes

 

You must be logged in to post in the forum