Creating opportunity through SQL Server

(0) Share

Report

Posted on by Uchkana

Hello guys,

I need to create bulk opportunities but my data import section doesn't work at the moment. So, I wanted to create an opportunity through SQL Server. But it is giving the following error. Are there any ways to bulk create opportunities without importing?

All responses (1)

Answers (1)

Verified answer

Guido Preite 54,087 Super User 2024 Season 1 on at

Like (1)

Report

RE: Creating opportunity through SQL Server

The only supported operation against the Dynamics CRM / Dynamics 365 CE / Dataverse database is the READ operation (done by SELECT using FilteredViews if OnPremise or by querying the TDS endpoint). Other operations (like CREATE, UPDATE, DELETE) are not supported.