Answered

Patch a multiple choice column using ajax

(0) Share

Report

Posted on by DB-31030832-0

Hi,

I'm trying to create records in a dataverse table using ajax, as explained in this guide : Portals Web API write, update, and delete operations | Microsoft Learn

    (function(webapi, $){
		function safeAjax(ajaxOptions) {
			var deferredAjax = $.Deferred();
	
			shell.getTokenDeferred().done(function (token) {
				// add headers for AJAX
				if (!ajaxOptions.headers) {
					$.extend(ajaxOptions, {
						headers: {
							"__RequestVerificationToken": token
						}
					}); 
				} else {
					ajaxOptions.headers["__RequestVerificationToken"] = token;
				}
				$.ajax(ajaxOptions)
					.done(function(data, textStatus, jqXHR) {
						validateLoginSession(data, textStatus, jqXHR, deferredAjax.resolve);
					}).fail(deferredAjax.reject); //AJAX
			}).fail(function () {
				deferredAjax.rejectWith(this, arguments); // on token failure pass the token AJAX and args
			});
	
			return deferredAjax.promise();	
		}
		webapi.safeAjax = safeAjax;
	})(window.webapi = window.webapi || {}, jQuery)

	webapi.safeAjax({
		type: "POST",
		url: "/_api/accounts",
		contentType: "application/json",
		data: JSON.stringify({
			"name": "Sample Account"
		}),
		success: function (res, status, xhr) {
      //print id of newly created table record
			console.log("entityID: "+ xhr.getResponseHeader("entityid"))
		}
	});

I got everything working, except I can't figure out how to work with multiple choice fields. Any help ?

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

DP_Prabh 341 on at

Like (1)

Report
Copy link

Link copied!

Hi @DB-31030832-0,

I’ve done something similar before. In my case, I needed to update a specific row and a specific column in the Account table, where the column was a multi-choice field. The following code worked for me.

Code:

var record = {};
record.cr5d7_multicategory = "444200000,444200001"; // Choices

webapi.safeAjax({
   type: "PATCH",
   contentType: "application/json",
   url: "/_api/accounts(Record-GUID-ID)", //add your GUID in parentheses
   data: JSON.stringify(record),
   success: function (data, textStatus, xhr) {
       console.log("Record updated");
   },
   error: function (xhr, textStatus, errorThrown) {
       console.log(xhr);
   }
});

I hope this works for you!

Was this reply helpful? Yes No
DB-31030832-0 6 on at

Like (0)

Report
Copy link

Link copied!

Hi @DP_Prabh,

I thought I had already tried that, but this time it worked. Thanks for the help !

Was this reply helpful? Yes No