mirror of https://github.com/nocodb/nocodb
You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
1 lines
70 KiB
1 lines
70 KiB
"use strict";(self.webpackChunknoco_docs=self.webpackChunknoco_docs||[]).push([[3312],{3905:(t,a,e)=>{e.d(a,{Zo:()=>u,kt:()=>o});var n=e(67294);function l(t,a,e){return a in t?Object.defineProperty(t,a,{value:e,enumerable:!0,configurable:!0,writable:!0}):t[a]=e,t}function r(t,a){var e=Object.keys(t);if(Object.getOwnPropertySymbols){var n=Object.getOwnPropertySymbols(t);a&&(n=n.filter((function(a){return Object.getOwnPropertyDescriptor(t,a).enumerable}))),e.push.apply(e,n)}return e}function d(t){for(var a=1;a<arguments.length;a++){var e=null!=arguments[a]?arguments[a]:{};a%2?r(Object(e),!0).forEach((function(a){l(t,a,e[a])})):Object.getOwnPropertyDescriptors?Object.defineProperties(t,Object.getOwnPropertyDescriptors(e)):r(Object(e)).forEach((function(a){Object.defineProperty(t,a,Object.getOwnPropertyDescriptor(e,a))}))}return t}function p(t,a){if(null==t)return{};var e,n,l=function(t,a){if(null==t)return{};var e,n,l={},r=Object.keys(t);for(n=0;n<r.length;n++)e=r[n],a.indexOf(e)>=0||(l[e]=t[e]);return l}(t,a);if(Object.getOwnPropertySymbols){var r=Object.getOwnPropertySymbols(t);for(n=0;n<r.length;n++)e=r[n],a.indexOf(e)>=0||Object.prototype.propertyIsEnumerable.call(t,e)&&(l[e]=t[e])}return l}var i=n.createContext({}),m=function(t){var a=n.useContext(i),e=a;return t&&(e="function"==typeof t?t(a):d(d({},a),t)),e},u=function(t){var a=m(t.components);return n.createElement(i.Provider,{value:a},t.children)},N="mdxType",k={inlineCode:"code",wrapper:function(t){var a=t.children;return n.createElement(n.Fragment,{},a)}},g=n.forwardRef((function(t,a){var e=t.components,l=t.mdxType,r=t.originalType,i=t.parentName,u=p(t,["components","mdxType","originalType","parentName"]),N=m(e),g=l,o=N["".concat(i,".").concat(g)]||N[g]||k[g]||r;return e?n.createElement(o,d(d({ref:a},u),{},{components:e})):n.createElement(o,d({ref:a},u))}));function o(t,a){var e=arguments,l=a&&a.mdxType;if("string"==typeof t||l){var r=e.length,d=new Array(r);d[0]=g;var p={};for(var i in a)hasOwnProperty.call(a,i)&&(p[i]=a[i]);p.originalType=t,p[N]="string"==typeof t?t:l,d[1]=p;for(var m=2;m<r;m++)d[m]=e[m];return n.createElement.apply(null,d)}return n.createElement.apply(null,e)}g.displayName="MDXCreateElement"},60707:(t,a,e)=>{e.r(a),e.d(a,{assets:()=>i,contentTitle:()=>d,default:()=>k,frontMatter:()=>r,metadata:()=>p,toc:()=>m});var n=e(87462),l=(e(67294),e(3905));const r={title:"REST APIs",description:"NocoDB REST API Overview"},d=void 0,p={unversionedId:"developer-resources/rest-apis",id:"version-0.109.7/developer-resources/rest-apis",title:"REST APIs",description:"NocoDB REST API Overview",source:"@site/versioned_docs/version-0.109.7/040.developer-resources/020.rest-apis.md",sourceDirName:"040.developer-resources",slug:"/developer-resources/rest-apis",permalink:"/0.109.7/developer-resources/rest-apis",draft:!1,editUrl:"https://github.com/nocodb/nocodb/tree/develop/packages/noco-docs/docs/versioned_docs/version-0.109.7/040.developer-resources/020.rest-apis.md",tags:[],version:"0.109.7",sidebarPosition:20,frontMatter:{title:"REST APIs",description:"NocoDB REST API Overview"},sidebar:"tutorialSidebar",previous:{title:"Accessing APIs",permalink:"/0.109.7/developer-resources/accessing-apis"},next:{title:"NocoDB SDK",permalink:"/0.109.7/developer-resources/sdk"}},i={},m=[{value:"API Overview",id:"api-overview",level:2},{value:"Auth APIs",id:"auth-apis",level:3},{value:"Public APIs",id:"public-apis",level:3},{value:"Data APIs",id:"data-apis",level:3},{value:"Meta APIs",id:"meta-apis",level:3},{value:"Query params",id:"query-params",level:2},{value:"Comparison Operators",id:"comparison-operators",level:2},{value:"Comparison Sub-Operators",id:"comparison-sub-operators",level:2},{value:"Logical Operators",id:"logical-operators",level:2}],u={toc:m},N="wrapper";function k(t){let{components:a,...e}=t;return(0,l.kt)(N,(0,n.Z)({},u,e,{components:a,mdxType:"MDXLayout"}),(0,l.kt)("p",null,"Once you've created the schemas, you can manipulate the data or invoke actions using the REST APIs. We provide several types of APIs for different usages as below."),(0,l.kt)("h2",{id:"api-overview"},"API Overview"),(0,l.kt)("p",null,"Here's the overview of all APIs. For the details, please check out ",(0,l.kt)("a",{href:"https://all-apis.nocodb.com/",target:"_blank"},"NocoDB API Documentation"),". "),(0,l.kt)("p",null,"You may also interact with the API's resources via ",(0,l.kt)("a",{href:"/0.109.7/developer-resources/accessing-apis#swagger-ui",target:"_blank"},"Swagger UI"),"."),(0,l.kt)("admonition",{type:"note"},(0,l.kt)("p",{parentName:"admonition"},"Currently, the default value for {orgs} is ",(0,l.kt)("b",null,"noco"),". Users will be able to change it in the future release.")),(0,l.kt)("h3",{id:"auth-apis"},"Auth APIs"),(0,l.kt)("table",null,(0,l.kt)("thead",{parentName:"table"},(0,l.kt)("tr",{parentName:"thead"},(0,l.kt)("th",{parentName:"tr",align:null},"Category"),(0,l.kt)("th",{parentName:"tr",align:null},"Method"),(0,l.kt)("th",{parentName:"tr",align:null},"Tag"),(0,l.kt)("th",{parentName:"tr",align:null},"Function Name"),(0,l.kt)("th",{parentName:"tr",align:null},"Path"))),(0,l.kt)("tbody",{parentName:"table"},(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Auth"),(0,l.kt)("td",{parentName:"tr",align:null},"Post"),(0,l.kt)("td",{parentName:"tr",align:null},"auth"),(0,l.kt)("td",{parentName:"tr",align:null},"signup"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/auth/user/signup")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Auth"),(0,l.kt)("td",{parentName:"tr",align:null},"Post"),(0,l.kt)("td",{parentName:"tr",align:null},"auth"),(0,l.kt)("td",{parentName:"tr",align:null},"signin"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/auth/user/signin")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Auth"),(0,l.kt)("td",{parentName:"tr",align:null},"Get"),(0,l.kt)("td",{parentName:"tr",align:null},"auth"),(0,l.kt)("td",{parentName:"tr",align:null},"me"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/auth/user/me")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Auth"),(0,l.kt)("td",{parentName:"tr",align:null},"Post"),(0,l.kt)("td",{parentName:"tr",align:null},"auth"),(0,l.kt)("td",{parentName:"tr",align:null},"passwordForgot"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/auth/password/forgot")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Auth"),(0,l.kt)("td",{parentName:"tr",align:null},"Post"),(0,l.kt)("td",{parentName:"tr",align:null},"auth"),(0,l.kt)("td",{parentName:"tr",align:null},"passwordChange"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/auth/password/change")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Auth"),(0,l.kt)("td",{parentName:"tr",align:null},"Post"),(0,l.kt)("td",{parentName:"tr",align:null},"auth"),(0,l.kt)("td",{parentName:"tr",align:null},"passwordReset"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/auth/password/reset/{token}")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Auth"),(0,l.kt)("td",{parentName:"tr",align:null},"Post"),(0,l.kt)("td",{parentName:"tr",align:null},"auth"),(0,l.kt)("td",{parentName:"tr",align:null},"tokenRefresh"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/auth/token/refresh")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Auth"),(0,l.kt)("td",{parentName:"tr",align:null},"Post"),(0,l.kt)("td",{parentName:"tr",align:null},"auth"),(0,l.kt)("td",{parentName:"tr",align:null},"passwordResetTokenValidate"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/auth/token/validate/{token}")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Auth"),(0,l.kt)("td",{parentName:"tr",align:null},"Post"),(0,l.kt)("td",{parentName:"tr",align:null},"auth"),(0,l.kt)("td",{parentName:"tr",align:null},"emailValidate"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/auth/email/validate/{email}")))),(0,l.kt)("h3",{id:"public-apis"},"Public APIs"),(0,l.kt)("table",null,(0,l.kt)("thead",{parentName:"table"},(0,l.kt)("tr",{parentName:"thead"},(0,l.kt)("th",{parentName:"tr",align:null},"Category"),(0,l.kt)("th",{parentName:"tr",align:null},"Method"),(0,l.kt)("th",{parentName:"tr",align:null},"Tag"),(0,l.kt)("th",{parentName:"tr",align:null},"Function Name"),(0,l.kt)("th",{parentName:"tr",align:null},"Path"))),(0,l.kt)("tbody",{parentName:"table"},(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Public"),(0,l.kt)("td",{parentName:"tr",align:null},"Get"),(0,l.kt)("td",{parentName:"tr",align:null},"public"),(0,l.kt)("td",{parentName:"tr",align:null},"sharedBaseGet"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/public/shared-base/{sharedBaseUuid}/meta")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Public"),(0,l.kt)("td",{parentName:"tr",align:null},"Post"),(0,l.kt)("td",{parentName:"tr",align:null},"public"),(0,l.kt)("td",{parentName:"tr",align:null},"dataList"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/public/shared-view/{sharedViewUuid}/rows")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Public"),(0,l.kt)("td",{parentName:"tr",align:null},"Get"),(0,l.kt)("td",{parentName:"tr",align:null},"public"),(0,l.kt)("td",{parentName:"tr",align:null},"dataNestedList"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/public/shared-view/{sharedViewUuid}/rows/{rowId}/{relationType}/{columnName}")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Public"),(0,l.kt)("td",{parentName:"tr",align:null},"Post"),(0,l.kt)("td",{parentName:"tr",align:null},"public"),(0,l.kt)("td",{parentName:"tr",align:null},"dataCreate"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/public/shared-view/{sharedViewUuid}/rows")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Public"),(0,l.kt)("td",{parentName:"tr",align:null},"Get"),(0,l.kt)("td",{parentName:"tr",align:null},"public"),(0,l.kt)("td",{parentName:"tr",align:null},"csvExport"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/public/shared-view/{sharedViewUuid}/rows/export/{type}")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Public"),(0,l.kt)("td",{parentName:"tr",align:null},"Get"),(0,l.kt)("td",{parentName:"tr",align:null},"public"),(0,l.kt)("td",{parentName:"tr",align:null},"dataRelationList"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/public/shared-view/{sharedViewUuid}/nested/{columnName}")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Public"),(0,l.kt)("td",{parentName:"tr",align:null},"Get"),(0,l.kt)("td",{parentName:"tr",align:null},"public"),(0,l.kt)("td",{parentName:"tr",align:null},"sharedViewMetaGet"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/public/shared-view/{sharedViewUuid}/meta")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Public"),(0,l.kt)("td",{parentName:"tr",align:null},"Get"),(0,l.kt)("td",{parentName:"tr",align:null},"public"),(0,l.kt)("td",{parentName:"tr",align:null},"groupedDataList"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/public/shared-view/{sharedViewUuid}/group/{columnId}")))),(0,l.kt)("h3",{id:"data-apis"},"Data APIs"),(0,l.kt)("table",null,(0,l.kt)("thead",{parentName:"table"},(0,l.kt)("tr",{parentName:"thead"},(0,l.kt)("th",{parentName:"tr",align:null},"Category"),(0,l.kt)("th",{parentName:"tr",align:null},"Method"),(0,l.kt)("th",{parentName:"tr",align:null},"Tag"),(0,l.kt)("th",{parentName:"tr",align:null},"Function Name"),(0,l.kt)("th",{parentName:"tr",align:null},"Path"))),(0,l.kt)("tbody",{parentName:"table"},(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Data"),(0,l.kt)("td",{parentName:"tr",align:null},"Delete"),(0,l.kt)("td",{parentName:"tr",align:null},"dbTableRow"),(0,l.kt)("td",{parentName:"tr",align:null},"bulkDelete"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/data/bulk/{orgs}/{projectName}/{tableName}/")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Data"),(0,l.kt)("td",{parentName:"tr",align:null},"Post"),(0,l.kt)("td",{parentName:"tr",align:null},"dbTableRow"),(0,l.kt)("td",{parentName:"tr",align:null},"bulkCreate"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/data/bulk/{orgs}/{projectName}/{tableName}/")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Data"),(0,l.kt)("td",{parentName:"tr",align:null},"Patch"),(0,l.kt)("td",{parentName:"tr",align:null},"dbTableRow"),(0,l.kt)("td",{parentName:"tr",align:null},"bulkUpdate"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/data/bulk/{orgs}/{projectName}/{tableName}/")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Data"),(0,l.kt)("td",{parentName:"tr",align:null},"Patch"),(0,l.kt)("td",{parentName:"tr",align:null},"dbTableRow"),(0,l.kt)("td",{parentName:"tr",align:null},"bulkUpdateAll"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/data/bulk/{orgs}/{projectName}/{tableName}/all")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Data"),(0,l.kt)("td",{parentName:"tr",align:null},"Delete"),(0,l.kt)("td",{parentName:"tr",align:null},"dbTableRow"),(0,l.kt)("td",{parentName:"tr",align:null},"bulkDeleteAll"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/data/bulk/{orgs}/{projectName}/{tableName}/all")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Data"),(0,l.kt)("td",{parentName:"tr",align:null},"Get"),(0,l.kt)("td",{parentName:"tr",align:null},"dbTableRow"),(0,l.kt)("td",{parentName:"tr",align:null},"list"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/data/{orgs}/{projectName}/{tableName}")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Data"),(0,l.kt)("td",{parentName:"tr",align:null},"Get"),(0,l.kt)("td",{parentName:"tr",align:null},"dbTableRow"),(0,l.kt)("td",{parentName:"tr",align:null},"findOne"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/data/{orgs}/{projectName}/{tableName}/find-one")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Data"),(0,l.kt)("td",{parentName:"tr",align:null},"Get"),(0,l.kt)("td",{parentName:"tr",align:null},"dbTableRow"),(0,l.kt)("td",{parentName:"tr",align:null},"groupBy"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/data/{orgs}/{projectName}/{tableName}/groupby")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Data"),(0,l.kt)("td",{parentName:"tr",align:null},"Get"),(0,l.kt)("td",{parentName:"tr",align:null},"dbTableRow"),(0,l.kt)("td",{parentName:"tr",align:null},"exist"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/data/{orgs}/{projectName}/{tableName}/{rowId}/exist")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Data"),(0,l.kt)("td",{parentName:"tr",align:null},"Post"),(0,l.kt)("td",{parentName:"tr",align:null},"dbTableRow"),(0,l.kt)("td",{parentName:"tr",align:null},"create"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/data/{orgs}/{projectName}/{tableName}")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Data"),(0,l.kt)("td",{parentName:"tr",align:null},"Get"),(0,l.kt)("td",{parentName:"tr",align:null},"dbTableRow"),(0,l.kt)("td",{parentName:"tr",align:null},"read"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/data/{orgs}/{projectName}/{tableName}/{rowId}")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Data"),(0,l.kt)("td",{parentName:"tr",align:null},"Patch"),(0,l.kt)("td",{parentName:"tr",align:null},"dbTableRow"),(0,l.kt)("td",{parentName:"tr",align:null},"update"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/data/{orgs}/{projectName}/{tableName}/{rowId}")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Data"),(0,l.kt)("td",{parentName:"tr",align:null},"Delete"),(0,l.kt)("td",{parentName:"tr",align:null},"dbTableRow"),(0,l.kt)("td",{parentName:"tr",align:null},"delete"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/data/{orgs}/{projectName}/{tableName}/{rowId}")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Data"),(0,l.kt)("td",{parentName:"tr",align:null},"Get"),(0,l.kt)("td",{parentName:"tr",align:null},"dbTableRow"),(0,l.kt)("td",{parentName:"tr",align:null},"count"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/data/{orgs}/{projectName}/{tableName}/count")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Data"),(0,l.kt)("td",{parentName:"tr",align:null},"Get"),(0,l.kt)("td",{parentName:"tr",align:null},"dbTableRow"),(0,l.kt)("td",{parentName:"tr",align:null},"groupedDataList"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/data/{orgs}/{projectName}/{tableName}/group/{columnId}")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Data"),(0,l.kt)("td",{parentName:"tr",align:null},"Get"),(0,l.kt)("td",{parentName:"tr",align:null},"dbViewRow"),(0,l.kt)("td",{parentName:"tr",align:null},"list"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/data/{orgs}/{projectName}/{tableName}/views/{viewName}")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Data"),(0,l.kt)("td",{parentName:"tr",align:null},"Get"),(0,l.kt)("td",{parentName:"tr",align:null},"dbViewRow"),(0,l.kt)("td",{parentName:"tr",align:null},"findOne"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/data/{orgs}/{projectName}/{tableName}/views/{viewName}/find-one")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Data"),(0,l.kt)("td",{parentName:"tr",align:null},"Get"),(0,l.kt)("td",{parentName:"tr",align:null},"dbViewRow"),(0,l.kt)("td",{parentName:"tr",align:null},"groupBy"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/data/{orgs}/{projectName}/{tableName}/views/{viewName}/groupby")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Data"),(0,l.kt)("td",{parentName:"tr",align:null},"Get"),(0,l.kt)("td",{parentName:"tr",align:null},"dbViewRow"),(0,l.kt)("td",{parentName:"tr",align:null},"exist"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/data/{orgs}/{projectName}/{tableName}/views/{viewName}/{rowId}/exist")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Data"),(0,l.kt)("td",{parentName:"tr",align:null},"Post"),(0,l.kt)("td",{parentName:"tr",align:null},"dbViewRow"),(0,l.kt)("td",{parentName:"tr",align:null},"create"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/data/{orgs}/{projectName}/{tableName}/views/{viewName}")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Data"),(0,l.kt)("td",{parentName:"tr",align:null},"Get"),(0,l.kt)("td",{parentName:"tr",align:null},"dbViewRow"),(0,l.kt)("td",{parentName:"tr",align:null},"read"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/data/{orgs}/{projectName}/{tableName}/views/{viewName}/{rowId}")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Data"),(0,l.kt)("td",{parentName:"tr",align:null},"Patch"),(0,l.kt)("td",{parentName:"tr",align:null},"dbViewRow"),(0,l.kt)("td",{parentName:"tr",align:null},"update"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/data/{orgs}/{projectName}/{tableName}/views/{viewName}/{rowId}")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Data"),(0,l.kt)("td",{parentName:"tr",align:null},"Delete"),(0,l.kt)("td",{parentName:"tr",align:null},"dbViewRow"),(0,l.kt)("td",{parentName:"tr",align:null},"delete"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/data/{orgs}/{projectName}/{tableName}/views/{viewName}/{rowId}")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Data"),(0,l.kt)("td",{parentName:"tr",align:null},"Get"),(0,l.kt)("td",{parentName:"tr",align:null},"dbViewRow"),(0,l.kt)("td",{parentName:"tr",align:null},"count"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/data/{orgs}/{projectName}/{tableName}/views/{viewName}/count")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Data"),(0,l.kt)("td",{parentName:"tr",align:null},"Get"),(0,l.kt)("td",{parentName:"tr",align:null},"dbViewRow"),(0,l.kt)("td",{parentName:"tr",align:null},"groupedDataList"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/data/{orgs}/{projectName}/{tableName}/views/{viewName}/group/{columnId}")))),(0,l.kt)("h3",{id:"meta-apis"},"Meta APIs"),(0,l.kt)("table",null,(0,l.kt)("thead",{parentName:"table"},(0,l.kt)("tr",{parentName:"thead"},(0,l.kt)("th",{parentName:"tr",align:null},"Category"),(0,l.kt)("th",{parentName:"tr",align:null},"Method"),(0,l.kt)("th",{parentName:"tr",align:null},"Tag"),(0,l.kt)("th",{parentName:"tr",align:null},"Function Name"),(0,l.kt)("th",{parentName:"tr",align:null},"Path"))),(0,l.kt)("tbody",{parentName:"table"},(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Get"),(0,l.kt)("td",{parentName:"tr",align:null},"apiToken"),(0,l.kt)("td",{parentName:"tr",align:null},"list"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/meta/projects/{projectId}/api-tokens")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Post"),(0,l.kt)("td",{parentName:"tr",align:null},"apiToken"),(0,l.kt)("td",{parentName:"tr",align:null},"create"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/meta/projects/{projectId}/api-tokens")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Delete"),(0,l.kt)("td",{parentName:"tr",align:null},"apiToken"),(0,l.kt)("td",{parentName:"tr",align:null},"delete"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/meta/projects/{projectId}/api-tokens/{token}")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Get"),(0,l.kt)("td",{parentName:"tr",align:null},"auth"),(0,l.kt)("td",{parentName:"tr",align:null},"projectUserList"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/meta/projects/{projectId}/users")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Post"),(0,l.kt)("td",{parentName:"tr",align:null},"auth"),(0,l.kt)("td",{parentName:"tr",align:null},"projectUserAdd"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/meta/projects/{projectId}/users")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Patch"),(0,l.kt)("td",{parentName:"tr",align:null},"auth"),(0,l.kt)("td",{parentName:"tr",align:null},"projectUserUpdate"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/meta/projects/{projectId}/users/{userId}")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Delete"),(0,l.kt)("td",{parentName:"tr",align:null},"auth"),(0,l.kt)("td",{parentName:"tr",align:null},"projectUserRemove"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/meta/projects/{projectId}/users/{userId}")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Post"),(0,l.kt)("td",{parentName:"tr",align:null},"auth"),(0,l.kt)("td",{parentName:"tr",align:null},"projectUserResendInvite"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/meta/projects/{projectId}/users/{userId}/resend-invite")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Post"),(0,l.kt)("td",{parentName:"tr",align:null},"dbTable"),(0,l.kt)("td",{parentName:"tr",align:null},"create"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/meta/projects/{projectId}/tables")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Get"),(0,l.kt)("td",{parentName:"tr",align:null},"dbTable"),(0,l.kt)("td",{parentName:"tr",align:null},"list"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/meta/projects/{projectId}/tables")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Post"),(0,l.kt)("td",{parentName:"tr",align:null},"dbTableColumn"),(0,l.kt)("td",{parentName:"tr",align:null},"create"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/meta/tables/{tableId}/columns")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Patch"),(0,l.kt)("td",{parentName:"tr",align:null},"dbTableColumn"),(0,l.kt)("td",{parentName:"tr",align:null},"update"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/meta/tables/{tableId}/columns/{columnId}")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Delete"),(0,l.kt)("td",{parentName:"tr",align:null},"dbTableColumn"),(0,l.kt)("td",{parentName:"tr",align:null},"delete"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/meta/tables/{tableId}/columns/{columnId}")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Post"),(0,l.kt)("td",{parentName:"tr",align:null},"dbTableColumn"),(0,l.kt)("td",{parentName:"tr",align:null},"primaryColumnSet"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/meta/tables/{tableId}/columns/{columnId}/primary")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Get"),(0,l.kt)("td",{parentName:"tr",align:null},"dbTableFilter"),(0,l.kt)("td",{parentName:"tr",align:null},"get"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/meta/filters/{filterId}")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Patch"),(0,l.kt)("td",{parentName:"tr",align:null},"dbTableFilter"),(0,l.kt)("td",{parentName:"tr",align:null},"update"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/meta/filters/{filterId}")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Delete"),(0,l.kt)("td",{parentName:"tr",align:null},"dbTableFilter"),(0,l.kt)("td",{parentName:"tr",align:null},"delete"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/meta/filters/{filterId}")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Get"),(0,l.kt)("td",{parentName:"tr",align:null},"dbTableFilter"),(0,l.kt)("td",{parentName:"tr",align:null},"read"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/meta/views/{viewId}/filters")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Post"),(0,l.kt)("td",{parentName:"tr",align:null},"dbTableFilter"),(0,l.kt)("td",{parentName:"tr",align:null},"create"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/meta/views/{viewId}/filters")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Get"),(0,l.kt)("td",{parentName:"tr",align:null},"dbTableFilter"),(0,l.kt)("td",{parentName:"tr",align:null},"get"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/meta/filters/{filterId}")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Patch"),(0,l.kt)("td",{parentName:"tr",align:null},"dbTableFilter"),(0,l.kt)("td",{parentName:"tr",align:null},"update"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/meta/filters/{filterId}")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Delete"),(0,l.kt)("td",{parentName:"tr",align:null},"dbTableFilter"),(0,l.kt)("td",{parentName:"tr",align:null},"delete"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/meta/filters/{filterId}")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Get"),(0,l.kt)("td",{parentName:"tr",align:null},"dbTableFilter"),(0,l.kt)("td",{parentName:"tr",align:null},"childrenRead"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/meta/filters/{filterGroupId}/children")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Get"),(0,l.kt)("td",{parentName:"tr",align:null},"dbTableSort"),(0,l.kt)("td",{parentName:"tr",align:null},"list"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/meta/views/{viewId}/sorts")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Post"),(0,l.kt)("td",{parentName:"tr",align:null},"dbTableSort"),(0,l.kt)("td",{parentName:"tr",align:null},"create"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/meta/views/{viewId}/sorts")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Get"),(0,l.kt)("td",{parentName:"tr",align:null},"dbTableSort"),(0,l.kt)("td",{parentName:"tr",align:null},"read"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/meta/sorts/{sortId}")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Patch"),(0,l.kt)("td",{parentName:"tr",align:null},"dbTableSort"),(0,l.kt)("td",{parentName:"tr",align:null},"update"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/meta/sorts/{sortId}")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Delete"),(0,l.kt)("td",{parentName:"tr",align:null},"dbTableSort"),(0,l.kt)("td",{parentName:"tr",align:null},"delete"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/meta/sorts/{sortId}/api/v1/db")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Patch"),(0,l.kt)("td",{parentName:"tr",align:null},"dbTableWebhook"),(0,l.kt)("td",{parentName:"tr",align:null},"update"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/meta/hooks/{hookId}")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Delete"),(0,l.kt)("td",{parentName:"tr",align:null},"dbTableWebhook"),(0,l.kt)("td",{parentName:"tr",align:null},"delete"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/meta/hooks/{hookId}")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Get"),(0,l.kt)("td",{parentName:"tr",align:null},"dbTableWebhook"),(0,l.kt)("td",{parentName:"tr",align:null},"list"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/meta/tables/{tableId}/hooks")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Post"),(0,l.kt)("td",{parentName:"tr",align:null},"dbTableWebhook"),(0,l.kt)("td",{parentName:"tr",align:null},"create"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/meta/tables/{tableId}/hooks")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Post"),(0,l.kt)("td",{parentName:"tr",align:null},"dbTableWebhook"),(0,l.kt)("td",{parentName:"tr",align:null},"test"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/meta/tables/{tableId}/hooks/test")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Get"),(0,l.kt)("td",{parentName:"tr",align:null},"dbTableWebhook"),(0,l.kt)("td",{parentName:"tr",align:null},"samplePayloadGet"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/meta/tables/{tableId}/hooks/samplePayload/{operation}")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Get"),(0,l.kt)("td",{parentName:"tr",align:null},"dbTableWebhookFilter"),(0,l.kt)("td",{parentName:"tr",align:null},"read"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/meta/hooks/{hookId}/filters")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Post"),(0,l.kt)("td",{parentName:"tr",align:null},"dbTableWebhookFilter"),(0,l.kt)("td",{parentName:"tr",align:null},"create"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/meta/hooks/{hookId}/filters")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Get"),(0,l.kt)("td",{parentName:"tr",align:null},"dbView"),(0,l.kt)("td",{parentName:"tr",align:null},"list"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/meta/tables/{tableId}/views")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Get"),(0,l.kt)("td",{parentName:"tr",align:null},"dbView"),(0,l.kt)("td",{parentName:"tr",align:null},"read"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/meta/tables/{tableId}")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Patch"),(0,l.kt)("td",{parentName:"tr",align:null},"dbView"),(0,l.kt)("td",{parentName:"tr",align:null},"update"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/meta/tables/{tableId}")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Delete"),(0,l.kt)("td",{parentName:"tr",align:null},"dbView"),(0,l.kt)("td",{parentName:"tr",align:null},"delete"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/meta/tables/{tableId}")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Post"),(0,l.kt)("td",{parentName:"tr",align:null},"dbView"),(0,l.kt)("td",{parentName:"tr",align:null},"reorder"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/meta/tables/{tableId}/reorder")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Post"),(0,l.kt)("td",{parentName:"tr",align:null},"dbView"),(0,l.kt)("td",{parentName:"tr",align:null},"formCreate"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/meta/tables/{tableId}/forms")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Patch"),(0,l.kt)("td",{parentName:"tr",align:null},"dbView"),(0,l.kt)("td",{parentName:"tr",align:null},"formUpdate"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/meta/forms/{formViewId}")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Get"),(0,l.kt)("td",{parentName:"tr",align:null},"dbView"),(0,l.kt)("td",{parentName:"tr",align:null},"formRead"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/meta/forms/{formViewId}")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Patch"),(0,l.kt)("td",{parentName:"tr",align:null},"dbView"),(0,l.kt)("td",{parentName:"tr",align:null},"formColumnUpdate"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/meta/form-columns/{formViewColumnId}")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Post"),(0,l.kt)("td",{parentName:"tr",align:null},"dbView"),(0,l.kt)("td",{parentName:"tr",align:null},"galleryCreate"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/meta/tables/{tableId}/galleries")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Patch"),(0,l.kt)("td",{parentName:"tr",align:null},"dbView"),(0,l.kt)("td",{parentName:"tr",align:null},"galleryUpdate"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/meta/galleries/{galleryViewId}")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Get"),(0,l.kt)("td",{parentName:"tr",align:null},"dbView"),(0,l.kt)("td",{parentName:"tr",align:null},"galleryRead"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/meta/galleries/{galleryViewId}")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Post"),(0,l.kt)("td",{parentName:"tr",align:null},"dbView"),(0,l.kt)("td",{parentName:"tr",align:null},"kanbanCreate"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/meta/tables/{tableId}/kanbans")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Patch"),(0,l.kt)("td",{parentName:"tr",align:null},"dbView"),(0,l.kt)("td",{parentName:"tr",align:null},"kanbanUpdate"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/meta/kanban/{kanbanViewId}")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Get"),(0,l.kt)("td",{parentName:"tr",align:null},"dbView"),(0,l.kt)("td",{parentName:"tr",align:null},"kanbanRead"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/meta/kanbans/{kanbanViewId}")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Post"),(0,l.kt)("td",{parentName:"tr",align:null},"dbView"),(0,l.kt)("td",{parentName:"tr",align:null},"mapCreate"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/meta/tables/{tableId}/maps")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Patch"),(0,l.kt)("td",{parentName:"tr",align:null},"dbView"),(0,l.kt)("td",{parentName:"tr",align:null},"mapUpdate"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/meta/maps/{mapViewId}")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Get"),(0,l.kt)("td",{parentName:"tr",align:null},"dbView"),(0,l.kt)("td",{parentName:"tr",align:null},"mapRead"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/meta/maps/{mapViewId}")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Post"),(0,l.kt)("td",{parentName:"tr",align:null},"dbView"),(0,l.kt)("td",{parentName:"tr",align:null},"gridCreate"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/meta/tables/{tableId}/grids")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Get"),(0,l.kt)("td",{parentName:"tr",align:null},"dbView"),(0,l.kt)("td",{parentName:"tr",align:null},"gridColumnsList"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/meta/grids/{gridId}/grid-columns")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Patch"),(0,l.kt)("td",{parentName:"tr",align:null},"dbView"),(0,l.kt)("td",{parentName:"tr",align:null},"gridColumnUpdate"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/meta/grid-columns/{columnId}")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Patch"),(0,l.kt)("td",{parentName:"tr",align:null},"dbView"),(0,l.kt)("td",{parentName:"tr",align:null},"update"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/meta/views/{viewId}")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Delete"),(0,l.kt)("td",{parentName:"tr",align:null},"dbView"),(0,l.kt)("td",{parentName:"tr",align:null},"delete"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/meta/views/{viewId}")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Post"),(0,l.kt)("td",{parentName:"tr",align:null},"dbView"),(0,l.kt)("td",{parentName:"tr",align:null},"showAllColumn"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/meta/views/{viewId}/show-all")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Post"),(0,l.kt)("td",{parentName:"tr",align:null},"dbView"),(0,l.kt)("td",{parentName:"tr",align:null},"hideAllColumn"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/meta/views/{viewId}/hide-all")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Get"),(0,l.kt)("td",{parentName:"tr",align:null},"dbViewColumn"),(0,l.kt)("td",{parentName:"tr",align:null},"list"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/meta/views/{viewId}/columns")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Post"),(0,l.kt)("td",{parentName:"tr",align:null},"dbViewColumn"),(0,l.kt)("td",{parentName:"tr",align:null},"create"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/meta/views/{viewId}/columns")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Patch"),(0,l.kt)("td",{parentName:"tr",align:null},"dbViewColumn"),(0,l.kt)("td",{parentName:"tr",align:null},"update"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/meta/views/{viewId}/columns/{columnId}")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Get"),(0,l.kt)("td",{parentName:"tr",align:null},"dbViewShare"),(0,l.kt)("td",{parentName:"tr",align:null},"list"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/meta/views/{viewId}/share")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Post"),(0,l.kt)("td",{parentName:"tr",align:null},"dbViewShare"),(0,l.kt)("td",{parentName:"tr",align:null},"create"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/meta/views/{viewId}/share")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Patch"),(0,l.kt)("td",{parentName:"tr",align:null},"dbViewShare"),(0,l.kt)("td",{parentName:"tr",align:null},"update"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/meta/views/{viewId}/share")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Delete"),(0,l.kt)("td",{parentName:"tr",align:null},"dbViewShare"),(0,l.kt)("td",{parentName:"tr",align:null},"delete"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/meta/views/{viewId}/share")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Get"),(0,l.kt)("td",{parentName:"tr",align:null},"plugin"),(0,l.kt)("td",{parentName:"tr",align:null},"list"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/meta/plugins")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Get"),(0,l.kt)("td",{parentName:"tr",align:null},"plugin"),(0,l.kt)("td",{parentName:"tr",align:null},"status"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/meta/plugins/{pluginTitle}/status")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Post"),(0,l.kt)("td",{parentName:"tr",align:null},"plugin"),(0,l.kt)("td",{parentName:"tr",align:null},"test"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/meta/plugins/test")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"PATCH"),(0,l.kt)("td",{parentName:"tr",align:null},"plugin"),(0,l.kt)("td",{parentName:"tr",align:null},"update"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/meta/plugins/{pluginId}")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Get"),(0,l.kt)("td",{parentName:"tr",align:null},"plugin"),(0,l.kt)("td",{parentName:"tr",align:null},"read"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/meta/plugins/{pluginId}")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Get"),(0,l.kt)("td",{parentName:"tr",align:null},"project"),(0,l.kt)("td",{parentName:"tr",align:null},"metaGet"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/meta/projects/{projectId}/info")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Get"),(0,l.kt)("td",{parentName:"tr",align:null},"project"),(0,l.kt)("td",{parentName:"tr",align:null},"modelVisibilityList"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/meta/projects/{projectId}/visibility-rules")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Post"),(0,l.kt)("td",{parentName:"tr",align:null},"project"),(0,l.kt)("td",{parentName:"tr",align:null},"modelVisibilitySet"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/meta/projects/{projectId}/visibility-rules")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Get"),(0,l.kt)("td",{parentName:"tr",align:null},"project"),(0,l.kt)("td",{parentName:"tr",align:null},"list"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/meta/projects")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Post"),(0,l.kt)("td",{parentName:"tr",align:null},"project"),(0,l.kt)("td",{parentName:"tr",align:null},"create"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/meta/projects")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Get"),(0,l.kt)("td",{parentName:"tr",align:null},"project"),(0,l.kt)("td",{parentName:"tr",align:null},"read"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/meta/projects/{projectId}")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Delete"),(0,l.kt)("td",{parentName:"tr",align:null},"project"),(0,l.kt)("td",{parentName:"tr",align:null},"delete"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/meta/projects/{projectId}")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Get"),(0,l.kt)("td",{parentName:"tr",align:null},"project"),(0,l.kt)("td",{parentName:"tr",align:null},"auditList"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/meta/projects/{projectId}/audits")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Get"),(0,l.kt)("td",{parentName:"tr",align:null},"project"),(0,l.kt)("td",{parentName:"tr",align:null},"metaDiffGet"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/meta/projects/{projectId}/meta-diff")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Post"),(0,l.kt)("td",{parentName:"tr",align:null},"project"),(0,l.kt)("td",{parentName:"tr",align:null},"metaDiffSync"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/meta/projects/{projectId}/meta-diff")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Get"),(0,l.kt)("td",{parentName:"tr",align:null},"project"),(0,l.kt)("td",{parentName:"tr",align:null},"sharedBaseGet"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/meta/projects/{projectId}/shared")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Delete"),(0,l.kt)("td",{parentName:"tr",align:null},"project"),(0,l.kt)("td",{parentName:"tr",align:null},"sharedBaseDisable"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/meta/projects/{projectId}/shared")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Post"),(0,l.kt)("td",{parentName:"tr",align:null},"project"),(0,l.kt)("td",{parentName:"tr",align:null},"sharedBaseCreate"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/meta/projects/{projectId}/shared")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Patch"),(0,l.kt)("td",{parentName:"tr",align:null},"project"),(0,l.kt)("td",{parentName:"tr",align:null},"sharedBaseUpdate"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/meta/projects/{projectId}/shared")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Post"),(0,l.kt)("td",{parentName:"tr",align:null},"storage"),(0,l.kt)("td",{parentName:"tr",align:null},"upload"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/storage/upload")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Post"),(0,l.kt)("td",{parentName:"tr",align:null},"storage"),(0,l.kt)("td",{parentName:"tr",align:null},"uploadByUrl"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/storage/upload-by-url")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Get"),(0,l.kt)("td",{parentName:"tr",align:null},"utils"),(0,l.kt)("td",{parentName:"tr",align:null},"commentList"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/meta/audits/comments")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Post"),(0,l.kt)("td",{parentName:"tr",align:null},"utils"),(0,l.kt)("td",{parentName:"tr",align:null},"commentRow"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/meta/audits/comments")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Get"),(0,l.kt)("td",{parentName:"tr",align:null},"utils"),(0,l.kt)("td",{parentName:"tr",align:null},"commentCount"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/meta/audits/comments/count")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Post"),(0,l.kt)("td",{parentName:"tr",align:null},"utils"),(0,l.kt)("td",{parentName:"tr",align:null},"auditRowUpdate"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/meta/audits/update")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Get"),(0,l.kt)("td",{parentName:"tr",align:null},"utils"),(0,l.kt)("td",{parentName:"tr",align:null},"cacheGet"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/meta/cache")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Delete"),(0,l.kt)("td",{parentName:"tr",align:null},"utils"),(0,l.kt)("td",{parentName:"tr",align:null},"cacheDelete"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/meta/cache")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Post"),(0,l.kt)("td",{parentName:"tr",align:null},"utils"),(0,l.kt)("td",{parentName:"tr",align:null},"testConnection"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/meta/projects/connection/test")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Get"),(0,l.kt)("td",{parentName:"tr",align:null},"utils"),(0,l.kt)("td",{parentName:"tr",align:null},"appInfo"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/db/meta/nocodb/info")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Get"),(0,l.kt)("td",{parentName:"tr",align:null},"utils"),(0,l.kt)("td",{parentName:"tr",align:null},"appVersion"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/version")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Get"),(0,l.kt)("td",{parentName:"tr",align:null},"utils"),(0,l.kt)("td",{parentName:"tr",align:null},"appHealth"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/health")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Get"),(0,l.kt)("td",{parentName:"tr",align:null},"utils"),(0,l.kt)("td",{parentName:"tr",align:null},"aggregatedMetaInfo"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/aggregated-meta-info")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Get"),(0,l.kt)("td",{parentName:"tr",align:null},"orgUsers"),(0,l.kt)("td",{parentName:"tr",align:null},"list"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/users")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Post"),(0,l.kt)("td",{parentName:"tr",align:null},"orgUsers"),(0,l.kt)("td",{parentName:"tr",align:null},"add"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/users")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Patch"),(0,l.kt)("td",{parentName:"tr",align:null},"orgUsers"),(0,l.kt)("td",{parentName:"tr",align:null},"update"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/users/{userId}")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Delete"),(0,l.kt)("td",{parentName:"tr",align:null},"orgUsers"),(0,l.kt)("td",{parentName:"tr",align:null},"delete"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/users/{userId}")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Get"),(0,l.kt)("td",{parentName:"tr",align:null},"orgTokens"),(0,l.kt)("td",{parentName:"tr",align:null},"list"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/tokens")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Post"),(0,l.kt)("td",{parentName:"tr",align:null},"orgTokens"),(0,l.kt)("td",{parentName:"tr",align:null},"create"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/tokens")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Delete"),(0,l.kt)("td",{parentName:"tr",align:null},"orgTokens"),(0,l.kt)("td",{parentName:"tr",align:null},"delete"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/tokens/{token}")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Get"),(0,l.kt)("td",{parentName:"tr",align:null},"orgAppSettings"),(0,l.kt)("td",{parentName:"tr",align:null},"get"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/app-settings")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"Meta"),(0,l.kt)("td",{parentName:"tr",align:null},"Post"),(0,l.kt)("td",{parentName:"tr",align:null},"orgAppSettings"),(0,l.kt)("td",{parentName:"tr",align:null},"set"),(0,l.kt)("td",{parentName:"tr",align:null},"/api/v1/app-settings")))),(0,l.kt)("h2",{id:"query-params"},"Query params"),(0,l.kt)("table",null,(0,l.kt)("thead",{parentName:"table"},(0,l.kt)("tr",{parentName:"thead"},(0,l.kt)("th",{parentName:"tr",align:null},(0,l.kt)("strong",{parentName:"th"},"Name")),(0,l.kt)("th",{parentName:"tr",align:null},(0,l.kt)("strong",{parentName:"th"},"Alias")),(0,l.kt)("th",{parentName:"tr",align:null},(0,l.kt)("strong",{parentName:"th"},"Use case")),(0,l.kt)("th",{parentName:"tr",align:null},(0,l.kt)("strong",{parentName:"th"},"Default value")),(0,l.kt)("th",{parentName:"tr",align:null},(0,l.kt)("strong",{parentName:"th"},"Example value")))),(0,l.kt)("tbody",{parentName:"table"},(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},(0,l.kt)("a",{parentName:"td",href:"#comparison-operators"},"where")),(0,l.kt)("td",{parentName:"tr",align:null},(0,l.kt)("a",{parentName:"td",href:"#comparison-operators"},"w")),(0,l.kt)("td",{parentName:"tr",align:null},"Complicated where conditions"),(0,l.kt)("td",{parentName:"tr",align:null}),(0,l.kt)("td",{parentName:"tr",align:null},(0,l.kt)("inlineCode",{parentName:"td"},"(colName,eq,colValue)~or(colName2,gt,colValue2)")," ",(0,l.kt)("br",null),(0,l.kt)("a",{parentName:"td",href:"#comparison-operators"},"Usage: Comparison operators")," ",(0,l.kt)("br",null),(0,l.kt)("a",{parentName:"td",href:"#logical-operators"},"Usage: Logical operators"))),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"limit"),(0,l.kt)("td",{parentName:"tr",align:null},"l"),(0,l.kt)("td",{parentName:"tr",align:null},"Number of rows to get (SQL limit value)"),(0,l.kt)("td",{parentName:"tr",align:null},"10"),(0,l.kt)("td",{parentName:"tr",align:null},"20")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"offset"),(0,l.kt)("td",{parentName:"tr",align:null},"o"),(0,l.kt)("td",{parentName:"tr",align:null},"Offset for pagination (SQL offset value)"),(0,l.kt)("td",{parentName:"tr",align:null},"0"),(0,l.kt)("td",{parentName:"tr",align:null},"20")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"sort"),(0,l.kt)("td",{parentName:"tr",align:null},"s"),(0,l.kt)("td",{parentName:"tr",align:null},"Sort by column name, Use ",(0,l.kt)("inlineCode",{parentName:"td"},"-")," as prefix for descending sort"),(0,l.kt)("td",{parentName:"tr",align:null}),(0,l.kt)("td",{parentName:"tr",align:null},"column_name")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"fields"),(0,l.kt)("td",{parentName:"tr",align:null},"f"),(0,l.kt)("td",{parentName:"tr",align:null},"Required column names in result"),(0,l.kt)("td",{parentName:"tr",align:null},"*"),(0,l.kt)("td",{parentName:"tr",align:null},"column_name1,column_name2")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"shuffle"),(0,l.kt)("td",{parentName:"tr",align:null},"r"),(0,l.kt)("td",{parentName:"tr",align:null},"Shuffle the result for pagination"),(0,l.kt)("td",{parentName:"tr",align:null},"0"),(0,l.kt)("td",{parentName:"tr",align:null},"1 (Only allow 0 or 1. Other values would see it as 0)")))),(0,l.kt)("h2",{id:"comparison-operators"},"Comparison Operators"),(0,l.kt)("table",null,(0,l.kt)("thead",{parentName:"table"},(0,l.kt)("tr",{parentName:"thead"},(0,l.kt)("th",{parentName:"tr",align:null},"Operation"),(0,l.kt)("th",{parentName:"tr",align:null},"Meaning"),(0,l.kt)("th",{parentName:"tr",align:null},"Example"))),(0,l.kt)("tbody",{parentName:"table"},(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"eq"),(0,l.kt)("td",{parentName:"tr",align:null},"equal"),(0,l.kt)("td",{parentName:"tr",align:null},"(colName,eq,colValue)")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"neq"),(0,l.kt)("td",{parentName:"tr",align:null},"not equal"),(0,l.kt)("td",{parentName:"tr",align:null},"(colName,neq,colValue)")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"not"),(0,l.kt)("td",{parentName:"tr",align:null},"not equal (alias of neq)"),(0,l.kt)("td",{parentName:"tr",align:null},"(colName,not,colValue)")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"gt"),(0,l.kt)("td",{parentName:"tr",align:null},"greater than"),(0,l.kt)("td",{parentName:"tr",align:null},"(colName,gt,colValue)")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"ge"),(0,l.kt)("td",{parentName:"tr",align:null},"greater or equal"),(0,l.kt)("td",{parentName:"tr",align:null},"(colName,ge,colValue)")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"lt"),(0,l.kt)("td",{parentName:"tr",align:null},"less than"),(0,l.kt)("td",{parentName:"tr",align:null},"(colName,lt,colValue)")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"le"),(0,l.kt)("td",{parentName:"tr",align:null},"less or equal"),(0,l.kt)("td",{parentName:"tr",align:null},"(colName,le,colValue)")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"is"),(0,l.kt)("td",{parentName:"tr",align:null},"is"),(0,l.kt)("td",{parentName:"tr",align:null},"(colName,is,true/false/null)")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"isnot"),(0,l.kt)("td",{parentName:"tr",align:null},"is not"),(0,l.kt)("td",{parentName:"tr",align:null},"(colName,isnot,true/false/null)")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"in"),(0,l.kt)("td",{parentName:"tr",align:null},"in"),(0,l.kt)("td",{parentName:"tr",align:null},"(colName,in,val1,val2,val3,val4)")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"btw"),(0,l.kt)("td",{parentName:"tr",align:null},"between"),(0,l.kt)("td",{parentName:"tr",align:null},"(colName,btw,val1,val2)")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"nbtw"),(0,l.kt)("td",{parentName:"tr",align:null},"not between"),(0,l.kt)("td",{parentName:"tr",align:null},"(colName,nbtw,val1,val2)")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"like"),(0,l.kt)("td",{parentName:"tr",align:null},"like"),(0,l.kt)("td",{parentName:"tr",align:null},"(colName,like,%name)")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"isWithin"),(0,l.kt)("td",{parentName:"tr",align:null},"is Within (Available in ",(0,l.kt)("inlineCode",{parentName:"td"},"Date")," and ",(0,l.kt)("inlineCode",{parentName:"td"},"DateTime")," only)"),(0,l.kt)("td",{parentName:"tr",align:null},"(colName,isWithin,sub_op)")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"allof"),(0,l.kt)("td",{parentName:"tr",align:null},"includes all of"),(0,l.kt)("td",{parentName:"tr",align:null},"(colName,allof,val1,val2,...)")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"anyof"),(0,l.kt)("td",{parentName:"tr",align:null},"includes any of"),(0,l.kt)("td",{parentName:"tr",align:null},"(colName,anyof,val1,val2,...)")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"nallof"),(0,l.kt)("td",{parentName:"tr",align:null},"does not include all of (includes none or some, but not all of)"),(0,l.kt)("td",{parentName:"tr",align:null},"(colName,nallof,val1,val2,...)")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"nanyof"),(0,l.kt)("td",{parentName:"tr",align:null},"does not include any of (includes none of)"),(0,l.kt)("td",{parentName:"tr",align:null},"(colName,nanyof,val1,val2,...)")))),(0,l.kt)("h2",{id:"comparison-sub-operators"},"Comparison Sub-Operators"),(0,l.kt)("p",null,"The following sub-operators are available in ",(0,l.kt)("inlineCode",{parentName:"p"},"Date")," and ",(0,l.kt)("inlineCode",{parentName:"p"},"DateTime")," columns."),(0,l.kt)("table",null,(0,l.kt)("thead",{parentName:"table"},(0,l.kt)("tr",{parentName:"thead"},(0,l.kt)("th",{parentName:"tr",align:null},"Operation"),(0,l.kt)("th",{parentName:"tr",align:null},"Meaning"),(0,l.kt)("th",{parentName:"tr",align:null},"Example"))),(0,l.kt)("tbody",{parentName:"table"},(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"today"),(0,l.kt)("td",{parentName:"tr",align:null},"today"),(0,l.kt)("td",{parentName:"tr",align:null},"(colName,eq,today)")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"tomorrow"),(0,l.kt)("td",{parentName:"tr",align:null},"tomorrow"),(0,l.kt)("td",{parentName:"tr",align:null},"(colName,eq,tomorrow)")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"yesterday"),(0,l.kt)("td",{parentName:"tr",align:null},"yesterday"),(0,l.kt)("td",{parentName:"tr",align:null},"(colName,eq,yesterday)")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"oneWeekAgo"),(0,l.kt)("td",{parentName:"tr",align:null},"one week ago"),(0,l.kt)("td",{parentName:"tr",align:null},"(colName,eq,oneWeekAgo)")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"oneWeekFromNow"),(0,l.kt)("td",{parentName:"tr",align:null},"one week from now"),(0,l.kt)("td",{parentName:"tr",align:null},"(colName,eq,oneWeekFromNow)")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"oneMonthAgo"),(0,l.kt)("td",{parentName:"tr",align:null},"one month ago"),(0,l.kt)("td",{parentName:"tr",align:null},"(colName,eq,oneMonthAgo)")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"oneMonthFromNow"),(0,l.kt)("td",{parentName:"tr",align:null},"one month from now"),(0,l.kt)("td",{parentName:"tr",align:null},"(colName,eq,oneMonthFromNow)")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"daysAgo"),(0,l.kt)("td",{parentName:"tr",align:null},"number of days ago"),(0,l.kt)("td",{parentName:"tr",align:null},"(colName,eq,daysAgo,10)")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"daysFromNow"),(0,l.kt)("td",{parentName:"tr",align:null},"number of days from now"),(0,l.kt)("td",{parentName:"tr",align:null},"(colName,eq,daysFromNow,10)")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"exactDate"),(0,l.kt)("td",{parentName:"tr",align:null},"exact date"),(0,l.kt)("td",{parentName:"tr",align:null},"(colName,eq,exactDate,2022-02-02)")))),(0,l.kt)("p",null,"For ",(0,l.kt)("inlineCode",{parentName:"p"},"isWithin")," in ",(0,l.kt)("inlineCode",{parentName:"p"},"Date")," and ",(0,l.kt)("inlineCode",{parentName:"p"},"DateTime")," columns, the different set of sub-operators are used."),(0,l.kt)("table",null,(0,l.kt)("thead",{parentName:"table"},(0,l.kt)("tr",{parentName:"thead"},(0,l.kt)("th",{parentName:"tr",align:null},"Operation"),(0,l.kt)("th",{parentName:"tr",align:null},"Meaning"),(0,l.kt)("th",{parentName:"tr",align:null},"Example"))),(0,l.kt)("tbody",{parentName:"table"},(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"pastWeek"),(0,l.kt)("td",{parentName:"tr",align:null},"the past week"),(0,l.kt)("td",{parentName:"tr",align:null},"(colName,isWithin,pastWeek)")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"pastMonth"),(0,l.kt)("td",{parentName:"tr",align:null},"the past month"),(0,l.kt)("td",{parentName:"tr",align:null},"(colName,isWithin,pastMonth)")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"pastYear"),(0,l.kt)("td",{parentName:"tr",align:null},"the past year"),(0,l.kt)("td",{parentName:"tr",align:null},"(colName,isWithin,pastYear)")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"nextWeek"),(0,l.kt)("td",{parentName:"tr",align:null},"the next week"),(0,l.kt)("td",{parentName:"tr",align:null},"(colName,isWithin,nextWeek)")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"nextMonth"),(0,l.kt)("td",{parentName:"tr",align:null},"the next month"),(0,l.kt)("td",{parentName:"tr",align:null},"(colName,isWithin,nextMonth)")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"nextYear"),(0,l.kt)("td",{parentName:"tr",align:null},"the next year"),(0,l.kt)("td",{parentName:"tr",align:null},"(colName,isWithin,nextYear)")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"nextNumberOfDays"),(0,l.kt)("td",{parentName:"tr",align:null},"the next number of days"),(0,l.kt)("td",{parentName:"tr",align:null},"(colName,isWithin,nextNumberOfDays,10)")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"pastNumberOfDays"),(0,l.kt)("td",{parentName:"tr",align:null},"the past number of days"),(0,l.kt)("td",{parentName:"tr",align:null},"(colName,isWithin,pastNumberOfDays,10)")))),(0,l.kt)("h2",{id:"logical-operators"},"Logical Operators"),(0,l.kt)("table",null,(0,l.kt)("thead",{parentName:"table"},(0,l.kt)("tr",{parentName:"thead"},(0,l.kt)("th",{parentName:"tr",align:null},"Operation"),(0,l.kt)("th",{parentName:"tr",align:null},"Example"))),(0,l.kt)("tbody",{parentName:"table"},(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"~or"),(0,l.kt)("td",{parentName:"tr",align:null},"(checkNumber,eq,JM555205)~or((amount, gt, 200)~and(amount, lt, 2000))")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"~and"),(0,l.kt)("td",{parentName:"tr",align:null},"(checkNumber,eq,JM555205)~and((amount, gt, 200)~and(amount, lt, 2000))")),(0,l.kt)("tr",{parentName:"tbody"},(0,l.kt)("td",{parentName:"tr",align:null},"~not"),(0,l.kt)("td",{parentName:"tr",align:null},"~not(checkNumber,eq,JM555205)")))))}k.isMDXComponent=!0}}]); |