"use strict";(self.webpackChunknewoaks_help=self.webpackChunknewoaks_help||[]).push([[6288],{4543:(e,t,s)=>{s.r(t),s.d(t,{assets:()=>l,contentTitle:()=>h,default:()=>p,frontMatter:()=>d,metadata:()=>n,toc:()=>c});const n=JSON.parse('{"id":"api/chatbot/knowledge/source/googlesheet/update-googlesheet-data","title":"Update Google Sheet Data","description":"The  API enables you to update google sheet data for a specified chatbot by sending a POST request to the /chat/Chatbot/UpdateGoogleSheetData endpoint.","source":"@site/developer/api/002.chatbot/002.knowledge/002.source/002.googlesheet/103.update-googlesheet-data.md","sourceDirName":"api/002.chatbot/002.knowledge/002.source/002.googlesheet","slug":"/api/chatbot/knowledge/source/googlesheet/update-googlesheet-data","permalink":"/guides/developer/api/chatbot/knowledge/source/googlesheet/update-googlesheet-data","draft":false,"unlisted":false,"tags":[],"version":"current","sidebarPosition":30,"frontMatter":{"sidebar_position":30},"sidebar":"sidebar","previous":{"title":"Create Google Sheet Data","permalink":"/guides/developer/api/chatbot/knowledge/source/googlesheet/create-googlesheet-data"},"next":{"title":"Delete Google Sheet Data","permalink":"/guides/developer/api/chatbot/knowledge/source/googlesheet/delete-googlesheet-data"}}');var o=s(4848),a=s(8453),r=s(767),i=s(8175);const d={sidebar_position:30},h="Update Google Sheet Data",l={},c=[{value:"Endpoint",id:"endpoint",level:2},{value:"Request Headers",id:"request-headers",level:2},{value:"Request Body",id:"request-body",level:2},{value:"Example Request",id:"example-request",level:2},{value:"Response",id:"response",level:2},{value:"Error Handling",id:"error-handling",level:2}];function u(e){const t={blockquote:"blockquote",code:"code",h1:"h1",h2:"h2",header:"header",p:"p",strong:"strong",...(0,a.R)(),...e.components};return(0,o.jsxs)(o.Fragment,{children:[(0,o.jsx)(t.header,{children:(0,o.jsx)(t.h1,{id:"update-google-sheet-data",children:"Update Google Sheet Data"})}),"\n",(0,o.jsxs)(t.p,{children:["The ",(0,o.jsx)(i.A,{})," API enables you to update google sheet data for a specified chatbot by sending a ",(0,o.jsx)(t.code,{children:"POST"})," request to the ",(0,o.jsx)(t.code,{children:"/chat/Chatbot/UpdateGoogleSheetData"})," endpoint."]}),"\n",(0,o.jsxs)(t.blockquote,{children:["\n",(0,o.jsx)(t.p,{children:(0,o.jsx)(t.strong,{children:"\u26a0\ufe0f Attention: This API is only compatible with regular chatbots and is not yet compatible with template-based chatbots."})}),"\n"]}),"\n",(0,o.jsx)(t.h2,{id:"endpoint",children:"Endpoint"}),"\n",(0,o.jsx)(r.TM,{path:"/chat/Chatbot/UpdateGoogleSheetData"}),"\n",(0,o.jsx)(t.h2,{id:"request-headers",children:"Request Headers"}),"\n",(0,o.jsx)(r.iW,{}),"\n",(0,o.jsx)(t.h2,{id:"request-body",children:"Request Body"}),"\n",(0,o.jsx)(r.VQ,{requestBody:{serialNumber:"3254a9d0424c4806b9ea3d0763xxxxxx",rows:[{ID:1,Data:{url:"XXXXX",name:"apple",productname:"iphone 16 pro max",price:111}},{ID:2,Data:{url:"XXXXX",name:"xiaomi",productname:"xiaomi 16",price:111}}]},requestBodyParams:{serialNumber:"string, required - The unique identifier (ID) of the chatbot",rows:"array of object, required - List of data rows to update, field ID is required for update.\n // Each ID represents the ID of the data row that needs to be updated, and Data is a dynamic object that users can customize according to their needs."}}),"\n",(0,o.jsx)(t.h2,{id:"example-request",children:"Example Request"}),"\n",(0,o.jsx)(r.r3,{path:"/chat/Chatbot/GetSource",requestBody:{serialNumber:"3254a9d0424c4806b9ea3d0763xxxxxx",rows:[{ID:1,Data:{url:"XXXXX",name:"apple",productname:"iphone 16 pro max",price:111}},{ID:2,Data:{url:"XXXXX",name:"xiaomi",productname:"xiaomi 16",price:111}}]}}),"\n",(0,o.jsx)(t.h2,{id:"response",children:"Response"}),"\n",(0,o.jsx)(r.zV,{responseExample:{Data:[1,2]},responseComments:{Data:"array of integer - Represents the data row ids that were updated."}}),"\n",(0,o.jsx)(t.h2,{id:"error-handling",children:"Error Handling"}),"\n",(0,o.jsx)(r.NH,{})]})}function p(e={}){const{wrapper:t}={...(0,a.R)(),...e.components};return t?(0,o.jsx)(t,{...e,children:(0,o.jsx)(u,{...e})}):u(e)}},767:(e,t,s)=>{s.d(t,{Ay:()=>g,NH:()=>p,TM:()=>d,VQ:()=>l,iW:()=>h,r3:()=>c,zV:()=>u});s(6540);var n=s(3532),o=s(8069),a=s(9303),r=s(4848);const i=function(e,t){void 0===t&&(t={});const s=JSON.stringify(e,null,2).split("\n"),n=[];return s.forEach((e=>{const s=e.match(/"([^"]+)":/);if(s&&t[s[1]]){const o=e.match(/^\s*/)?.[0]||"";n.push(`${o}// ${t[s[1]]}`)}n.push(e)})),n.join("\n")},d=e=>{let{path:t,method:s="POST"}=e;const o=(0,n.r)()(t)||`https://usapi.hottask.com${t}`;return(0,r.jsxs)(r.Fragment,{children:[(0,r.jsxs)("p",{children:[(0,r.jsx)("strong",{children:"Request URL:"})," ",o]}),(0,r.jsxs)("p",{children:[(0,r.jsx)("strong",{children:"Method:"})," ",s]})]})},h=e=>{let{headers:t={Authorization:"<Your-Secret-Key>","Content-Type":"application/json"},headersDescription:s={Authorization:"string, required - The secret key for authenticating the API request","Content-Type":"string, required - The content type of the request payload (must be application/json)"}}=e;return(0,r.jsxs)(r.Fragment,{children:[(0,r.jsx)("p",{children:"The API request must include the following headers:"}),(0,r.jsx)("ul",{children:Object.entries(t).map((e=>{let[t,n]=e;return(0,r.jsxs)("li",{children:[(0,r.jsxs)("code",{children:[t,": ",n]})," - ",s[t]]},t)}))})]})},l=e=>{let{requestBody:t,requestBodyParams:s,addCommentsToJson:n=i}=e;return(0,r.jsxs)(r.Fragment,{children:[(0,r.jsx)("p",{children:"The request body should contain the following parameters:"}),(0,r.jsx)(o.A,{language:"json",children:n(t,s)}),(0,r.jsx)("ul",{children:Object.entries(s).map((e=>{let[t,s]=e;return(0,r.jsxs)("li",{children:[(0,r.jsx)("code",{children:t})," - ",s]},t)}))})]})},c=e=>{let{method:t="POST",path:s,requestBody:i,headers:d={Authorization:"<Your-Secret-Key>","Content-Type":"application/json"}}=e;const h=(0,n.r)()(s),l="undefined"==typeof window?"usapi.hottask.com":new URL(h||`https://usapi.hottask.com${s}`).host,c={javascript:`const res = await fetch('${h||`https://usapi.hottask.com${s}`}', {\n  method: '${t}',\n  headers: ${JSON.stringify(d,null,2)},\n  body: JSON.stringify(${JSON.stringify(i,null,2)})\n});\n\nconst data = await res.json();\nconsole.log(data);`,python:`import requests\nimport json\n\nurl = '${h||`https://usapi.hottask.com${s}`}'\nheaders = ${JSON.stringify(d,null,4)}\ndata = ${JSON.stringify(i,null,2)}\n\nresponse = requests.${t.toLowerCase()}(url, headers=headers, json=data)\ndata = response.json()\nprint(data)`,bash:`curl '${h||`https://usapi.hottask.com${s}`}' \\\n  -X ${t} \\\n${Object.entries(d).map((e=>{let[t,s]=e;return`  -H '${t}: ${s}' \\`})).join("\n")}\n  -d '${JSON.stringify(i)}'`,http:`${t} ${s} HTTP/1.1\nHost: ${l}\n${Object.entries(d).map((e=>{let[t,s]=e;return`${t}: ${s}`})).join("\n")}\n\n${JSON.stringify(i,null,2)}`};return(0,r.jsxs)(r.Fragment,{children:[(0,r.jsx)(a.A,{as:"h3",children:"JavaScript (Fetch API)"}),(0,r.jsx)(o.A,{language:"javascript",children:c.javascript}),(0,r.jsx)(a.A,{as:"h3",children:"Python (Requests Library)"}),(0,r.jsx)(o.A,{language:"python",children:c.python}),(0,r.jsx)(a.A,{as:"h3",children:"cURL"}),(0,r.jsx)(o.A,{language:"bash",children:c.bash}),(0,r.jsx)(a.A,{as:"h3",children:"HTTP Request"}),(0,r.jsx)(o.A,{language:"http",children:c.http})]})},u=e=>{let{responseExample:t,responseComments:s,addCommentsToJson:n=i}=e;const a={...t,Version:"1.0.0",Success:!0,Code:200,Message:""},d={...s,Version:"string - API version",Success:"boolean - Operation success status",Code:"integer - HTTP status code",Message:"string - Error message if any"};return(0,r.jsxs)(r.Fragment,{children:[(0,r.jsx)("p",{children:"The API response will be a JSON object with the following structure:"}),(0,r.jsx)(o.A,{language:"json",children:n(a,d)})]})},p=e=>{let{errorHandling:t="If the request fails, you should:\n1. Check the HTTP status code for network-level errors\n2. Examine the `Code` and `Message` fields in the response for business-level errors\n3. The `Message` field will contain detailed error information"}=e;return(0,r.jsx)("div",{style:{whiteSpace:"pre-line"},children:t})};function g(e){let{title:t,path:s,method:o="POST",description:a="",requestBody:g={timeZone:"Asia/Shanghai",type:0},requestBodyDescription:m={timeZone:"The time zone of the chatbot. The standard time zone format: e.g., Asia/Shanghai or America/New_York.",type:"Create a generic chatbot with a fixed value of 0"},requestBodyComments:x={timeZone:"string, required",type:"integer, required"},responseExample:j={Data:"3254a9d0424c4806b9ea3d0763xxxxxx",Version:"1.0.0",Success:!0,Code:200,Message:""},responseComments:f={Data:"chatbot id"},headers:y={Authorization:"<Your-Secret-Key>","Content-Type":"application/json"},headersDescription:b={Authorization:"The secret key for authenticating the API request.","Content-Type":"The content type of the request payload."},errorHandling:w="If it's an HTTP network error, you should check the `HTTP status code`. If it's a business exception, you need to examine the `Code` and `Message` fields, which will provide the error details."}=e;const q=(0,n.r)()(s),k="undefined"==typeof window?"usapi.hottask.com":new URL(q||`https://usapi.hottask.com${s}`).host;JSON.stringify(y,null,2),i(g,x),JSON.stringify(y,null,4),i(g,x),o.toLowerCase(),Object.entries(y).map((e=>{let[t,s]=e;return`  -H '${t}: ${s}' \\`})).join("\n"),JSON.stringify(g),Object.entries(y).map((e=>{let[t,s]=e;return`${t}: ${s}`})).join("\n"),i(g,x);return(0,r.jsxs)(r.Fragment,{children:[(0,r.jsx)(d,{path:s,method:o}),(0,r.jsx)(h,{headers:y,headersDescription:b}),(0,r.jsx)(l,{requestBody:g,requestBodyParams:m,addCommentsToJson:i}),(0,r.jsx)(c,{method:o,path:s,requestBody:g,headers:y}),(0,r.jsx)(u,{responseExample:j,responseComments:f,addCommentsToJson:i}),(0,r.jsx)(p,{errorHandling:w})]})}},8175:(e,t,s)=>{s.d(t,{A:()=>a});s(6540);var n=s(5872),o=s(4848);function a(){let e=(0,n.K)()();return["newoaks.ai","www.newoaks.ai","eu.newoaks.ai"].includes(e)&&(e="NewOaks AI"),"appointify.ai"===e&&(e="Appointify AI"),(0,o.jsx)("code",{children:e})}},3532:(e,t,s)=>{function n(){return function(e){if("undefined"==typeof window)return"";const t=window.location.hostname;let s="";return s="www.newoaks.ai"==t||"newoaks.ai"==t?"https://usapi.hottask.com":"eu.newoaks.ai"==t?"https://euapi.hottask.com":`https://${t}`,e?`${s}${e.startsWith("/")?e:`/${e}`}`:s}}s.d(t,{r:()=>n})},5872:(e,t,s)=>{function n(){return function(){return"undefined"==typeof window?"":window.location.hostname}}s.d(t,{K:()=>n})}}]);