# 別アプリ内テーブルへの書き込み

**URL:** <https://community.cybozu.dev/t/topic/5845>\
**Category:** kintone 開発相談\
**Created:** [2022 年 3 月 29 日午後 4:45 UTC](https://community.cybozu.dev/t/topic/5845 "2022-03-29T16:45:23Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Legacy\_Account374](https://avatars.discourse-cdn.com/v4/letter/l/8e7dd6/32.png) [@Legacy\_Account374](https://community.cybozu.dev/u/Legacy_Account374)\
**Post date:** [2022 年 3 月 29 日午後 4:45 UTC](https://community.cybozu.dev/t/topic/5845/1 "2022-03-29T16:45:23Z")

</div>

**背景・実現したいこと**

お世話になります。

Aアプリ(行動履歴)・Bアプリ(お客様情報)があり、Aアプリの特定フィールドの情報をBアプリのサブテーブル内に行を追加する形で更新したいと考えております。

&nbsp;テーブル内に更新されていることは確認が取れました。しかし、putのリクエストを投げると400で返されており必須項目に対しての入力がうまくできていないように感じています。

[https://developer.cybozu.io/hc/ja/articles/201941984#step4](https://community.cybozu.dev/hc/ja/articles/201941984#step4)

大変お手数をおかけいたしますが、アドバイスをいただけないでしょうか。

下記、エラーコードとなります。

**利用したソースコード**

(function () {

&nbsp; “use strict”;

&nbsp; let user = kintone.getLoginUser().code;

&nbsp; console.log(user);

&nbsp; if (user == “152006”) {

&nbsp; &nbsp; kintone.events.on(“app.record.index.show”, function (event) {

&nbsp; &nbsp; &nbsp; let records = event.records;

&nbsp; &nbsp; &nbsp; for (var m = 0; m \< records.length; m++) {

&nbsp; &nbsp; &nbsp; &nbsp; let tagName = records[m][“文字列\_\_1行\_\_1”].value;

&nbsp; &nbsp; &nbsp; &nbsp; let oldButton = document.getElementById(“UUアプリへ一括更新”);

&nbsp; &nbsp; &nbsp; &nbsp; let button = document.createElement(“button”);

&nbsp; &nbsp; &nbsp; &nbsp; if (oldButton !== null) oldButton.parentNode.removeChild(oldButton);

&nbsp; &nbsp; &nbsp; &nbsp; button.innerHTML = “UUアプリ更新”;

&nbsp; &nbsp; &nbsp; &nbsp; button.id = “UUアプリ更新”;

&nbsp; &nbsp; &nbsp; &nbsp; kintone.app.getHeaderMenuSpaceElement().appendChild(button);

&nbsp; &nbsp; &nbsp; &nbsp; button.addEventListener(“click”, function () {

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; let GET\_param = {

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; app: 917,

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Query: kintone.app.getQuery(),

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; fields: [“$id”, “文字列\_\_1行\_\_1”, “UURecordID”],

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; };

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return kintone

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; .api(kintone.api.url(“/k/v1/records”, true), “GET”, GET\_param)

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; .then(function (resp) {

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; let resp1 = resp.records;

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; console.log(resp);

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; for (let j = 0; j \< resp1.length; j++) {

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; let UUrecID = resp1[j].UURecordID.value;

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; console.log(UUrecID);

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; //UUアプリに対して対象レコードを取得

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; let GET\_param2 = {

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; app: 906,

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Query:

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ‘record\_id = "’ +

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; UUrecID +

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ‘" &nbsp;order by record\_id desc limit 100 offset 0’,

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; fields: [“$id”, “テーブル”],

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; };

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return kintone

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; .api(

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; kintone.api.url(“/k/v1/records”, true),

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; “GET”,

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; GET\_param2

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; .then(function (resp2) {

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; console.log(resp2); //ここまでOK

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; let resp\_2 = resp2.records;

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; for (let k = 0; k \< resp\_2.length; k++) {

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; let existing\_subtable = resp\_2[0][“テーブル”].value;

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; let subtable = []; // 最終的にPUTするサブテーブル

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // 既存のサブテーブルを抽出

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; for (let l = 0; l \< existing\_subtable.length; l++) {

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; subtable.push(existing\_subtable[k]);

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; let body = {

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; id: “15970462”,

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; value: [

&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; 文字列\_\_1行\_\_5: {

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; value: tagName,

&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; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; };

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; console.log(body);

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; subtable = subtable.concat(body); // 既存と追加分のサブテーブルを結合

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; console.log(subtable);

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; let put\_record = {}; // レコード更新用オブジェクト

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; put\_record[“テーブル”] = {

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; value: subtable,

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; };

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; let put\_Params = {

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; app: 906,

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; id: resp\_2[k].$id.value,

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; record: put\_record,

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; };

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return kintone

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; .api(

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; kintone.api.url(“/k/v1/records”, true),

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; “PUT”,

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; put\_Params

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; .then(function () {

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; alert(“UUアプリへの登録が完了しました!”);

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; [//location.reload](https://location.reload)();

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; })

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; .catch(function (error) {

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; alert(

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; “UUアプリへの登録でエラーが発生しました。” +

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; error.message

&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; console.log(error);

&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; &nbsp; &nbsp; &nbsp; });

&nbsp; &nbsp; &nbsp; }

&nbsp; &nbsp; });

&nbsp; }

})();

---

<div class="post-metadata">

**Author:** ![Legacy\_Account1517](https://avatars.discourse-cdn.com/v4/letter/l/4bbf92/32.png) [@Legacy\_Account1517](https://community.cybozu.dev/u/Legacy_Account1517)\
**Post date:** [2022 年 3 月 31 日午前 1:27 UTC](https://community.cybozu.dev/t/topic/5845/2 "2022-03-31T01:27:10Z")

</div>

エラー自体は、レコードの一括更新API で、records が指定されていないからです。

ただ一覧のレコード数ループ内で、ヘッダ部のボタン処理があったり、レコードの一括更新APIで 1レコードのリクエストを出したりと、全体的にちぐはぐな感じです。

処理の流れを整理して、書き直してみてください。

---

<div class="post-metadata">

**Author:** ![Legacy\_Account374](https://avatars.discourse-cdn.com/v4/letter/l/8e7dd6/32.png) [@Legacy\_Account374](https://community.cybozu.dev/u/Legacy_Account374)\
**Post date:** [2022 年 4 月 1 日午前 8:34 UTC](https://community.cybozu.dev/t/topic/5845/3 "2022-04-01T08:34:46Z")

</div>

[rex0220](https://community.cybozu.dev/hc/ja/profiles/435994154-rex0220)様

お世話になります。アドバイスありがとうございます。

様々ちぐはぐになっておりました。修正したコードを記載いたします。

しかし、recordsの指定についてよく理解できておらずput\_Params内のrecordsを指定するようなイメージでしょうか。

各種修正をしながら、実行しておりますがやはり400のエラーが返されてしまいます。

初心者な質問で大変申し訳ございませんが、何卒よろしくお願い申し上げます。

(function() {  
&nbsp; “use strict”;

&nbsp; let user = kintone.getLoginUser().code;  
&nbsp; console.log(user);  
&nbsp; if(user == “152006”){  
&nbsp; &nbsp; kintone.events.on(‘app.record.index.show’, function(event) {  
&nbsp; &nbsp; &nbsp; &nbsp; let records = event.records;

&nbsp; &nbsp; &nbsp;&nbsp;  
&nbsp; &nbsp; let oldButton = document.getElementById(‘UUアプリへ一括更新’);  
&nbsp; &nbsp; let button = document.createElement(‘button’);

&nbsp; &nbsp; if(oldButton !== null) oldButton.parentNode.removeChild(oldButton);

&nbsp; &nbsp; button.innerHTML = ‘UUアプリ更新’;  
&nbsp; &nbsp; button.id = ‘UUアプリ更新’;  
&nbsp; &nbsp; kintone.app.getHeaderMenuSpaceElement().appendChild(button);  
&nbsp; &nbsp; button.addEventListener(‘click’, function() {

&nbsp; &nbsp; for (var m = 0; m \< records.length; m++) {  
&nbsp; &nbsp; &nbsp; &nbsp; let tagName = records[m][‘文字列\_\_1行\_\_1’].value;

&nbsp; &nbsp; &nbsp; &nbsp; let GET\_param = {  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ‘app’: 917,  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ‘Query’:kintone.app.getQuery(),  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ‘fields’: [‘$id’, ‘文字列\_\_1行\_\_1’,‘UURecordID’]

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; };

&nbsp; &nbsp; return kintone.api(kintone.api.url(‘/k/v1/records’, true), ‘GET’, GET\_param).then(function(resp) {  
&nbsp; &nbsp; &nbsp; &nbsp; let resp1 = resp.records;  
&nbsp; &nbsp; &nbsp; &nbsp; console.log(resp);

&nbsp; &nbsp; &nbsp; &nbsp; for (let j = 0; j \< resp1.length; j++ ) {  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; let UUrecID = resp1[j].UURecordID.value;  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; console.log(UUrecID);  
&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;  
&nbsp; &nbsp; &nbsp; &nbsp; //UUアプリに対して対象レコードを取得  
&nbsp; &nbsp; &nbsp; &nbsp; let GET\_param2 = {  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ‘app’: 906,  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ‘Query’:‘record\_id = "’ + UUrecID + ‘" &nbsp;order by record\_id desc limit 100 offset 0’,  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ‘fields’: [‘$id’, ‘テーブル’]

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;  
&nbsp; &nbsp; return kintone.api(kintone.api.url(‘/k/v1/records’, true), ‘GET’, GET\_param2).then(function(resp2) {  
&nbsp; &nbsp; &nbsp; &nbsp; console.log(resp2);//ここまでOK  
&nbsp; &nbsp; &nbsp; &nbsp; let resp\_2 = resp2.records;  
&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;  
&nbsp; &nbsp; &nbsp; &nbsp; for (let k = 0; k \< resp\_2.length; k++ ) {  
&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; let existing\_subtable = resp\_2[k][‘テーブル’].value;  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; //let subtable\_id = resp\_2[k][‘テーブル’].value.id;  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; [//console.log](https://console.log)(subtable\_id);  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; let subtable = []; // 最終的にPUTするサブテーブル  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; //let appended\_subtable = []; // 追加したいサブテーブル  
&nbsp; &nbsp; &nbsp; &nbsp;  
&nbsp; &nbsp; &nbsp; &nbsp; // 既存のサブテーブルを抽出  
&nbsp; &nbsp; &nbsp; &nbsp; for (let l = 0; l \< existing\_subtable.length; l++) {  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; subtable.push(existing\_subtable[k]);  
&nbsp; &nbsp; &nbsp; &nbsp; }  
&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; let body = {  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ‘app’: 906,  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ‘id’:resp\_2[k].$id.value ,  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ‘records’: {  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; “テーブル” : {  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; “value” : [  
&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; ‘value’: {  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; “id”: “0”,  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; “文字列\_\_1行\_\_5”:{  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ‘value’ : tagName  
&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; &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; &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; console.log(body);  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; subtable = subtable.concat(body); // 既存と追加分のサブテーブルを結合  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; console.log(subtable)  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; let put\_record = {}; // レコード更新用オブジェクト  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; put\_record[“テーブル”] = {  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; value: subtable  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; };  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; let put\_Params = {  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ‘app’: 906,  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ‘id’:resp\_2[k].$id.value ,  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ‘records’: {  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; “テーブル” : {  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; “value” : put\_record  
&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; &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; return kintone.api(kintone.api.url(‘/k/v1/records’, true), ‘PUT’, put\_Params).then(function(resp3) {  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; alert(‘UUアプリへの登録が完了しました!’);  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; [//location.reload](https://location.reload)();  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;  
&nbsp; &nbsp; &nbsp; &nbsp; }).catch(function(error) {  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; alert(‘UUアプリへの登録でエラーが発生しました。’ + error.message);  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; console.log(error);

&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;

});

}

})();

---

<div class="post-metadata">

**Author:** ![Legacy\_Account1517](https://avatars.discourse-cdn.com/v4/letter/l/4bbf92/32.png) [@Legacy\_Account1517](https://community.cybozu.dev/u/Legacy_Account1517)\
**Post date:** [2022 年 4 月 1 日午後 12:28 UTC](https://community.cybozu.dev/t/topic/5845/4 "2022-04-01T12:28:49Z")

</div>

いくつか気になる点があります。

・一覧のレコード毎に、さらに一覧のレコード取得 API を発行してるので、むちゃくちゃ処理回数が増えます。  
このループ処理は不要です。

for (var m = 0; m \< records.length; m++) {

・for ループ内で非同期処理の REST API を発行すると、REST API の終了を待たずにループが進みます。  
for ループではなく、再帰呼び出しでループしましょう。

・処理対象のレコード数が不明ですが、REST API で処理できるレコード数に制限があります。  
100 レコード以上の場合は、全レコードを処理するコードが必要です。  
kintone JavaScript Client のようなライブラリを使うと処理を簡単に記述できると思います。

・フィールドコードが規定値のままで、コードをみても意味が分からない  
内容にあったフィールドコードにしましょう。

・アプリ構成や関連情報がよくわかっていないので、要望どおりかわかりませんが、ざっとコードを書いてみました。

```
(function () {

    'use strict';

    let user = kintone.getLoginUser().code;

    console.log(user);

    if (user !== "152006") return;

    const UUAPPID = 906;

    kintone.events.on('app.record.index.show', function (event) {

        let oldButton = document.getElementById('UUアプリへ一括更新');

        if (oldButton !== null) oldButton.parentNode.removeChild(oldButton);

        let button = document.createElement('button');

        button.innerHTML = 'UUアプリ更新';

        button.id = 'UUアプリ更新';

        kintone.app.getHeaderMenuSpaceElement().appendChild(button);

        button.addEventListener('click', function () {

            UUAppAllProc(event.appId);

        });

    });

    // UUアプリ更新

    function UUAppAllProc(appId) {

        // 一覧レコード取得

        const query = kintone.app.getQueryCondition();

        const fields = ['$id', '文字列 __1行__ 1', 'UURecordID'];

        fetchRecords(appId, query, fields).then(function (records) {

            console.log('view Records', records);

            return UUAppProc(records, 0);

        }).then(function(resp) {

            alert('UUアプリへの登録が完了しました!');

        }).catch(function(error){

            alert('UUアプリへの登録でエラーが発生しました。' + error.message);

        });

    }

    // UUアプリレコード処理

    function UUAppProc(records, pos) {

        console.log('UUAppProc', pos);

        if (pos >= records.length) return kintone.Promise.resolve(0);

        return UUAppUpdate(records[pos]).then(function (resp) {

            return UUAppProc(records, pos + 1);

        });

    }

    // UUアプリ更新処理

    function UUAppUpdate(record) {

        const tagName = record['文字列 __1行__ 1'].value;

        const UUrecID = record.UURecordID.value;

        const query = 'record_id = "' + UUrecID + '"';

        const fields = ['$id', 'テーブル'];

        return fetchRecords(UUAPPID, query, fields).then(function (records) {

            console.log('UUAPPID Records', records);

            let put_records = [];

            records.forEach(function (rec) {

                let subtable = rec['テーブル'].value.map(function(row) { return { id: row.id } });

                subtable.push({ value: { '文字列 __1行__ 5': { value: tagName } }} );

                put_records.push({

                    id: rec.$id.value,

                    record: { 'テーブル': { value: subtable } }

                });

            });

            return updateRecords(UUAPPID, put_records);

        });

    }

    // レコード取得処理

    function fetchRecords(appId, opt_query, opt_fields, opt_limit, opt_startid, opt_records) {

        const startid = opt_startid || 0;

        let query = opt_query || '';

        query = query ? '( ' + query + ' ) and $id > ' + startid : '$id > ' + startid;

        const limit = opt_limit || 500;

        let allRecords = opt_records || [];

        let params = { app: appId, query: query + ' order by $id asc limit ' + limit };

        if (opt_fields) {

            let fields = opt_fields;

            if (fields.indexOf('$id') < 0) fields.push('$id');

            params.fields = fields;

        }

        return kintone.api(kintone.api.url('/k/v1/records', true), 'GET', params).then(function (resp) {

            allRecords = allRecords.concat(resp.records);

            if (resp.records.length === limit) {

                const next_startid = resp.records.slice(-1)[0]['$id'].value;

                return fetchRecords(appId, opt_query, opt_fields, limit, next_startid, allRecords);

            }

            return allRecords;

        });

    }

    // レコード更新処理

    function updateRecords(appId, opt_records) {

        var records = opt_records.slice(0, 100);

        var next = opt_records.slice(100);

        if (records.length === 0) return kintone.Promise.resolve(0);

        var params = { app: appId, records: records };

        return kintone.api(kintone.api.url('/k/v1/records', true), 'PUT', params).then(function (resp) {

            console.log('update records', resp);

            if (next.length === 0) {

                return 0;

            }

            return updateRecords(appId, next);

        });

    }

})();

```

---

<div class="post-metadata">

**Author:** ![Legacy\_Account374](https://avatars.discourse-cdn.com/v4/letter/l/8e7dd6/32.png) [@Legacy\_Account374](https://community.cybozu.dev/u/Legacy_Account374)\
**Post date:** [2022 年 4 月 3 日午後 11:46 UTC](https://community.cybozu.dev/t/topic/5845/5 "2022-04-03T23:46:59Z")

</div>

[rex0220](https://community.cybozu.dev/hc/ja/profiles/435994154-rex0220)様

お世話になります。

詳細にご教示いただきまして誠にありがとうございます。いただきましたコードで無事、動きが確認できました！

いただきましたコードと自分が書いてみたコードを比べてみて一つずつ勉強していければと思います。

この度は大変ありがとうございました！