How to change the ownerid on an account

(0) Share

Report

Posted on by BrianM2

Hi,

I am able to create a new account using the web API /api/data/v9.2/accounts. But when I do this. It allocates the account to the API account. How would I then change the _ownerid to the correct user after creation, if the _ownerid is a read-only property?

The goal is to export all accounts from another system to Dynamics using the web API and then allocate these accounts to the correct users that also exist on the old system

I have the same question (0)

All responses (9)

Answers (1)

Suggested answer

a33ik 84,331 Most Valuable Professional on at

Like (0)

Report

RE: How to change the ownerid on an account

Hello,

If my reply (or replies) answers your question take a minute and verify the answer. You can do it by clicking "Yes" at the top of the reply (or replies) under the label "Does this answer your question?"

Was this reply helpful? Yes No
BrianM2 10 on at

Like (0)

Report

RE: How to change the ownerid on an account

Hi Andrew,

Thanks for your help. I got it to work. I had to also change /systemuser to /systemusers.

Was this reply helpful? Yes No
Verified answer

a33ik 84,331 Most Valuable Professional on at

Like (1)

Report

RE: How to change the ownerid on an account

Not familiar with VB so it's hard for me to give you exact the code. Here is what you have to send:

{

"ownerid@odata.bind": "/systemuser(151F639c-1c73-eb11-b1ab-000d3a253b40)"

}

Also, you will have to use "PATCH" instead of "POST". Check this - docs.microsoft.com/.../update-delete-entities-using-web-api

1 people found this reply helpful.

Was this reply helpful? Yes No
BrianM2 10 on at

Like (0)

Report

RE: How to change the ownerid on an account

Hi Andrew,

Below is a sample in VB.NET. I have commented out some of my other attempts.

Private Sub btnUpdateAccount_Click(sender As Object, e As EventArgs) Handles btnUpdateAccount.Click

Dim m_http As New MSXML2.ServerXMLHTTP60

Dim Responce As String = ""

Dim _json As New JSON

Dim tt() As JSON.AccountInfo

Dim JSON As String = ""

Try

'JSON = "{""value"": ""123456789""}"

'JSON = "{""value"":""/systemuser(151F639c-1c73-eb11-b1ab-000d3a253b40)""}"

JSON = "{entity[""ownerid@odata.bind""]=""/systemuser(151F639c-1c73-eb11-b1ab-000d3a253b40)""}"

'JSON = "{""ownerid@odata.bind"":""71872ae2-4eae-eb11-8236-00224881db1e""}"

' m_http.open("PUT", "/api/data/v9.2/accounts(6a09a29c-78c3-eb11-bacc-00224881adac)/accountnumber", False)

m_http.open("POST", "/api/data/v9.2/accounts(6a09a29c-78c3-eb11-bacc-00224881adac)", False)

m_http.setRequestHeader("Content-Type", "application/json")

m_http.setRequestHeader("Authorization", "Bearer " & pub_Token)

m_http.send(JSON)

Responce = m_http.responseText()

Catch ex As Exception

End Try

End Sub

Was this reply helpful? Yes No
a33ik 84,331 Most Valuable Professional on at

Like (0)

Report

RE: How to change the ownerid on an account

Brian,

It would be easier to do the opposite way. Post what you have, I will correct it.

Was this reply helpful? Yes No
BrianM2 10 on at

Like (0)

Report

RE: How to change the ownerid on an account

Hi Andrew,

I now get "Unmapped Request found, PathTemplate:~/entityset/key, HttpVerb:POST"

Do you have an example of what the JSON should look like?

Was this reply helpful? Yes No
Suggested answer

a33ik 84,331 Most Valuable Professional on at

Like (1)

Report

RE: How to change the ownerid on an account

Drop 'ownerid' piece from your post part like:

POST /api/data/v9.2/accounts(6a09a29c-78c3-eb11-bacc-00224881adac)

Was this reply helpful? Yes No
BrianM2 10 on at

Like (0)

Report

RE: How to change the ownerid on an account

Thanks for replying.

I'm however not sure how the JSON string should look

I have tried:

POST /api/data/v9.2/accounts(6a09a29c-78c3-eb11-bacc-00224881adac)/ownerid

{

"ownerid@odata.bind":"/systemuser(151F639c-1c73-eb11-b1ab-000d3a253b40)"

}

Response

A property 'ownerid' which only has property annotations in the payload but no property value is declared to be of type 'Edm.Guid'. In OData, only navigation properties and named streams can be represented as properties without values

POST /api/data/v9.2/accounts(6a09a29c-78c3-eb11-bacc-00224881adac)/ownerid

{

"value": "ownerid@odata.bind"="/systemuser(151F639c-1c73-eb11-b1ab-000d3a253b40)"

}

Response

an error occurred while validating input parameters

Was this reply helpful? Yes No
Suggested answer

a33ik 84,331 Most Valuable Professional on at

Like (1)

Report

RE: How to change the ownerid on an account

Hello,

Try to use following ownerid property setting:

entity["ownerid@odata.bind"] = "/systemusers(956B410F-0F6E-E711-810E-00155D6FD705)";

Was this reply helpful? Yes No

Community site session details

How to change the ownerid on an account

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Abhilash Warrier – Community Spotlight

Congratulations to the September Top 10 Community Leaders!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates

Community site session details

How to change the ownerid on an account

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Abhilash Warrier – Community Spotlight

Congratulations to the September Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates