API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Nov 13th, 2019
121
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 27.37 KB | None | 0 0
raw download clone embed print report
  1. {
  2. "show404Page": 0,
  3. "autoLogin": "NO",
  4. "autoPublish": "NO",
  5. "styleAndNavigation": {
  6. "content": [
  7. "georgia",
  8. "largeContent",
  9. "#000000",
  10. "left"
  11. ],
  12. "fieldBgColor": "#F7F7F7",
  13. "button": [
  14. "georgia",
  15. "largeContent",
  16. "rgb(75,166,31)",
  17. "#184396"
  18. ],
  19. "secondaryButton": [
  20. "georgia",
  21. "largeContent",
  22. "rgb(255,173,48)",
  23. "#ffffff"
  24. ],
  25. "pageBgColor": "rgba(255,255,255,0)",
  26. "boxBackground": "#ffffff",
  27. "borderColor": "#c9c9c9",
  28. "fieldTextColor": "#c41b9f",
  29. "iconColor": "#a10e0e",
  30. "Lebel": [
  31. "georgia",
  32. "mediumContent",
  33. "#c72020"
  34. ],
  35. "Data": [
  36. "georgia",
  37. "largeSubHeading",
  38. "#000000"
  39. ]
  40. },
  41. "pageTitle": "App Sheet",
  42. "lang": "en",
  43. "metaDetails": {
  44. "metaKeywords": "App Sheet",
  45. "metaDescription": "With appsheet page, you can easily integrate your Google sheets into your app, allowing users to manage records on the fly.",
  46. "metaTitle": "App Sheet"
  47. },
  48. "settings": {
  49. "clientId": "3632443312-likbmtc6h9a4pb9scbnt77c4fl4nipq3.apps.googleusercontent.com",
  50. "email": "ajaya@appypiellp.com",
  51. "refreshToken": "1/hV2Tw5Ioi-udebnCHXag_tEaIzX30ONZOUidG8tFyQs",
  52. "clientSecret": "qtvuZi7RXszR_GCzVlKq2_3Q"
  53. },
  54. "pageTables": [
  55. {
  56. "_id": "5dc557648b03bedb07782a84",
  57. "permission": {
  58. "id": "all",
  59. "values": {
  60. "view": 1,
  61. "add": 1,
  62. "delete": 1,
  63. "update": 1
  64. }
  65. },
  66. no_of_relationship:[{"sheetName":"ColumnName"},{"sheetName":"ColumnName"},{"sheetName":"ColumnName"}],
  67. "sheet": {
  68. "id": "0",
  69. "title": "Sheet1"
  70. },
  71. "spreadsheet": {
  72. "id": "17Cr5t38wRA-vbXE08T3tiiz3dL6oU62KQfYroBR53Gg",
  73. "name": "appsheet",
  74. "type": "sheet",
  75. "parent": "0AH89gEsXC-lUUk9PVA",
  76. "owner": "Me",
  77. "modifiedTime": "2019-11-08T11:33:34.427Z",
  78. "permission": true
  79. },
  80. "displayName": "appsheet",
  81. "appId": "9b42e145bfb0",
  82. "pageId": "app-sheet_1566197853833_101",
  83. "isDefault": 1,
  84. "tableAddedOn": 1573214052,
  85. "addedon": 1573214052,
  86. "updatedon": 1573214074,
  87. "tableData": [
  88. {
  89. "_id": "5dc557668b03bedb07782a85",
  90. "appId": "9b42e145bfb0",
  91. "pageId": "app-sheet_1566197853833_101",
  92. "tableId": "5dc557648b03bedb07782a84",
  93. "spreadsheetId": "17Cr5t38wRA-vbXE08T3tiiz3dL6oU62KQfYroBR53Gg",
  94. "sheetId": "0",
  95. "columns": [
  96. {
  97. "formula": "",
  98. "key": false,
  99. "label": false,
  100. "readOnly": false,
  101. "required": false,
  102. "hidden": false,
  103. "deleted": 0,
  104. "title": "_RowNumber",
  105. "dataType": "number",
  106. "displayName": "_RowNumber"
  107. },
  108. {
  109. "formula": "ref(5dc551498b03befb2c782a87)",
  110. "key": true,
  111. "label": true,
  112. "readOnly": false,
  113. "required": false,
  114. "hidden": false,
  115. "deleted": 0,
  116. "title": "Name",
  117. "dataType": "ref",
  118. "displayName": "Name"
  119. },
  120. {
  121. "formula": "",
  122. "key": false,
  123. "label": true,
  124. "readOnly": false,
  125. "required": false,
  126. "hidden": false,
  127. "deleted": 0,
  128. "title": "Department",
  129. "dataType": "latnlong",
  130. "displayName": "Department"
  131. },
  132. {
  133. "formula": "",
  134. "key": false,
  135. "label": false,
  136. "readOnly": false,
  137. "required": false,
  138. "hidden": false,
  139. "deleted": 0,
  140. "title": "Exp. ",
  141. "dataType": "text",
  142. "displayName": "Exp. "
  143. },
  144. {
  145. "formula": "",
  146. "key": false,
  147. "label": false,
  148. "readOnly": false,
  149. "required": false,
  150. "hidden": false,
  151. "deleted": 0,
  152. "title": "Salary",
  153. "dataType": "text",
  154. "displayName": "Salary"
  155. },
  156. {
  157. "formula": "LIST(LATLONG(LAT([Department]),LONG([Department])),LATLONG([Department]))",
  158. "key": false,
  159. "label": false,
  160. "readOnly": false,
  161. "required": false,
  162. "hidden": false,
  163. "deleted": 0,
  164. "title": "Yes/No",
  165. "dataType": "text",
  166. "displayName": "Yes/No"
  167. }
  168. ],
  169. "updatedon": 1573626169
  170. }
  171. ]
  172. },
  173. {
  174. "_id": "5d91a4788b03be60717af519",
  175. "displayName": "UpdatedTaskSheet",
  176. "spreadsheet": {
  177. "id": "1xhQK90ajKJId88ehSjKmW7Ka0LZAIvM8dB-3tnAs7wU",
  178. "name": "newtestsheet",
  179. "type": "sheet",
  180. "parent": "0AH89gEsXC-lUUk9PVA",
  181. "owner": "Me",
  182. "modifiedTime": "2019-09-30T06:37:03.132Z",
  183. "permission": true
  184. },
  185. "sheet": {
  186. "id": "0",
  187. "title": "Sheet1"
  188. },
  189. "permission": {
  190. "id": "add_update",
  191. "values": {
  192. "view": 1,
  193. "add": 1,
  194. "delete": 0,
  195. "update": 1
  196. }
  197. },
  198. "isDefault": 0,
  199. "tableAddedOn": 1569825912,
  200. "appId": "9b42e145bfb0",
  201. "pageId": "app-sheet_1566197853833_101",
  202. "updatedon": 1573214074,
  203. "tableData": [
  204. {
  205. "_id": "5d91a47c8b03be60717af51a",
  206. "appId": "9b42e145bfb0",
  207. "pageId": "app-sheet_1566197853833_101",
  208. "tableId": "5d91a4788b03be60717af519",
  209. "spreadsheetId": "1xhQK90ajKJId88ehSjKmW7Ka0LZAIvM8dB-3tnAs7wU",
  210. "sheetId": "0",
  211. "columns": [
  212. {
  213. "formula": "",
  214. "key": false,
  215. "label": false,
  216. "readOnly": false,
  217. "required": false,
  218. "hidden": false,
  219. "deleted": 0,
  220. "title": "_RowNumber",
  221. "displayName": "_RowNumber",
  222. "dataType": "number"
  223. },
  224. {
  225. "formula": "",
  226. "key": true,
  227. "label": false,
  228. "readOnly": false,
  229. "required": false,
  230. "hidden": false,
  231. "deleted": 0,
  232. "title": "Id",
  233. "displayName": "Id",
  234. "dataType": "number"
  235. },
  236. {
  237. "formula": "",
  238. "key": false,
  239. "label": true,
  240. "readOnly": false,
  241. "required": true,
  242. "hidden": false,
  243. "deleted": 0,
  244. "title": "Name",
  245. "displayName": "Name",
  246. "dataType": "text"
  247. },
  248. {
  249. "formula": "",
  250. "key": false,
  251. "label": false,
  252. "readOnly": false,
  253. "required": false,
  254. "hidden": false,
  255. "deleted": 0,
  256. "title": "Dept Id",
  257. "displayName": "Dept Id",
  258. "dataType": "number"
  259. },
  260. {
  261. "formula": "",
  262. "key": false,
  263. "label": false,
  264. "readOnly": false,
  265. "required": false,
  266. "hidden": false,
  267. "deleted": 0,
  268. "title": "DOB",
  269. "displayName": "DOB",
  270. "dataType": "date"
  271. },
  272. {
  273. "formula": "",
  274. "key": false,
  275. "label": false,
  276. "readOnly": false,
  277. "required": false,
  278. "hidden": false,
  279. "deleted": 0,
  280. "title": "Date and Time",
  281. "displayName": "Date and Time",
  282. "dataType": "date"
  283. },
  284. {
  285. "formula": "",
  286. "key": false,
  287. "label": false,
  288. "readOnly": false,
  289. "required": false,
  290. "hidden": false,
  291. "deleted": 0,
  292. "title": "Time",
  293. "displayName": "Time",
  294. "dataType": "time"
  295. },
  296. {
  297. "formula": "",
  298. "key": false,
  299. "label": false,
  300. "readOnly": false,
  301. "required": false,
  302. "hidden": false,
  303. "deleted": 0,
  304. "title": "Decimal",
  305. "displayName": "Decimal",
  306. "dataType": "decimal"
  307. },
  308. {
  309. "formula": "",
  310. "key": false,
  311. "label": true,
  312. "readOnly": false,
  313. "required": true,
  314. "hidden": false,
  315. "deleted": 0,
  316. "title": "Email",
  317. "displayName": "Email",
  318. "dataType": "email"
  319. },
  320. {
  321. "formula": "",
  322. "key": false,
  323. "label": false,
  324. "readOnly": false,
  325. "required": false,
  326. "hidden": false,
  327. "deleted": 0,
  328. "title": "Url",
  329. "displayName": "Url",
  330. "dataType": "url"
  331. },
  332. {
  333. "formula": "",
  334. "key": false,
  335. "label": false,
  336. "readOnly": false,
  337. "required": false,
  338. "hidden": false,
  339. "deleted": 0,
  340. "title": "Phone",
  341. "displayName": "Phone",
  342. "dataType": "phone"
  343. },
  344. {
  345. "formula": "",
  346. "key": false,
  347. "label": false,
  348. "readOnly": false,
  349. "required": false,
  350. "hidden": false,
  351. "deleted": 0,
  352. "title": "Address",
  353. "displayName": "Address",
  354. "dataType": "address"
  355. },
  356. {
  357. "formula": "#000000, #86e573, #20c8e5, #2468e5, #e5b93d, #89e52f, #c9e5d7, #e55fdc",
  358. "key": false,
  359. "label": false,
  360. "readOnly": false,
  361. "required": false,
  362. "hidden": false,
  363. "deleted": 0,
  364. "title": "Color",
  365. "displayName": "Color",
  366. "dataType": "color"
  367. },
  368. {
  369. "formula": "",
  370. "key": false,
  371. "label": false,
  372. "readOnly": false,
  373. "required": false,
  374. "hidden": false,
  375. "deleted": 0,
  376. "title": "Duration",
  377. "displayName": "Duration",
  378. "dataType": "text"
  379. },
  380. {
  381. "formula": "ok, cancel",
  382. "key": false,
  383. "label": false,
  384. "readOnly": false,
  385. "required": false,
  386. "hidden": false,
  387. "deleted": 0,
  388. "title": "Enum",
  389. "displayName": "Enum",
  390. "dataType": "enum"
  391. },
  392. {
  393. "formula": "yes, no, not confirm yet",
  394. "key": false,
  395. "label": false,
  396. "readOnly": false,
  397. "required": false,
  398. "hidden": false,
  399. "deleted": 0,
  400. "title": "Enum List",
  401. "displayName": "Enum List",
  402. "dataType": "enumlist"
  403. },
  404. {
  405. "formula": "",
  406. "key": false,
  407. "label": false,
  408. "readOnly": false,
  409. "required": false,
  410. "hidden": false,
  411. "deleted": 0,
  412. "title": "File",
  413. "displayName": "File",
  414. "dataType": "file"
  415. },
  416. {
  417. "formula": "",
  418. "key": false,
  419. "label": false,
  420. "readOnly": false,
  421. "required": false,
  422. "hidden": false,
  423. "deleted": 0,
  424. "title": "Image",
  425. "displayName": "Image",
  426. "dataType": "image"
  427. },
  428. {
  429. "formula": "",
  430. "key": false,
  431. "label": false,
  432. "readOnly": false,
  433. "required": false,
  434. "hidden": false,
  435. "deleted": 0,
  436. "title": "Lat&Long",
  437. "displayName": "Lat&Long",
  438. "dataType": "latnlong"
  439. },
  440. {
  441. "formula": "",
  442. "key": false,
  443. "label": false,
  444. "readOnly": false,
  445. "required": false,
  446. "hidden": false,
  447. "deleted": 0,
  448. "title": "Long Text",
  449. "displayName": "Long Text",
  450. "dataType": "text"
  451. },
  452. {
  453. "formula": "",
  454. "key": false,
  455. "label": false,
  456. "readOnly": false,
  457. "required": false,
  458. "hidden": false,
  459. "deleted": 0,
  460. "title": "Text",
  461. "displayName": "Text",
  462. "dataType": "text"
  463. },
  464. {
  465. "formula": "",
  466. "key": false,
  467. "label": false,
  468. "readOnly": false,
  469. "required": false,
  470. "hidden": false,
  471. "deleted": 0,
  472. "title": "Percent",
  473. "displayName": "Percent",
  474. "dataType": "percent"
  475. },
  476. {
  477. "formula": "",
  478. "key": false,
  479. "label": false,
  480. "readOnly": false,
  481. "required": false,
  482. "hidden": false,
  483. "deleted": 0,
  484. "title": "Price",
  485. "displayName": "Price",
  486. "dataType": "price"
  487. },
  488. {
  489. "formula": "",
  490. "key": false,
  491. "label": false,
  492. "readOnly": false,
  493. "required": false,
  494. "hidden": false,
  495. "deleted": 0,
  496. "title": "Progress",
  497. "displayName": "Progress",
  498. "dataType": "text"
  499. },
  500. {
  501. "formula": "",
  502. "key": false,
  503. "label": false,
  504. "readOnly": false,
  505. "required": false,
  506. "hidden": false,
  507. "deleted": 0,
  508. "title": "Video",
  509. "displayName": "Video",
  510. "dataType": "text"
  511. },
  512. {
  513. "formula": "",
  514. "key": false,
  515. "label": false,
  516. "readOnly": false,
  517. "required": false,
  518. "hidden": false,
  519. "deleted": 0,
  520. "title": "Yes/No",
  521. "displayName": "Yes/No",
  522. "dataType": "text"
  523. },
  524. {
  525. "formula": "",
  526. "key": false,
  527. "label": false,
  528. "readOnly": false,
  529. "required": false,
  530. "hidden": false,
  531. "deleted": 0,
  532. "title": "Signature",
  533. "displayName": "Signature",
  534. "dataType": "signature"
  535. },
  536. {
  537. "formula": "",
  538. "key": false,
  539. "label": false,
  540. "readOnly": false,
  541. "required": false,
  542. "hidden": false,
  543. "deleted": 0,
  544. "title": "Change Location",
  545. "displayName": "Change Location",
  546. "dataType": "change_location"
  547. },
  548. {
  549. "formula": "",
  550. "key": false,
  551. "label": false,
  552. "readOnly": false,
  553. "required": false,
  554. "hidden": false,
  555. "deleted": 0,
  556. "title": "Change Timestamp ",
  557. "displayName": "Change Timestamp ",
  558. "dataType": "change_timestamp"
  559. }
  560. ],
  561. "updatedon": 1573542934
  562. }
  563. ]
  564. },
  565. {
  566. "_id": "5dc551498b03befb2c782a87",
  567. "permission": {
  568. "id": "all",
  569. "values": {
  570. "view": 1,
  571. "add": 1,
  572. "delete": 1,
  573. "update": 1
  574. }
  575. },
  576. "sheet": {
  577. "id": "0",
  578. "title": "Sheet1"
  579. },
  580. "spreadsheet": {
  581. "id": "14YAgJo47woWS5XngcmquYf7da3ixAOLq34ZOR0aa158",
  582. "name": "mysheet",
  583. "type": "sheet",
  584. "parent": "0AH89gEsXC-lUUk9PVA",
  585. "owner": "Me",
  586. "modifiedTime": "2019-11-06T13:36:44.131Z",
  587. "permission": true
  588. },
  589. "displayName": "mysheet",
  590. "appId": "9b42e145bfb0",
  591. "pageId": "app-sheet_1566197853833_101",
  592. "isDefault": 0,
  593. "tableAddedOn": 1573212489,
  594. "addedon": 1573212489,
  595. "updatedon": 1573214074,
  596. "tableData": [
  597. {
  598. "_id": "5dc5514b8b03be042d782a85",
  599. "appId": "9b42e145bfb0",
  600. "pageId": "app-sheet_1566197853833_101",
  601. "tableId": "5dc551498b03befb2c782a87",
  602. "spreadsheetId": "14YAgJo47woWS5XngcmquYf7da3ixAOLq34ZOR0aa158",
  603. "sheetId": "0",
  604. "columns": [
  605. {
  606. "formula": "",
  607. "key": false,
  608. "label": false,
  609. "readOnly": false,
  610. "required": false,
  611. "hidden": false,
  612. "deleted": 0,
  613. "title": "_RowNumber",
  614. "displayName": "_RowNumber",
  615. "dataType": "number"
  616. },
  617. {
  618. "formula": "",
  619. "key": true,
  620. "label": true,
  621. "readOnly": false,
  622. "required": false,
  623. "hidden": false,
  624. "deleted": 0,
  625. "title": "Name",
  626. "displayName": "Name",
  627. "dataType": "text"
  628. },
  629. {
  630. "formula": "",
  631. "key": false,
  632. "label": true,
  633. "readOnly": false,
  634. "required": false,
  635. "hidden": false,
  636. "deleted": 0,
  637. "title": "Expenditure",
  638. "displayName": "Expenditure",
  639. "dataType": "text"
  640. },
  641. {
  642. "formula": "",
  643. "key": false,
  644. "label": false,
  645. "readOnly": false,
  646. "required": false,
  647. "hidden": false,
  648. "deleted": 0,
  649. "title": "Salary",
  650. "displayName": "Salary",
  651. "dataType": "text"
  652. },
  653. {
  654. "formula": "",
  655. "key": false,
  656. "label": false,
  657. "readOnly": false,
  658. "required": false,
  659. "hidden": false,
  660. "deleted": 0,
  661. "title": "Department",
  662. "displayName": "Department",
  663. "dataType": "text"
  664. }
  665. ],
  666. "updatedon": 1573543641
  667. }
  668. ]
  669. }
  670. ],
  671. "language": {
  672. "completed": "Completed",
  673. "APPSHEET_PRO_TO_START": "To Start",
  674. "test_app_sheet": "My App Sheet",
  675. "APPSHEET_PRO_PARTIALLY_DONE": "Partially Done",
  676. "APPSHEET_PRO_HALF_COMPLETED": "Half Completed",
  677. "APPSHEET_PRO_ALMOST_DONE": "Almost Done"
  678. }
  679. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!