Unanswered

Problem with Web API creating record with lookup value

(0) Share

Report

Posted on by absoluteBeginer

Hi,

I'm having a problem creating a new record with the web api. I can't get it to work. I've set up table permissions and web roles.

I have 2 tables, my_table which has a lookup field in linked_table. My call is as below which is linked to a button click in javascript.

 webapi.safeAjax({
 type: "POST",
 url: "/_api/my_tables",
 contentType: "application/json",
 data: JSON.stringify({ "my_lookup@odata.bind": "/linked_tables(" + id + ")", 
 "email_field" : "email", "message_field" : "message"}),
 success: function (res) {
 console.log(res);
 }
 });

Nothing seems to be happening.

I'm a bit confused with what to use with plurals and whether to use schema or logical name.

Can anyone help?

Thanks

Categories:

Design & build

I have the same question (0)

All responses (4)

Answers (0)

Fubar 8,338 Super User 2025 Season 2 on at

Like (0)

Report
You probably need to be more clear about what you are wanting to do:
Create a new record and populate a Lookup field on it with an existing record would be similar to the JSON Sample column in the table: https://learn.microsoft.com/en-us/power-apps/maker/portals/write-update-delete-operations#associate-table-records-on-create)
Create a new record and create a new associated record in the same call would be similar to the basic create example in the JSON below the basic table (the one in the table is too basic) https://learn.microsoft.com/en-us/power-apps/maker/portals/write-update-delete-operations#basic-create)
link/associate 2 existing records, you'll also find further down the page linked in the 2 above.
If you look at the examples in the links above they generally use out of the box entities whose schema names are account, contact, and opportunity, task etc (and you'll see the 'plural' - not really plural it is the Entity Set Name see https://learn.microsoft.com/en-us/power-apps/maker/portals/write-update-delete-operations#basic-create )

XrmToolBox also has a Dataverse Rest Builder that can be useful for putting together simple calls (and you can also get an idea from the simple bits how to build more complex ones)

Was this reply helpful? Yes No
absoluteBeginer 80 on at

Like (0)

Report

Thank you, I will take a look. I followed a tutorial on the Microsoft web pages and that seemed to work (again simple case for contact entity). I suspect that either I haven't the correct permissions set up, or my syntax is wrong.

Thanks

Was this reply helpful? Yes No
Fubar 8,338 Super User 2025 Season 2 on at

Like (0)

Report

A permission type error will show in the Browsers Console (F12) and the response to the request will show slightly more info than what is in the Console draw.

Was this reply helpful? Yes No
absoluteBeginer 80 on at

Like (0)

Report

Just an update, I seem to have got it working. This link
PowerApps Portals – Use Web API to Create, Update and Delete records | Hitachi Solutions (hitachi-solutions.co.uk)

was quite helpful. I think I didn't have the correct case on the lookup column name.

Thanks for you help

1 people found this reply helpful.

Was this reply helpful? Yes No