如何使用rest api在查阅列中存储值 [英] How to store value in lookup column using rest api

问题描述

大家好，

我有一个包含列TierType（单行文本列）的共享点列表，它存储所有TierTypes值。

我也有批处理列表，在批处理列表中我创建了TierType作为查阅列。

其工作正常OOTB。

但我在sharepoint .aspx页面上有一个自定义下拉列表。在下拉列表中，我已经将所有TierType值与相应的项目ID绑定。

< img alt =""src ="https://social.msdn.microsoft.com/Forums/getfile/1410281">

我想在Batch list Tier中存储这个Selected TierType值使用Rest API查找列。我使用rest api代码，但此代码不起作用。

  function saveTierTyp（）

  &NBSP; &NBSP; &NBSP; {

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; var dcTier = $（&＃; tierDropdown"）。val（）;

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; $ .ajax

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; （{

&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP; URL：_spPageContextInfo.webAbsoluteUrl + QUOT; / _ AP​​I /网络/列表/ GetByTitle （'批次'）/项目"，&
             type：" POST"，

             async：false，

     &NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;数据：JSON.stringify

&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP ; （{

             __metadata：

   ;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP; {

&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;    type：" SP.Data.BatchListItem"

    &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; }，b $ b  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP;等级：dcTier

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; }），

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP;标题：

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; {

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; "接受"："application / json; odata = verbose"，

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; "Content-Type"："application / json; odata = verbose"，

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; " X-RequestDigest"：$（" #__ REQUESTDIGEST"）。val（），

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; "X-HTTP-Method"：" POST"

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; }，b $ b  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP;成功：功能（数据，状态，xhr）

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; {

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP;提醒（"已插入项目！"）

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; }，b $ b  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP;错误：功能（xhr，状态，错误）

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; {

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP;提示（"未插入！"）

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; }¥b $ b  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; }）;

  &NBSP; &NBSP; &NBSP; } b $ b

请帮忙！

解决方案

这里你去了

https://sharepoint.stackexchange.com/questions/162329/inserting-data-to-lookup -field-使用静止-API

Hello to all,

I have one sharepoint list which has column TierType (Single Line Text Column), which store all TierTypes values.

I also have Batch List, In Batch list i create TierType as a lookup column.

Its working fine in OOTB.

But I have one custom dropdown on sharepoint .aspx page, In dropdown i already bind all TierType values with respective item ID.

I want to store this Selected TierType value in Batch list Tier lookup column using Rest API. I use rest api code but this code is not work.

 function saveTierTyp()
        {
                var dcTier = $("#tierDropdown").val();

                $.ajax
                ({
                        url: _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/GetByTitle('Batch')/items",
                        type: "POST",
                        async:false,
                        data: JSON.stringify
                        ({
                        __metadata:
                        {
                        type: "SP.Data.BatchListItem"
                        },
                            Tier:dcTier
                        }),
                        headers:
                        {
                        "Accept": "application/json;odata=verbose",
                        "Content-Type": "application/json;odata=verbose",
                        "X-RequestDigest": $("#__REQUESTDIGEST").val(),
                        "X-HTTP-Method": "POST"
                        },
                        success: function(data, status, xhr)
                        {
                                                alert("Item Inserted!")
                        },
                        error: function(xhr, status, error)
                        {
                                                alert("Not Inserted!")
                        }
                });
        }

Please Help!

解决方案

Here you go

https://sharepoint.stackexchange.com/questions/162329/inserting-data-to-lookup-field-using-rest-api

这篇关于如何使用rest api在查阅列中存储值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！