Showing results for 
Search instead for 
Did you mean: 
Level: Power Up

How to insert data in table that is created as part of a N:N relationship using CDS API



I have a Product table and Product Category table, each Product can be a part of multiple categories. I have created the Product and Product Category entity and set a N:N relationship between the 2 entities.

I have a console application that calls the CDS API to get the data from the entities or add records in the entities and it is working fine. But when I am trying to call the CDS API to insert data into the meta table that is created as part of the N:N relationship then the API call fails. 


Any help on this will be appreciated

Level: Power Up

Error faced during API Call

Adding to the question, the error we are facing is HTTP 400 - Bad Request. The model being passed to the API is identical to the fields present in the metadata entity, still the call is failing. We tried accessing the same request URI in browser just to be sure if there is no mistake in the path, and it worked absolutely fine.

Helpful resources


Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!


Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020


Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Kudoed Authors (Last 30 Days)
Users online (6,004)