Dynamics Community Forum Thread Details

Insert data of embedded data source on data entity, skip root data source insert

Hello all,

I wish to skip data insert of root data source and insert only embedded data source data.

I have case with prepayment journal table which has prepayment lines, and each line can have multiple details lines(sublines).

Client wants to add new details lines(sublines) with open to excel and not to insert and new lines or journal.

Current approach is data entity with prepayment lines as root data source, because i want to show all lines with no sublines and prepayment sublines as embedded data source.

I tried multiple different ways but always get stuck one way or another, did anyone was working on something similar or have idea in what direction should i go?

I set database operations in mapEntityToDataSource at None for both data sources, and then in subline do manual doInsert() call.

I dont have problem with delete and update but inserting new row always throws error:

A row created in data set PrepaymentInvoiceJournalLines was not published. Error message: 'Bad Request'

Error Publishing Row

Details:
A row created in data set PrepaymentInvoiceJournalLines was not published. Error message: 'Bad Request'

There was an error clearing the table's formatting

Details:
The argument is invalid or missing or has an incorrect format.

When inserting same data in some other custom method everything is succesfully saved

Best regards

Quick Links