API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Oct 18th, 2018
77
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 213.23 KB | None | 0 0
raw download clone embed print report
  1. {
  2. "actionsCount" : 134,
  3. "allActions" : [ {
  4. "description" : "Add a number to values in a column",
  5. "name" : "Add",
  6. "deprecatedNames" : [ ],
  7. "request" : {
  8. "jsonSchema" : {
  9. "type" : "object",
  10. "properties" : {
  11. "action" : {
  12. "type" : "string",
  13. "minLength" : 1
  14. },
  15. "table" : {
  16. "type" : "string",
  17. "minLength" : 1
  18. },
  19. "col" : {
  20. "type" : "string",
  21. "minLength" : 1
  22. },
  23. "number" : {
  24. "type" : "number"
  25. },
  26. "precision" : {
  27. "type" : "number"
  28. },
  29. "newcolumn" : {
  30. "type" : "string",
  31. "minLength" : 1
  32. }
  33. },
  34. "id" : "#addaction",
  35. "additionalProperties" : false,
  36. "title" : "Add action",
  37. "required" : [ "action", "table", "col", "number" ]
  38. },
  39. "jsonExample" : "not implemented yet"
  40. },
  41. "deprecatedRequests" : [ ]
  42. }, {
  43. "description" : "Add fields to a new column according to the index column",
  44. "name" : "AddDataCategoryColumn",
  45. "deprecatedNames" : [ ],
  46. "request" : {
  47. "jsonSchema" : {
  48. "type" : "object",
  49. "properties" : {
  50. "action" : {
  51. "type" : "string",
  52. "minLength" : 1
  53. },
  54. "table" : {
  55. "type" : "string",
  56. "minLength" : 1
  57. },
  58. "data_category_mapping" : {
  59. "type" : "array",
  60. "items" : {
  61. "$ref" : "#/definitions/datacategoryfields"
  62. }
  63. },
  64. "newcolumn" : {
  65. "type" : "string",
  66. "minLength" : 1
  67. }
  68. },
  69. "id" : "#adddatacategorycolumnaction",
  70. "additionalProperties" : false,
  71. "title" : "Add data category column action",
  72. "required" : [ "action", "table", "data_category_mapping" ],
  73. "definitions" : {
  74. "datacategoryfields" : {
  75. "type" : "object",
  76. "properties" : {
  77. "index_col" : {
  78. "type" : "number"
  79. },
  80. "column_value" : {
  81. "type" : "string",
  82. "minLength" : 1
  83. }
  84. },
  85. "id" : "#datacategoryfields",
  86. "additionalProperties" : false,
  87. "title" : "Data category fields",
  88. "required" : [ "index_col", "column_value" ]
  89. }
  90. }
  91. },
  92. "jsonExample" : "not implemented yet"
  93. },
  94. "deprecatedRequests" : [ ]
  95. }, {
  96. "description" : "Add some time/days to values in a date column",
  97. "name" : "AddDays",
  98. "deprecatedNames" : [ ],
  99. "request" : {
  100. "jsonSchema" : {
  101. "type" : "object",
  102. "properties" : {
  103. "action" : {
  104. "type" : "string",
  105. "minLength" : 1
  106. },
  107. "table" : {
  108. "type" : "string",
  109. "minLength" : 1
  110. },
  111. "col" : {
  112. "type" : "string",
  113. "minLength" : 1
  114. },
  115. "valueToAdd" : {
  116. "type" : "number"
  117. },
  118. "columnToAdd" : {
  119. "type" : "string",
  120. "minLength" : 1
  121. },
  122. "addType" : {
  123. "$ref" : "#/definitions/datetype"
  124. },
  125. "add_or_subtract" : {
  126. "type" : "string",
  127. "minLength" : 1
  128. },
  129. "newcolumn" : {
  130. "type" : "string",
  131. "minLength" : 1
  132. }
  133. },
  134. "id" : "#adddaysaction",
  135. "additionalProperties" : false,
  136. "title" : "Add days action",
  137. "required" : [ "action", "table", "col", "addType" ],
  138. "definitions" : {
  139. "datetype" : {
  140. "anyOf" : [ {
  141. "$ref" : "#/definitions/daytype"
  142. }, {
  143. "$ref" : "#/definitions/hourtype"
  144. }, {
  145. "$ref" : "#/definitions/minutetype"
  146. }, {
  147. "$ref" : "#/definitions/monthtype"
  148. }, {
  149. "$ref" : "#/definitions/secondtype"
  150. }, {
  151. "$ref" : "#/definitions/weektype"
  152. }, {
  153. "$ref" : "#/definitions/yeartype"
  154. } ]
  155. },
  156. "daytype" : {
  157. "type" : "string",
  158. "minLength" : 1,
  159. "enum" : [ "day" ]
  160. },
  161. "hourtype" : {
  162. "type" : "string",
  163. "minLength" : 1,
  164. "enum" : [ "hour" ]
  165. },
  166. "minutetype" : {
  167. "type" : "string",
  168. "minLength" : 1,
  169. "enum" : [ "minute" ]
  170. },
  171. "monthtype" : {
  172. "type" : "string",
  173. "minLength" : 1,
  174. "enum" : [ "month" ]
  175. },
  176. "secondtype" : {
  177. "type" : "string",
  178. "minLength" : 1,
  179. "enum" : [ "second" ]
  180. },
  181. "weektype" : {
  182. "type" : "string",
  183. "minLength" : 1,
  184. "enum" : [ "week" ]
  185. },
  186. "yeartype" : {
  187. "type" : "string",
  188. "minLength" : 1,
  189. "enum" : [ "year" ]
  190. }
  191. }
  192. },
  193. "jsonExample" : "not implemented yet"
  194. },
  195. "deprecatedRequests" : [ ]
  196. }, {
  197. "description" : "Add a duplicate column",
  198. "name" : "AddDuplicateColumn",
  199. "deprecatedNames" : [ ],
  200. "request" : {
  201. "jsonSchema" : {
  202. "type" : "object",
  203. "properties" : {
  204. "action" : {
  205. "type" : "string",
  206. "minLength" : 1
  207. },
  208. "table" : {
  209. "type" : "string",
  210. "minLength" : 1
  211. },
  212. "col" : {
  213. "type" : "string",
  214. "minLength" : 1
  215. },
  216. "newcolumn" : {
  217. "type" : "string",
  218. "minLength" : 1
  219. }
  220. },
  221. "id" : "#addduplicatecolumnaction",
  222. "additionalProperties" : false,
  223. "title" : "Add duplicate column action",
  224. "required" : [ "action", "table", "col" ]
  225. },
  226. "jsonExample" : "not implemented yet"
  227. },
  228. "deprecatedRequests" : [ ]
  229. }, {
  230. "description" : "Add a system column that contains a monotonically increasing sequence 1, 2, 3, etc",
  231. "name" : "AddIndexColumn",
  232. "deprecatedNames" : [ ],
  233. "request" : {
  234. "jsonSchema" : {
  235. "type" : "object",
  236. "properties" : {
  237. "action" : {
  238. "type" : "string",
  239. "minLength" : 1
  240. },
  241. "table" : {
  242. "type" : "string",
  243. "minLength" : 1
  244. },
  245. "newcolumn" : {
  246. "type" : "string",
  247. "minLength" : 1
  248. }
  249. },
  250. "id" : "#addindexcolumnaction",
  251. "additionalProperties" : false,
  252. "title" : "Add index column action",
  253. "required" : [ "action", "table" ]
  254. },
  255. "jsonExample" : "not implemented yet"
  256. },
  257. "deprecatedRequests" : [ ]
  258. }, {
  259. "description" : "Add prefix to a column",
  260. "name" : "AddPrefix",
  261. "deprecatedNames" : [ ],
  262. "request" : {
  263. "jsonSchema" : {
  264. "type" : "object",
  265. "properties" : {
  266. "action" : {
  267. "type" : "string",
  268. "minLength" : 1
  269. },
  270. "table" : {
  271. "type" : "string",
  272. "minLength" : 1
  273. },
  274. "col" : {
  275. "type" : "string",
  276. "minLength" : 1
  277. },
  278. "prefix" : {
  279. "type" : "string",
  280. "minLength" : 1
  281. }
  282. },
  283. "id" : "#addprefixaction",
  284. "additionalProperties" : false,
  285. "title" : "Add prefix action",
  286. "required" : [ "action", "table", "col", "prefix" ]
  287. },
  288. "jsonExample" : "not implemented yet"
  289. },
  290. "deprecatedRequests" : [ ]
  291. }, {
  292. "description" : "Add rows to a table",
  293. "name" : "AddRowsToTable",
  294. "deprecatedNames" : [ ],
  295. "request" : {
  296. "jsonSchema" : {
  297. "type" : "object",
  298. "properties" : {
  299. "action" : {
  300. "type" : "string",
  301. "minLength" : 1
  302. },
  303. "rows" : {
  304. "type" : "array",
  305. "items" : {
  306. "type" : "array",
  307. "items" : {
  308. "type" : "string",
  309. "minLength" : 1
  310. }
  311. }
  312. },
  313. "table" : {
  314. "type" : "string",
  315. "minLength" : 1
  316. }
  317. },
  318. "id" : "#addrowstotableaction",
  319. "additionalProperties" : false,
  320. "title" : "Add rows to table action",
  321. "required" : [ "action", "rows", "table" ]
  322. },
  323. "jsonExample" : "not implemented yet"
  324. },
  325. "deprecatedRequests" : [ ]
  326. }, {
  327. "description" : "Add suffix to a column",
  328. "name" : "AddSuffix",
  329. "deprecatedNames" : [ ],
  330. "request" : {
  331. "jsonSchema" : {
  332. "type" : "object",
  333. "properties" : {
  334. "action" : {
  335. "type" : "string",
  336. "minLength" : 1
  337. },
  338. "table" : {
  339. "type" : "string",
  340. "minLength" : 1
  341. },
  342. "col" : {
  343. "type" : "string",
  344. "minLength" : 1
  345. },
  346. "suffix" : {
  347. "type" : "string",
  348. "minLength" : 1
  349. }
  350. },
  351. "id" : "#addsuffixaction",
  352. "additionalProperties" : false,
  353. "title" : "Add suffix action",
  354. "required" : [ "action", "table", "col", "suffix" ]
  355. },
  356. "jsonExample" : "not implemented yet"
  357. },
  358. "deprecatedRequests" : [ ]
  359. }, {
  360. "description" : "Change date format",
  361. "name" : "AlterFormatOfDate",
  362. "deprecatedNames" : [ ],
  363. "request" : {
  364. "jsonSchema" : {
  365. "type" : "object",
  366. "properties" : {
  367. "action" : {
  368. "type" : "string",
  369. "minLength" : 1
  370. },
  371. "table" : {
  372. "type" : "string",
  373. "minLength" : 1
  374. },
  375. "col" : {
  376. "type" : "string",
  377. "minLength" : 1
  378. },
  379. "dateExpression" : {
  380. "type" : "string",
  381. "minLength" : 1
  382. }
  383. },
  384. "id" : "#alterformatofdateaction",
  385. "additionalProperties" : false,
  386. "title" : "Alter format of date action",
  387. "required" : [ "action", "table", "col", "dateExpression" ]
  388. },
  389. "jsonExample" : "not implemented yet"
  390. },
  391. "deprecatedRequests" : [ ]
  392. }, {
  393. "description" : "Append rows from several tables into one",
  394. "name" : "AppendTables",
  395. "deprecatedNames" : [ ],
  396. "request" : {
  397. "jsonSchema" : {
  398. "type" : "object",
  399. "properties" : {
  400. "action" : {
  401. "type" : "string",
  402. "minLength" : 1
  403. },
  404. "primaryTable" : {
  405. "type" : "string",
  406. "minLength" : 1
  407. },
  408. "tablesToAppend" : {
  409. "type" : "array",
  410. "items" : {
  411. "type" : "string",
  412. "minLength" : 1
  413. }
  414. }
  415. },
  416. "id" : "#appendtablesaction",
  417. "additionalProperties" : false,
  418. "title" : "Append tables action",
  419. "required" : [ "action", "primaryTable", "tablesToAppend" ]
  420. },
  421. "jsonExample" : "not implemented yet"
  422. },
  423. "deprecatedRequests" : [ ]
  424. }, {
  425. "description" : "As the result of FindDifference you will have a table with the diff, you can apply this diff using this job",
  426. "name" : "ApplyDiff",
  427. "deprecatedNames" : [ ],
  428. "request" : {
  429. "jsonSchema" : {
  430. "type" : "object",
  431. "properties" : {
  432. "action" : {
  433. "type" : "string",
  434. "minLength" : 1
  435. },
  436. "primaryKeys" : {
  437. "type" : "array",
  438. "items" : {
  439. "type" : "string",
  440. "minLength" : 1
  441. }
  442. },
  443. "patchTable" : {
  444. "type" : "string",
  445. "minLength" : 1
  446. },
  447. "table" : {
  448. "type" : "string",
  449. "minLength" : 1
  450. }
  451. },
  452. "id" : "#applydiffaction",
  453. "additionalProperties" : false,
  454. "title" : "Apply diff action",
  455. "required" : [ "action", "primaryKeys", "patchTable", "table" ]
  456. },
  457. "jsonExample" : "not implemented yet"
  458. },
  459. "deprecatedRequests" : [ ]
  460. }, {
  461. "description" : "Return the average of the values in a group",
  462. "name" : "Average",
  463. "deprecatedNames" : [ ],
  464. "request" : {
  465. "jsonSchema" : {
  466. "type" : "object",
  467. "properties" : {
  468. "action" : {
  469. "type" : "string",
  470. "minLength" : 1
  471. },
  472. "table" : {
  473. "type" : "string",
  474. "minLength" : 1
  475. },
  476. "col" : {
  477. "type" : "string",
  478. "minLength" : 1
  479. }
  480. },
  481. "id" : "#averageaction",
  482. "additionalProperties" : false,
  483. "title" : "Average action",
  484. "required" : [ "action", "table", "col" ]
  485. },
  486. "jsonExample" : "not implemented yet"
  487. },
  488. "deprecatedRequests" : [ ]
  489. }, {
  490. "description" : "Capitalize strings in a column",
  491. "name" : "Capitalize",
  492. "deprecatedNames" : [ ],
  493. "request" : {
  494. "jsonSchema" : {
  495. "type" : "object",
  496. "properties" : {
  497. "action" : {
  498. "type" : "string",
  499. "minLength" : 1
  500. },
  501. "table" : {
  502. "type" : "string",
  503. "minLength" : 1
  504. },
  505. "col" : {
  506. "type" : "string",
  507. "minLength" : 1
  508. }
  509. },
  510. "id" : "#capitalizeaction",
  511. "additionalProperties" : false,
  512. "title" : "Capitalize action",
  513. "required" : [ "action", "table", "col" ]
  514. },
  515. "jsonExample" : "not implemented yet"
  516. },
  517. "deprecatedRequests" : [ ]
  518. }, {
  519. "description" : "Computes the ceiling of the given column",
  520. "name" : "Ceil",
  521. "deprecatedNames" : [ ],
  522. "request" : {
  523. "jsonSchema" : {
  524. "type" : "object",
  525. "properties" : {
  526. "action" : {
  527. "type" : "string",
  528. "minLength" : 1
  529. },
  530. "table" : {
  531. "type" : "string",
  532. "minLength" : 1
  533. },
  534. "col" : {
  535. "type" : "string",
  536. "minLength" : 1
  537. },
  538. "newcolumn" : {
  539. "type" : "string",
  540. "minLength" : 1
  541. }
  542. },
  543. "id" : "#ceilaction",
  544. "additionalProperties" : false,
  545. "title" : "Ceil action",
  546. "required" : [ "action", "table", "col" ]
  547. },
  548. "jsonExample" : "not implemented yet"
  549. },
  550. "deprecatedRequests" : [ ]
  551. }, {
  552. "description" : "Check columns for null values",
  553. "name" : "CheckForNulls",
  554. "deprecatedNames" : [ ],
  555. "request" : {
  556. "jsonSchema" : {
  557. "type" : "object",
  558. "properties" : {
  559. "action" : {
  560. "type" : "string",
  561. "minLength" : 1
  562. },
  563. "table" : {
  564. "type" : "string",
  565. "minLength" : 1
  566. },
  567. "columns" : {
  568. "type" : "array",
  569. "items" : {
  570. "type" : "string",
  571. "minLength" : 1
  572. }
  573. }
  574. },
  575. "id" : "#checkfornullsaction",
  576. "additionalProperties" : false,
  577. "title" : "Check for nulls action",
  578. "required" : [ "action", "table", "columns" ]
  579. },
  580. "jsonExample" : "not implemented yet"
  581. },
  582. "deprecatedRequests" : [ ]
  583. }, {
  584. "description" : "Check for duplicates",
  585. "name" : "CheckUnique",
  586. "deprecatedNames" : [ ],
  587. "request" : {
  588. "jsonSchema" : {
  589. "type" : "object",
  590. "properties" : {
  591. "action" : {
  592. "type" : "string",
  593. "minLength" : 1
  594. },
  595. "table" : {
  596. "type" : "string",
  597. "minLength" : 1
  598. },
  599. "columns" : {
  600. "type" : "array",
  601. "items" : {
  602. "type" : "string",
  603. "minLength" : 1
  604. }
  605. },
  606. "duplicateColName" : {
  607. "type" : "string",
  608. "minLength" : 1
  609. }
  610. },
  611. "id" : "#checkuniqueaction",
  612. "additionalProperties" : false,
  613. "title" : "Check unique action",
  614. "required" : [ "action", "table", "columns" ]
  615. },
  616. "jsonExample" : "not implemented yet"
  617. },
  618. "deprecatedRequests" : [ ]
  619. }, {
  620. "description" : "Remove all non-ascii characters from input string",
  621. "name" : "Clean",
  622. "deprecatedNames" : [ ],
  623. "request" : {
  624. "jsonSchema" : {
  625. "type" : "object",
  626. "properties" : {
  627. "action" : {
  628. "type" : "string",
  629. "minLength" : 1
  630. },
  631. "table" : {
  632. "type" : "string",
  633. "minLength" : 1
  634. },
  635. "col" : {
  636. "type" : "string",
  637. "minLength" : 1
  638. }
  639. },
  640. "id" : "#cleanaction",
  641. "additionalProperties" : false,
  642. "title" : "Clean action",
  643. "required" : [ "action", "table", "col" ]
  644. },
  645. "jsonExample" : "not implemented yet"
  646. },
  647. "deprecatedRequests" : [ ]
  648. }, {
  649. "description" : "Return table from spark. Can be used to clone table",
  650. "name" : "CloneFile",
  651. "deprecatedNames" : [ ],
  652. "request" : {
  653. "jsonSchema" : {
  654. "type" : "object",
  655. "properties" : {
  656. "action" : {
  657. "type" : "string",
  658. "minLength" : 1
  659. },
  660. "table" : {
  661. "type" : "string",
  662. "minLength" : 1
  663. }
  664. },
  665. "id" : "#clonefileaction",
  666. "additionalProperties" : false,
  667. "title" : "Clone file action",
  668. "required" : [ "action", "table" ]
  669. },
  670. "jsonExample" : "not implemented yet"
  671. },
  672. "deprecatedRequests" : [ ]
  673. }, {
  674. "description" : "Convert a string with Base64 to a string with 0/1. E.g. 'TWFu' => '010011010110000101101110'",
  675. "name" : "ConvertBase64ToBinary",
  676. "deprecatedNames" : [ ],
  677. "request" : {
  678. "jsonSchema" : {
  679. "type" : "object",
  680. "properties" : {
  681. "action" : {
  682. "type" : "string",
  683. "minLength" : 1
  684. },
  685. "table" : {
  686. "type" : "string",
  687. "minLength" : 1
  688. },
  689. "col" : {
  690. "type" : "string",
  691. "minLength" : 1
  692. }
  693. },
  694. "id" : "#convertbase64tobinaryaction",
  695. "additionalProperties" : false,
  696. "title" : "Convert base64 to binary action",
  697. "required" : [ "action", "table", "col" ]
  698. },
  699. "jsonExample" : "not implemented yet"
  700. },
  701. "deprecatedRequests" : [ ]
  702. }, {
  703. "description" : "Converts financial format",
  704. "name" : "ConvertFinancialFormat",
  705. "deprecatedNames" : [ ],
  706. "request" : {
  707. "jsonSchema" : {
  708. "type" : "object",
  709. "properties" : {
  710. "action" : {
  711. "type" : "string",
  712. "minLength" : 1
  713. },
  714. "table" : {
  715. "type" : "string",
  716. "minLength" : 1
  717. },
  718. "from" : {
  719. "$ref" : "#/definitions/financialformat"
  720. },
  721. "to" : {
  722. "$ref" : "#/definitions/financialformat"
  723. }
  724. },
  725. "id" : "#convertfinancialformataction",
  726. "additionalProperties" : false,
  727. "title" : "Convert financial format action",
  728. "required" : [ "action", "table", "from", "to" ],
  729. "definitions" : {
  730. "allpositive2columns" : {
  731. "type" : "object",
  732. "properties" : {
  733. "debitCol" : {
  734. "type" : "string",
  735. "minLength" : 1
  736. },
  737. "creditCol" : {
  738. "type" : "string",
  739. "minLength" : 1
  740. },
  741. "formatType" : {
  742. "type" : "string",
  743. "minLength" : 1,
  744. "enum" : [ "AllPositive2Columns" ]
  745. }
  746. },
  747. "id" : "#allpositive2columns",
  748. "additionalProperties" : false,
  749. "title" : "All positive2 columns",
  750. "required" : [ "debitCol", "creditCol", "formatType" ]
  751. },
  752. "financialformat" : {
  753. "anyOf" : [ {
  754. "$ref" : "#/definitions/allpositive2columns"
  755. }, {
  756. "$ref" : "#/definitions/posdebitnegcredit1column"
  757. }, {
  758. "$ref" : "#/definitions/posdebitposcreditinbrackets1column"
  759. } ]
  760. },
  761. "posdebitnegcredit1column" : {
  762. "type" : "object",
  763. "properties" : {
  764. "colName" : {
  765. "type" : "string",
  766. "minLength" : 1
  767. },
  768. "formatType" : {
  769. "type" : "string",
  770. "minLength" : 1,
  771. "enum" : [ "PosDebitNegCredit1Column" ]
  772. }
  773. },
  774. "id" : "#posdebitnegcredit1column",
  775. "additionalProperties" : false,
  776. "title" : "Pos debit neg credit1 column",
  777. "required" : [ "colName", "formatType" ]
  778. },
  779. "posdebitposcreditinbrackets1column" : {
  780. "type" : "object",
  781. "properties" : {
  782. "colName" : {
  783. "type" : "string",
  784. "minLength" : 1
  785. },
  786. "formatType" : {
  787. "type" : "string",
  788. "minLength" : 1,
  789. "enum" : [ "PosDebitPosCreditInBrackets1Column" ]
  790. }
  791. },
  792. "id" : "#posdebitposcreditinbrackets1column",
  793. "additionalProperties" : false,
  794. "title" : "Pos debit pos credit in brackets1 column",
  795. "required" : [ "colName", "formatType" ]
  796. }
  797. }
  798. },
  799. "jsonExample" : "not implemented yet"
  800. },
  801. "deprecatedRequests" : [ ]
  802. }, {
  803. "description" : "Convert values in a string column to Boolean",
  804. "name" : "ConvertToBoolean",
  805. "deprecatedNames" : [ ],
  806. "request" : {
  807. "jsonSchema" : {
  808. "type" : "object",
  809. "properties" : {
  810. "action" : {
  811. "type" : "string",
  812. "minLength" : 1
  813. },
  814. "table" : {
  815. "type" : "string",
  816. "minLength" : 1
  817. },
  818. "col" : {
  819. "type" : "string",
  820. "minLength" : 1
  821. },
  822. "newColumn" : {
  823. "type" : "string",
  824. "minLength" : 1
  825. },
  826. "default" : {
  827. "type" : "boolean"
  828. }
  829. },
  830. "id" : "#converttobooleanaction",
  831. "additionalProperties" : false,
  832. "title" : "Convert to boolean action",
  833. "required" : [ "action", "table", "col" ]
  834. },
  835. "jsonExample" : "not implemented yet"
  836. },
  837. "deprecatedRequests" : [ ]
  838. }, {
  839. "description" : "Convert values in a string column to Date using dateExpression",
  840. "name" : "ConvertToDate",
  841. "deprecatedNames" : [ ],
  842. "request" : {
  843. "jsonSchema" : {
  844. "type" : "object",
  845. "properties" : {
  846. "action" : {
  847. "type" : "string",
  848. "minLength" : 1
  849. },
  850. "table" : {
  851. "type" : "string",
  852. "minLength" : 1
  853. },
  854. "col" : {
  855. "type" : "string",
  856. "minLength" : 1
  857. },
  858. "dateExpression" : {
  859. "type" : "string",
  860. "minLength" : 1
  861. },
  862. "convert_null_values" : {
  863. "type" : "boolean"
  864. },
  865. "newcolumn" : {
  866. "type" : "string",
  867. "minLength" : 1
  868. },
  869. "default" : {
  870. "type" : "string",
  871. "minLength" : 1
  872. }
  873. },
  874. "id" : "#converttodateaction",
  875. "additionalProperties" : false,
  876. "title" : "Convert to date action",
  877. "required" : [ "action", "table", "col", "dateExpression" ]
  878. },
  879. "jsonExample" : "not implemented yet"
  880. },
  881. "deprecatedRequests" : [ ]
  882. }, {
  883. "description" : "not implemented yet",
  884. "name" : "ConvertToDecimal",
  885. "deprecatedNames" : [ ],
  886. "request" : {
  887. "jsonSchema" : {
  888. "type" : "object",
  889. "properties" : {
  890. "action" : {
  891. "type" : "string",
  892. "minLength" : 1
  893. },
  894. "table" : {
  895. "type" : "string",
  896. "minLength" : 1
  897. },
  898. "col" : {
  899. "type" : "string",
  900. "minLength" : 1
  901. },
  902. "convert_null_values" : {
  903. "type" : "boolean"
  904. },
  905. "newcolumn" : {
  906. "type" : "string",
  907. "minLength" : 1
  908. },
  909. "default" : {
  910. "type" : "number"
  911. }
  912. },
  913. "id" : "#converttodecimalaction",
  914. "additionalProperties" : false,
  915. "title" : "Convert to decimal action",
  916. "required" : [ "action", "table", "col" ]
  917. },
  918. "jsonExample" : "not implemented yet"
  919. },
  920. "deprecatedRequests" : [ ]
  921. }, {
  922. "description" : "Convert an existing column to Decimal with changing column type",
  923. "name" : "ConvertToDecimalAggregated",
  924. "deprecatedNames" : [ ],
  925. "request" : {
  926. "jsonSchema" : {
  927. "type" : "object",
  928. "properties" : {
  929. "action" : {
  930. "type" : "string",
  931. "minLength" : 1
  932. },
  933. "table" : {
  934. "type" : "string",
  935. "minLength" : 1
  936. },
  937. "col" : {
  938. "type" : "string",
  939. "minLength" : 1
  940. },
  941. "convert_null_values" : {
  942. "type" : "boolean"
  943. },
  944. "showSeparator" : {
  945. "type" : "boolean"
  946. },
  947. "precision" : {
  948. "type" : "number"
  949. },
  950. "newcolumn" : {
  951. "type" : "string",
  952. "minLength" : 1
  953. },
  954. "default" : {
  955. "type" : "number"
  956. }
  957. },
  958. "id" : "#converttodecimalaggregatedaction",
  959. "additionalProperties" : false,
  960. "title" : "Convert to decimal aggregated action",
  961. "required" : [ "action", "table", "col", "showSeparator", "precision" ]
  962. },
  963. "jsonExample" : "not implemented yet"
  964. },
  965. "deprecatedRequests" : [ ]
  966. }, {
  967. "description" : "not implemented yet",
  968. "name" : "ConvertToText",
  969. "deprecatedNames" : [ ],
  970. "request" : {
  971. "jsonSchema" : {
  972. "type" : "object",
  973. "properties" : {
  974. "action" : {
  975. "type" : "string",
  976. "minLength" : 1
  977. },
  978. "table" : {
  979. "type" : "string",
  980. "minLength" : 1
  981. },
  982. "col" : {
  983. "type" : "string",
  984. "minLength" : 1
  985. },
  986. "convert_null_values" : {
  987. "type" : "boolean"
  988. },
  989. "newcolumn" : {
  990. "type" : "string",
  991. "minLength" : 1
  992. },
  993. "default" : {
  994. "type" : "string",
  995. "minLength" : 1
  996. }
  997. },
  998. "id" : "#converttotextaction",
  999. "additionalProperties" : false,
  1000. "title" : "Convert to text action",
  1001. "required" : [ "action", "table", "col" ]
  1002. },
  1003. "jsonExample" : "not implemented yet"
  1004. },
  1005. "deprecatedRequests" : [ ]
  1006. }, {
  1007. "description" : "Convert values to whole numbers",
  1008. "name" : "ConvertToWholeNumber",
  1009. "deprecatedNames" : [ ],
  1010. "request" : {
  1011. "jsonSchema" : {
  1012. "type" : "object",
  1013. "properties" : {
  1014. "action" : {
  1015. "type" : "string",
  1016. "minLength" : 1
  1017. },
  1018. "table" : {
  1019. "type" : "string",
  1020. "minLength" : 1
  1021. },
  1022. "col" : {
  1023. "type" : "string",
  1024. "minLength" : 1
  1025. },
  1026. "convert_null_values" : {
  1027. "type" : "boolean"
  1028. },
  1029. "newcolumn" : {
  1030. "type" : "string",
  1031. "minLength" : 1
  1032. },
  1033. "default" : {
  1034. "type" : "number"
  1035. }
  1036. },
  1037. "id" : "#converttowholenumberaction",
  1038. "additionalProperties" : false,
  1039. "title" : "Convert to whole number action",
  1040. "required" : [ "action", "table", "col" ]
  1041. },
  1042. "jsonExample" : "not implemented yet"
  1043. },
  1044. "deprecatedRequests" : [ ]
  1045. }, {
  1046. "description" : "Return count of rows",
  1047. "name" : "Count",
  1048. "deprecatedNames" : [ ],
  1049. "request" : {
  1050. "jsonSchema" : {
  1051. "type" : "object",
  1052. "properties" : {
  1053. "action" : {
  1054. "type" : "string",
  1055. "minLength" : 1
  1056. },
  1057. "table" : {
  1058. "type" : "string",
  1059. "minLength" : 1
  1060. },
  1061. "col" : {
  1062. "type" : "string",
  1063. "minLength" : 1
  1064. }
  1065. },
  1066. "id" : "#countaction",
  1067. "additionalProperties" : false,
  1068. "title" : "Count action",
  1069. "required" : [ "action", "table", "col" ]
  1070. },
  1071. "jsonExample" : "not implemented yet"
  1072. },
  1073. "deprecatedRequests" : [ ]
  1074. }, {
  1075. "description" : "Count distinct rows",
  1076. "name" : "CountDistinct",
  1077. "deprecatedNames" : [ ],
  1078. "request" : {
  1079. "jsonSchema" : {
  1080. "type" : "object",
  1081. "properties" : {
  1082. "action" : {
  1083. "type" : "string",
  1084. "minLength" : 1
  1085. },
  1086. "table" : {
  1087. "type" : "string",
  1088. "minLength" : 1
  1089. },
  1090. "col" : {
  1091. "type" : "string",
  1092. "minLength" : 1
  1093. }
  1094. },
  1095. "id" : "#countdistinctaction",
  1096. "additionalProperties" : false,
  1097. "title" : "Count distinct action",
  1098. "required" : [ "action", "table", "col" ]
  1099. },
  1100. "jsonExample" : "not implemented yet"
  1101. },
  1102. "deprecatedRequests" : [ ]
  1103. }, {
  1104. "description" : "not implemented yet",
  1105. "name" : "CountRows",
  1106. "deprecatedNames" : [ ],
  1107. "request" : {
  1108. "jsonSchema" : {
  1109. "type" : "object",
  1110. "properties" : {
  1111. "action" : {
  1112. "type" : "string",
  1113. "minLength" : 1
  1114. },
  1115. "table" : {
  1116. "type" : "string",
  1117. "minLength" : 1
  1118. }
  1119. },
  1120. "id" : "#countrowsaction",
  1121. "additionalProperties" : false,
  1122. "title" : "Count rows action",
  1123. "required" : [ "action", "table" ]
  1124. },
  1125. "jsonExample" : "not implemented yet"
  1126. },
  1127. "deprecatedRequests" : [ ]
  1128. }, {
  1129. "description" : "Create an empty table according to column names and types specified in the request",
  1130. "name" : "CreateEmptyDataFrame",
  1131. "deprecatedNames" : [ ],
  1132. "request" : {
  1133. "jsonSchema" : {
  1134. "type" : "object",
  1135. "properties" : {
  1136. "action" : {
  1137. "type" : "string",
  1138. "minLength" : 1
  1139. },
  1140. "schemaHolder" : {
  1141. "$ref" : "#/definitions/schemaholder"
  1142. }
  1143. },
  1144. "id" : "#createemptydataframerequest",
  1145. "additionalProperties" : false,
  1146. "title" : "Create empty data frame request",
  1147. "required" : [ "action", "schemaHolder" ],
  1148. "definitions" : {
  1149. "acceptabletype" : {
  1150. "anyOf" : [ {
  1151. "$ref" : "#/definitions/tauto"
  1152. }, {
  1153. "$ref" : "#/definitions/tboolean"
  1154. }, {
  1155. "$ref" : "#/definitions/tdate"
  1156. }, {
  1157. "$ref" : "#/definitions/tdatewithformat"
  1158. }, {
  1159. "$ref" : "#/definitions/tdouble"
  1160. }, {
  1161. "$ref" : "#/definitions/tlong"
  1162. }, {
  1163. "$ref" : "#/definitions/tnull"
  1164. }, {
  1165. "$ref" : "#/definitions/tstring"
  1166. } ]
  1167. },
  1168. "dataframefield" : {
  1169. "type" : "object",
  1170. "properties" : {
  1171. "col" : {
  1172. "type" : "string",
  1173. "minLength" : 1
  1174. },
  1175. "fieldType" : {
  1176. "$ref" : "#/definitions/acceptabletype"
  1177. }
  1178. },
  1179. "id" : "#dataframefield",
  1180. "additionalProperties" : false,
  1181. "title" : "Data frame field",
  1182. "required" : [ "col", "fieldType" ]
  1183. },
  1184. "fieldsbased" : {
  1185. "type" : "object",
  1186. "properties" : {
  1187. "fields" : {
  1188. "type" : "array",
  1189. "items" : {
  1190. "$ref" : "#/definitions/dataframefield"
  1191. }
  1192. },
  1193. "type" : {
  1194. "enum" : [ "FieldsBased" ],
  1195. "type" : "string"
  1196. }
  1197. },
  1198. "id" : "#fieldsbased",
  1199. "additionalProperties" : false,
  1200. "title" : "Fields based",
  1201. "required" : [ "fields", "type" ]
  1202. },
  1203. "filebased" : {
  1204. "type" : "object",
  1205. "properties" : {
  1206. "file" : {
  1207. "$ref" : "#/definitions/filerequest"
  1208. },
  1209. "type" : {
  1210. "enum" : [ "FileBased" ],
  1211. "type" : "string"
  1212. }
  1213. },
  1214. "id" : "#filebased",
  1215. "additionalProperties" : false,
  1216. "title" : "File based",
  1217. "required" : [ "file", "type" ]
  1218. },
  1219. "filerequest" : {
  1220. "type" : "object",
  1221. "properties" : {
  1222. "file" : {
  1223. "type" : "string",
  1224. "minLength" : 1
  1225. },
  1226. "storage" : {
  1227. "type" : "string",
  1228. "minLength" : 1
  1229. }
  1230. },
  1231. "id" : "#filerequest",
  1232. "additionalProperties" : false,
  1233. "title" : "File request",
  1234. "required" : [ "file", "storage" ]
  1235. },
  1236. "schemaholder" : {
  1237. "anyOf" : [ {
  1238. "$ref" : "#/definitions/fieldsbased"
  1239. }, {
  1240. "$ref" : "#/definitions/filebased"
  1241. } ]
  1242. },
  1243. "tauto" : {
  1244. "type" : "string",
  1245. "minLength" : 1,
  1246. "enum" : [ "Auto" ]
  1247. },
  1248. "tboolean" : {
  1249. "type" : "string",
  1250. "minLength" : 1,
  1251. "enum" : [ "Boolean" ]
  1252. },
  1253. "tdate" : {
  1254. "type" : "string",
  1255. "minLength" : 1,
  1256. "enum" : [ "Date" ]
  1257. },
  1258. "tdatewithformat" : {
  1259. "type" : "object",
  1260. "properties" : {
  1261. "dateFormat" : {
  1262. "type" : "string",
  1263. "minLength" : 1
  1264. },
  1265. "type" : {
  1266. "enum" : [ "DateWithFormat" ],
  1267. "type" : "string"
  1268. }
  1269. },
  1270. "id" : "#tdatewithformat",
  1271. "additionalProperties" : false,
  1272. "title" : "T date with format",
  1273. "required" : [ "dateFormat", "type" ]
  1274. },
  1275. "tdouble" : {
  1276. "type" : "string",
  1277. "minLength" : 1,
  1278. "enum" : [ "Number" ]
  1279. },
  1280. "tlong" : {
  1281. "type" : "string",
  1282. "minLength" : 1,
  1283. "enum" : [ "Long" ]
  1284. },
  1285. "tnull" : {
  1286. "type" : "string",
  1287. "minLength" : 1,
  1288. "enum" : [ "Null" ]
  1289. },
  1290. "tstring" : {
  1291. "type" : "string",
  1292. "minLength" : 1,
  1293. "enum" : [ "String" ]
  1294. }
  1295. }
  1296. },
  1297. "jsonExample" : "not implemented yet"
  1298. },
  1299. "deprecatedRequests" : [ ]
  1300. }, {
  1301. "description" : "Create and save empty DataFrame",
  1302. "name" : "CreateEmptyDataFrameAndSaveToMemory",
  1303. "deprecatedNames" : [ ],
  1304. "request" : {
  1305. "jsonSchema" : {
  1306. "type" : "object",
  1307. "properties" : {
  1308. "action" : {
  1309. "type" : "string",
  1310. "minLength" : 1
  1311. },
  1312. "file" : {
  1313. "$ref" : "#/definitions/filerequest"
  1314. },
  1315. "fieldsMapping" : {
  1316. "type" : "array",
  1317. "items" : {
  1318. "$ref" : "#/definitions/dataframefield"
  1319. }
  1320. }
  1321. },
  1322. "id" : "#createandsaveemptydataframerequest",
  1323. "additionalProperties" : false,
  1324. "title" : "Create and save empty data frame request",
  1325. "required" : [ "action", "file", "fieldsMapping" ],
  1326. "definitions" : {
  1327. "acceptabletype" : {
  1328. "anyOf" : [ {
  1329. "$ref" : "#/definitions/tauto"
  1330. }, {
  1331. "$ref" : "#/definitions/tboolean"
  1332. }, {
  1333. "$ref" : "#/definitions/tdate"
  1334. }, {
  1335. "$ref" : "#/definitions/tdatewithformat"
  1336. }, {
  1337. "$ref" : "#/definitions/tdouble"
  1338. }, {
  1339. "$ref" : "#/definitions/tlong"
  1340. }, {
  1341. "$ref" : "#/definitions/tnull"
  1342. }, {
  1343. "$ref" : "#/definitions/tstring"
  1344. } ]
  1345. },
  1346. "dataframefield" : {
  1347. "type" : "object",
  1348. "properties" : {
  1349. "col" : {
  1350. "type" : "string",
  1351. "minLength" : 1
  1352. },
  1353. "fieldType" : {
  1354. "$ref" : "#/definitions/acceptabletype"
  1355. }
  1356. },
  1357. "id" : "#dataframefield",
  1358. "additionalProperties" : false,
  1359. "title" : "Data frame field",
  1360. "required" : [ "col", "fieldType" ]
  1361. },
  1362. "filerequest" : {
  1363. "type" : "object",
  1364. "properties" : {
  1365. "file" : {
  1366. "type" : "string",
  1367. "minLength" : 1
  1368. },
  1369. "storage" : {
  1370. "type" : "string",
  1371. "minLength" : 1
  1372. }
  1373. },
  1374. "id" : "#filerequest",
  1375. "additionalProperties" : false,
  1376. "title" : "File request",
  1377. "required" : [ "file", "storage" ]
  1378. },
  1379. "tauto" : {
  1380. "type" : "string",
  1381. "minLength" : 1,
  1382. "enum" : [ "Auto" ]
  1383. },
  1384. "tboolean" : {
  1385. "type" : "string",
  1386. "minLength" : 1,
  1387. "enum" : [ "Boolean" ]
  1388. },
  1389. "tdate" : {
  1390. "type" : "string",
  1391. "minLength" : 1,
  1392. "enum" : [ "Date" ]
  1393. },
  1394. "tdatewithformat" : {
  1395. "type" : "object",
  1396. "properties" : {
  1397. "dateFormat" : {
  1398. "type" : "string",
  1399. "minLength" : 1
  1400. },
  1401. "type" : {
  1402. "enum" : [ "DateWithFormat" ],
  1403. "type" : "string"
  1404. }
  1405. },
  1406. "id" : "#tdatewithformat",
  1407. "additionalProperties" : false,
  1408. "title" : "T date with format",
  1409. "required" : [ "dateFormat", "type" ]
  1410. },
  1411. "tdouble" : {
  1412. "type" : "string",
  1413. "minLength" : 1,
  1414. "enum" : [ "Number" ]
  1415. },
  1416. "tlong" : {
  1417. "type" : "string",
  1418. "minLength" : 1,
  1419. "enum" : [ "Long" ]
  1420. },
  1421. "tnull" : {
  1422. "type" : "string",
  1423. "minLength" : 1,
  1424. "enum" : [ "Null" ]
  1425. },
  1426. "tstring" : {
  1427. "type" : "string",
  1428. "minLength" : 1,
  1429. "enum" : [ "String" ]
  1430. }
  1431. }
  1432. },
  1433. "jsonExample" : "not implemented yet"
  1434. },
  1435. "deprecatedRequests" : [ {
  1436. "jsonSchema" : {
  1437. "type" : "object",
  1438. "properties" : {
  1439. "action" : {
  1440. "type" : "string",
  1441. "minLength" : 1
  1442. },
  1443. "store" : {
  1444. "type" : "string",
  1445. "minLength" : 1
  1446. },
  1447. "output_path" : {
  1448. "type" : "string",
  1449. "minLength" : 1
  1450. },
  1451. "file_name" : {
  1452. "type" : "string",
  1453. "minLength" : 1
  1454. },
  1455. "fieldsMapping" : {
  1456. "type" : "array",
  1457. "items" : {
  1458. "$ref" : "#/definitions/dataframefield"
  1459. }
  1460. }
  1461. },
  1462. "id" : "#createandsaveemptydataframerequestold",
  1463. "additionalProperties" : false,
  1464. "title" : "Create and save empty data frame request old",
  1465. "required" : [ "action", "store", "output_path", "file_name", "fieldsMapping" ],
  1466. "definitions" : {
  1467. "acceptabletype" : {
  1468. "anyOf" : [ {
  1469. "$ref" : "#/definitions/tauto"
  1470. }, {
  1471. "$ref" : "#/definitions/tboolean"
  1472. }, {
  1473. "$ref" : "#/definitions/tdate"
  1474. }, {
  1475. "$ref" : "#/definitions/tdatewithformat"
  1476. }, {
  1477. "$ref" : "#/definitions/tdouble"
  1478. }, {
  1479. "$ref" : "#/definitions/tlong"
  1480. }, {
  1481. "$ref" : "#/definitions/tnull"
  1482. }, {
  1483. "$ref" : "#/definitions/tstring"
  1484. } ]
  1485. },
  1486. "dataframefield" : {
  1487. "type" : "object",
  1488. "properties" : {
  1489. "col" : {
  1490. "type" : "string",
  1491. "minLength" : 1
  1492. },
  1493. "fieldType" : {
  1494. "$ref" : "#/definitions/acceptabletype"
  1495. }
  1496. },
  1497. "id" : "#dataframefield",
  1498. "additionalProperties" : false,
  1499. "title" : "Data frame field",
  1500. "required" : [ "col", "fieldType" ]
  1501. },
  1502. "tauto" : {
  1503. "type" : "string",
  1504. "minLength" : 1,
  1505. "enum" : [ "Auto" ]
  1506. },
  1507. "tboolean" : {
  1508. "type" : "string",
  1509. "minLength" : 1,
  1510. "enum" : [ "Boolean" ]
  1511. },
  1512. "tdate" : {
  1513. "type" : "string",
  1514. "minLength" : 1,
  1515. "enum" : [ "Date" ]
  1516. },
  1517. "tdatewithformat" : {
  1518. "type" : "object",
  1519. "properties" : {
  1520. "dateFormat" : {
  1521. "type" : "string",
  1522. "minLength" : 1
  1523. },
  1524. "type" : {
  1525. "enum" : [ "DateWithFormat" ],
  1526. "type" : "string"
  1527. }
  1528. },
  1529. "id" : "#tdatewithformat",
  1530. "additionalProperties" : false,
  1531. "title" : "T date with format",
  1532. "required" : [ "dateFormat", "type" ]
  1533. },
  1534. "tdouble" : {
  1535. "type" : "string",
  1536. "minLength" : 1,
  1537. "enum" : [ "Number" ]
  1538. },
  1539. "tlong" : {
  1540. "type" : "string",
  1541. "minLength" : 1,
  1542. "enum" : [ "Long" ]
  1543. },
  1544. "tnull" : {
  1545. "type" : "string",
  1546. "minLength" : 1,
  1547. "enum" : [ "Null" ]
  1548. },
  1549. "tstring" : {
  1550. "type" : "string",
  1551. "minLength" : 1,
  1552. "enum" : [ "String" ]
  1553. }
  1554. }
  1555. },
  1556. "jsonExample" : "not implemented yet"
  1557. } ]
  1558. }, {
  1559. "description" : "Return difference between dates",
  1560. "name" : "DateDiff",
  1561. "deprecatedNames" : [ ],
  1562. "request" : {
  1563. "jsonSchema" : {
  1564. "type" : "object",
  1565. "properties" : {
  1566. "action" : {
  1567. "type" : "string",
  1568. "minLength" : 1
  1569. },
  1570. "table" : {
  1571. "type" : "string",
  1572. "minLength" : 1
  1573. },
  1574. "col1" : {
  1575. "type" : "string",
  1576. "minLength" : 1
  1577. },
  1578. "col2" : {
  1579. "type" : "string",
  1580. "minLength" : 1
  1581. },
  1582. "precision" : {
  1583. "$ref" : "#/definitions/datetype"
  1584. },
  1585. "newcolumn" : {
  1586. "type" : "string",
  1587. "minLength" : 1
  1588. }
  1589. },
  1590. "id" : "#datediffaction",
  1591. "additionalProperties" : false,
  1592. "title" : "Date diff action",
  1593. "required" : [ "action", "table", "col1", "col2" ],
  1594. "definitions" : {
  1595. "datetype" : {
  1596. "anyOf" : [ {
  1597. "$ref" : "#/definitions/daytype"
  1598. }, {
  1599. "$ref" : "#/definitions/hourtype"
  1600. }, {
  1601. "$ref" : "#/definitions/minutetype"
  1602. }, {
  1603. "$ref" : "#/definitions/monthtype"
  1604. }, {
  1605. "$ref" : "#/definitions/secondtype"
  1606. }, {
  1607. "$ref" : "#/definitions/weektype"
  1608. }, {
  1609. "$ref" : "#/definitions/yeartype"
  1610. } ]
  1611. },
  1612. "daytype" : {
  1613. "type" : "string",
  1614. "minLength" : 1,
  1615. "enum" : [ "day" ]
  1616. },
  1617. "hourtype" : {
  1618. "type" : "string",
  1619. "minLength" : 1,
  1620. "enum" : [ "hour" ]
  1621. },
  1622. "minutetype" : {
  1623. "type" : "string",
  1624. "minLength" : 1,
  1625. "enum" : [ "minute" ]
  1626. },
  1627. "monthtype" : {
  1628. "type" : "string",
  1629. "minLength" : 1,
  1630. "enum" : [ "month" ]
  1631. },
  1632. "secondtype" : {
  1633. "type" : "string",
  1634. "minLength" : 1,
  1635. "enum" : [ "second" ]
  1636. },
  1637. "weektype" : {
  1638. "type" : "string",
  1639. "minLength" : 1,
  1640. "enum" : [ "week" ]
  1641. },
  1642. "yeartype" : {
  1643. "type" : "string",
  1644. "minLength" : 1,
  1645. "enum" : [ "year" ]
  1646. }
  1647. }
  1648. },
  1649. "jsonExample" : "not implemented yet"
  1650. },
  1651. "deprecatedRequests" : [ ]
  1652. }, {
  1653. "description" : "Return the day number in a month",
  1654. "name" : "DayExtract",
  1655. "deprecatedNames" : [ ],
  1656. "request" : {
  1657. "jsonSchema" : {
  1658. "type" : "object",
  1659. "properties" : {
  1660. "action" : {
  1661. "type" : "string",
  1662. "minLength" : 1
  1663. },
  1664. "table" : {
  1665. "type" : "string",
  1666. "minLength" : 1
  1667. },
  1668. "col" : {
  1669. "type" : "string",
  1670. "minLength" : 1
  1671. },
  1672. "newcolumn" : {
  1673. "type" : "string",
  1674. "minLength" : 1
  1675. }
  1676. },
  1677. "id" : "#dayextractaction",
  1678. "additionalProperties" : false,
  1679. "title" : "Day extract action",
  1680. "required" : [ "action", "table", "col" ]
  1681. },
  1682. "jsonExample" : "not implemented yet"
  1683. },
  1684. "deprecatedRequests" : [ ]
  1685. }, {
  1686. "description" : "Return the day number in a week",
  1687. "name" : "DayOfWeek",
  1688. "deprecatedNames" : [ ],
  1689. "request" : {
  1690. "jsonSchema" : {
  1691. "type" : "object",
  1692. "properties" : {
  1693. "action" : {
  1694. "type" : "string",
  1695. "minLength" : 1
  1696. },
  1697. "table" : {
  1698. "type" : "string",
  1699. "minLength" : 1
  1700. },
  1701. "col" : {
  1702. "type" : "string",
  1703. "minLength" : 1
  1704. },
  1705. "newcolumn" : {
  1706. "type" : "string",
  1707. "minLength" : 1
  1708. }
  1709. },
  1710. "id" : "#dayofweekaction",
  1711. "additionalProperties" : false,
  1712. "title" : "Day of week action",
  1713. "required" : [ "action", "table", "col" ]
  1714. },
  1715. "jsonExample" : "not implemented yet"
  1716. },
  1717. "deprecatedRequests" : [ ]
  1718. }, {
  1719. "description" : "Return the day number in a year",
  1720. "name" : "DayOfYear",
  1721. "deprecatedNames" : [ ],
  1722. "request" : {
  1723. "jsonSchema" : {
  1724. "type" : "object",
  1725. "properties" : {
  1726. "action" : {
  1727. "type" : "string",
  1728. "minLength" : 1
  1729. },
  1730. "table" : {
  1731. "type" : "string",
  1732. "minLength" : 1
  1733. },
  1734. "col" : {
  1735. "type" : "string",
  1736. "minLength" : 1
  1737. },
  1738. "newcolumn" : {
  1739. "type" : "string",
  1740. "minLength" : 1
  1741. }
  1742. },
  1743. "id" : "#dayofyearaction",
  1744. "additionalProperties" : false,
  1745. "title" : "Day of year action",
  1746. "required" : [ "action", "table", "col" ]
  1747. },
  1748. "jsonExample" : "not implemented yet"
  1749. },
  1750. "deprecatedRequests" : [ ]
  1751. }, {
  1752. "description" : "Return number of days in the month",
  1753. "name" : "DaysInMonth",
  1754. "deprecatedNames" : [ ],
  1755. "request" : {
  1756. "jsonSchema" : {
  1757. "type" : "object",
  1758. "properties" : {
  1759. "action" : {
  1760. "type" : "string",
  1761. "minLength" : 1
  1762. },
  1763. "table" : {
  1764. "type" : "string",
  1765. "minLength" : 1
  1766. },
  1767. "col" : {
  1768. "type" : "string",
  1769. "minLength" : 1
  1770. },
  1771. "newcolumn" : {
  1772. "type" : "string",
  1773. "minLength" : 1
  1774. }
  1775. },
  1776. "id" : "#daysinmonthaction",
  1777. "additionalProperties" : false,
  1778. "title" : "Days in month action",
  1779. "required" : [ "action", "table", "col" ]
  1780. },
  1781. "jsonExample" : "not implemented yet"
  1782. },
  1783. "deprecatedRequests" : [ ]
  1784. }, {
  1785. "description" : "Return schema with enabled decimal places",
  1786. "name" : "DecimalFormatting",
  1787. "deprecatedNames" : [ ],
  1788. "request" : {
  1789. "jsonSchema" : {
  1790. "type" : "object",
  1791. "properties" : {
  1792. "action" : {
  1793. "type" : "string",
  1794. "minLength" : 1
  1795. },
  1796. "table" : {
  1797. "type" : "string",
  1798. "minLength" : 1
  1799. },
  1800. "col" : {
  1801. "type" : "string",
  1802. "minLength" : 1
  1803. },
  1804. "operation" : {
  1805. "type" : "boolean"
  1806. }
  1807. },
  1808. "id" : "#decimalformattingaction",
  1809. "additionalProperties" : false,
  1810. "title" : "Decimal formatting action",
  1811. "required" : [ "action", "table", "col", "operation" ]
  1812. },
  1813. "jsonExample" : "not implemented yet"
  1814. },
  1815. "deprecatedRequests" : [ ]
  1816. }, {
  1817. "description" : "Drop all tables in spark",
  1818. "name" : "DeleteAllFilesInMemory",
  1819. "deprecatedNames" : [ ],
  1820. "request" : {
  1821. "jsonSchema" : {
  1822. "type" : "object",
  1823. "properties" : {
  1824. "action" : {
  1825. "type" : "string",
  1826. "minLength" : 1
  1827. },
  1828. "status" : {
  1829. "type" : "boolean"
  1830. }
  1831. },
  1832. "id" : "#deleteallfilesinmemoryaction",
  1833. "additionalProperties" : false,
  1834. "title" : "Delete all files in memory action",
  1835. "required" : [ "action", "status" ]
  1836. },
  1837. "jsonExample" : "not implemented yet"
  1838. },
  1839. "deprecatedRequests" : [ ]
  1840. }, {
  1841. "description" : "Drop a specific table in spark",
  1842. "name" : "DeleteFileInMemory",
  1843. "deprecatedNames" : [ ],
  1844. "request" : {
  1845. "jsonSchema" : {
  1846. "type" : "object",
  1847. "properties" : {
  1848. "action" : {
  1849. "type" : "string",
  1850. "minLength" : 1
  1851. },
  1852. "tableId" : {
  1853. "type" : "string",
  1854. "minLength" : 1
  1855. }
  1856. },
  1857. "id" : "#deletefileinmemoryaction",
  1858. "additionalProperties" : false,
  1859. "title" : "Delete file in memory action",
  1860. "required" : [ "action", "tableId" ]
  1861. },
  1862. "jsonExample" : "not implemented yet"
  1863. },
  1864. "deprecatedRequests" : [ ]
  1865. }, {
  1866. "description" : "Divide values in a column",
  1867. "name" : "Divide",
  1868. "deprecatedNames" : [ ],
  1869. "request" : {
  1870. "jsonSchema" : {
  1871. "type" : "object",
  1872. "properties" : {
  1873. "action" : {
  1874. "type" : "string",
  1875. "minLength" : 1
  1876. },
  1877. "table" : {
  1878. "type" : "string",
  1879. "minLength" : 1
  1880. },
  1881. "col" : {
  1882. "type" : "string",
  1883. "minLength" : 1
  1884. },
  1885. "number" : {
  1886. "type" : "number"
  1887. },
  1888. "precision" : {
  1889. "type" : "number"
  1890. },
  1891. "newcolumn" : {
  1892. "type" : "string",
  1893. "minLength" : 1
  1894. }
  1895. },
  1896. "id" : "#divideaction",
  1897. "additionalProperties" : false,
  1898. "title" : "Divide action",
  1899. "required" : [ "action", "table", "col", "number" ]
  1900. },
  1901. "jsonExample" : "not implemented yet"
  1902. },
  1903. "deprecatedRequests" : [ ]
  1904. }, {
  1905. "description" : "Save table into two files in csv format: first with header, second with data",
  1906. "name" : "DownloadFileAsCSV",
  1907. "deprecatedNames" : [ ],
  1908. "request" : {
  1909. "jsonSchema" : {
  1910. "type" : "object",
  1911. "properties" : {
  1912. "action" : {
  1913. "type" : "string",
  1914. "minLength" : 1
  1915. },
  1916. "table" : {
  1917. "type" : "string",
  1918. "minLength" : 1
  1919. },
  1920. "headerFile" : {
  1921. "$ref" : "#/definitions/filerequest"
  1922. },
  1923. "dataFile" : {
  1924. "$ref" : "#/definitions/filerequest"
  1925. },
  1926. "delimiter" : {
  1927. "type" : "string",
  1928. "minLength" : 1
  1929. }
  1930. },
  1931. "id" : "#downloadfilefromsparkascsvrequest",
  1932. "additionalProperties" : false,
  1933. "title" : "Download file from spark as c s v request",
  1934. "required" : [ "action", "table", "headerFile", "dataFile" ],
  1935. "definitions" : {
  1936. "filerequest" : {
  1937. "type" : "object",
  1938. "properties" : {
  1939. "file" : {
  1940. "type" : "string",
  1941. "minLength" : 1
  1942. },
  1943. "storage" : {
  1944. "type" : "string",
  1945. "minLength" : 1
  1946. }
  1947. },
  1948. "id" : "#filerequest",
  1949. "additionalProperties" : false,
  1950. "title" : "File request",
  1951. "required" : [ "file", "storage" ]
  1952. }
  1953. }
  1954. },
  1955. "jsonExample" : "not implemented yet"
  1956. },
  1957. "deprecatedRequests" : [ {
  1958. "jsonSchema" : {
  1959. "type" : "object",
  1960. "properties" : {
  1961. "action" : {
  1962. "type" : "string",
  1963. "minLength" : 1
  1964. },
  1965. "table" : {
  1966. "type" : "string",
  1967. "minLength" : 1
  1968. },
  1969. "store" : {
  1970. "type" : "string",
  1971. "minLength" : 1
  1972. },
  1973. "output_path" : {
  1974. "type" : "string",
  1975. "minLength" : 1
  1976. },
  1977. "delimeter" : {
  1978. "type" : "string",
  1979. "minLength" : 1
  1980. }
  1981. },
  1982. "id" : "#downloadfilefromsparkascsvrequestold",
  1983. "additionalProperties" : false,
  1984. "title" : "Download file from spark as c s v request old",
  1985. "required" : [ "action", "table", "store", "output_path" ]
  1986. },
  1987. "jsonExample" : "not implemented yet"
  1988. } ]
  1989. }, {
  1990. "description" : "Drop all rows in a table",
  1991. "name" : "DropAllRows",
  1992. "deprecatedNames" : [ ],
  1993. "request" : {
  1994. "jsonSchema" : {
  1995. "type" : "object",
  1996. "properties" : {
  1997. "action" : {
  1998. "type" : "string",
  1999. "minLength" : 1
  2000. },
  2001. "table" : {
  2002. "type" : "string",
  2003. "minLength" : 1
  2004. }
  2005. },
  2006. "id" : "#dropallrowsaction",
  2007. "additionalProperties" : false,
  2008. "title" : "Drop all rows action",
  2009. "required" : [ "action", "table" ]
  2010. },
  2011. "jsonExample" : "not implemented yet"
  2012. },
  2013. "deprecatedRequests" : [ ]
  2014. }, {
  2015. "description" : "Drop tables in the relational database",
  2016. "name" : "DropSqlTables",
  2017. "deprecatedNames" : [ ],
  2018. "request" : {
  2019. "jsonSchema" : {
  2020. "type" : "object",
  2021. "properties" : {
  2022. "action" : {
  2023. "type" : "string",
  2024. "minLength" : 1
  2025. },
  2026. "sqlServerUrl" : {
  2027. "$ref" : "#/definitions/jdbcconnectioninfo"
  2028. },
  2029. "database" : {
  2030. "type" : "string",
  2031. "minLength" : 1
  2032. },
  2033. "dbUser" : {
  2034. "type" : "string",
  2035. "minLength" : 1
  2036. },
  2037. "dbPasswordEncrypted" : {
  2038. "$ref" : "#/definitions/encryptedvalue"
  2039. },
  2040. "tables" : {
  2041. "type" : "array",
  2042. "items" : {
  2043. "type" : "string",
  2044. "minLength" : 1
  2045. }
  2046. }
  2047. },
  2048. "id" : "#dropsqltablesrequest",
  2049. "additionalProperties" : false,
  2050. "title" : "Drop sql tables request",
  2051. "required" : [ "action", "sqlServerUrl", "database", "dbUser", "dbPasswordEncrypted", "tables" ],
  2052. "definitions" : {
  2053. "encryptedvalue" : {
  2054. "type" : "object",
  2055. "properties" : {
  2056. "value" : {
  2057. "type" : "string",
  2058. "minLength" : 1
  2059. },
  2060. "iv" : {
  2061. "type" : "string",
  2062. "minLength" : 1
  2063. }
  2064. },
  2065. "id" : "#encryptedvalue",
  2066. "additionalProperties" : false,
  2067. "title" : "Encrypted value",
  2068. "required" : [ "value", "iv" ]
  2069. },
  2070. "h2connectioninfo" : {
  2071. "type" : "object",
  2072. "properties" : {
  2073. "fullUrl" : {
  2074. "type" : "string",
  2075. "minLength" : 1
  2076. }
  2077. },
  2078. "id" : "#h2connectioninfo",
  2079. "additionalProperties" : false,
  2080. "title" : "H2 connection info",
  2081. "required" : [ "fullUrl" ]
  2082. },
  2083. "jdbcconnectioninfo" : {
  2084. "anyOf" : [ {
  2085. "$ref" : "#/definitions/h2connectioninfo"
  2086. }, {
  2087. "$ref" : "#/definitions/sqlserverconnectioninfo"
  2088. } ]
  2089. },
  2090. "sqlserverconnectioninfo" : {
  2091. "type" : "object",
  2092. "properties" : {
  2093. "url" : {
  2094. "type" : "string",
  2095. "minLength" : 1
  2096. }
  2097. },
  2098. "id" : "#sqlserverconnectioninfo",
  2099. "additionalProperties" : false,
  2100. "title" : "Sql server connection info",
  2101. "required" : [ "url" ]
  2102. }
  2103. }
  2104. },
  2105. "jsonExample" : "not implemented yet"
  2106. },
  2107. "deprecatedRequests" : [ ]
  2108. }, {
  2109. "description" : "Return name of the last day in a month",
  2110. "name" : "EndOfMonth",
  2111. "deprecatedNames" : [ ],
  2112. "request" : {
  2113. "jsonSchema" : {
  2114. "type" : "object",
  2115. "properties" : {
  2116. "action" : {
  2117. "type" : "string",
  2118. "minLength" : 1
  2119. },
  2120. "table" : {
  2121. "type" : "string",
  2122. "minLength" : 1
  2123. },
  2124. "col" : {
  2125. "type" : "string",
  2126. "minLength" : 1
  2127. },
  2128. "newcolumn" : {
  2129. "type" : "string",
  2130. "minLength" : 1
  2131. }
  2132. },
  2133. "id" : "#endofmonthaction",
  2134. "additionalProperties" : false,
  2135. "title" : "End of month action",
  2136. "required" : [ "action", "table", "col" ]
  2137. },
  2138. "jsonExample" : "not implemented yet"
  2139. },
  2140. "deprecatedRequests" : [ ]
  2141. }, {
  2142. "description" : "Return date of end of the week",
  2143. "name" : "EndOfWeek",
  2144. "deprecatedNames" : [ ],
  2145. "request" : {
  2146. "jsonSchema" : {
  2147. "type" : "object",
  2148. "properties" : {
  2149. "action" : {
  2150. "type" : "string",
  2151. "minLength" : 1
  2152. },
  2153. "table" : {
  2154. "type" : "string",
  2155. "minLength" : 1
  2156. },
  2157. "col" : {
  2158. "type" : "string",
  2159. "minLength" : 1
  2160. },
  2161. "newcolumn" : {
  2162. "type" : "string",
  2163. "minLength" : 1
  2164. }
  2165. },
  2166. "id" : "#endofweekaction",
  2167. "additionalProperties" : false,
  2168. "title" : "End of week action",
  2169. "required" : [ "action", "table", "col" ]
  2170. },
  2171. "jsonExample" : "not implemented yet"
  2172. },
  2173. "deprecatedRequests" : [ ]
  2174. }, {
  2175. "description" : "Eval job expects an expression that produces a single result, executes the expression and returns the result. E.g. `(max(col1) - min(col1))`",
  2176. "name" : "Eval",
  2177. "deprecatedNames" : [ ],
  2178. "request" : {
  2179. "jsonSchema" : {
  2180. "type" : "object",
  2181. "properties" : {
  2182. "action" : {
  2183. "type" : "string",
  2184. "minLength" : 1
  2185. },
  2186. "table" : {
  2187. "type" : "string",
  2188. "minLength" : 1
  2189. },
  2190. "expression" : {
  2191. "type" : "string",
  2192. "minLength" : 1
  2193. }
  2194. },
  2195. "id" : "#evalaction",
  2196. "additionalProperties" : false,
  2197. "title" : "Eval action",
  2198. "required" : [ "action", "table", "expression" ]
  2199. },
  2200. "jsonExample" : {
  2201. "action" : "Eval",
  2202. "table" : "table",
  2203. "expression" : "1 + 2"
  2204. }
  2205. },
  2206. "deprecatedRequests" : [ ]
  2207. }, {
  2208. "description" : "Eval udf registered via RegisterUDF",
  2209. "name" : "EvalUDF",
  2210. "deprecatedNames" : [ ],
  2211. "request" : {
  2212. "jsonSchema" : {
  2213. "type" : "object",
  2214. "properties" : {
  2215. "action" : {
  2216. "type" : "string",
  2217. "minLength" : 1
  2218. },
  2219. "functionId" : {
  2220. "type" : "string",
  2221. "minLength" : 1
  2222. },
  2223. "funcParams" : {
  2224. "type" : "array",
  2225. "items" : {
  2226. "type" : "string",
  2227. "minLength" : 1
  2228. }
  2229. },
  2230. "table" : {
  2231. "type" : "string",
  2232. "minLength" : 1
  2233. }
  2234. },
  2235. "id" : "#evaludfaction",
  2236. "additionalProperties" : false,
  2237. "title" : "Eval u d f action",
  2238. "required" : [ "action", "functionId", "table" ]
  2239. },
  2240. "jsonExample" : "not implemented yet"
  2241. },
  2242. "deprecatedRequests" : [ ]
  2243. }, {
  2244. "description" : "Execute several actions one by one",
  2245. "name" : "ExecuteBatch",
  2246. "deprecatedNames" : [ ],
  2247. "request" : {
  2248. "jsonSchema" : {
  2249. "type" : "object",
  2250. "properties" : {
  2251. "action" : {
  2252. "type" : "string",
  2253. "minLength" : 1
  2254. },
  2255. "actionsToExecute" : {
  2256. "type" : "array",
  2257. "items" : {
  2258. "$ref" : "#/definitions/jsvalue"
  2259. }
  2260. }
  2261. },
  2262. "id" : "#executebatchaction",
  2263. "additionalProperties" : false,
  2264. "title" : "Execute batch action",
  2265. "required" : [ "action", "actionsToExecute" ],
  2266. "definitions" : {
  2267. "jsarray" : {
  2268. "type" : "object",
  2269. "properties" : {
  2270. "value" : {
  2271. "type" : "array",
  2272. "items" : {
  2273. "$ref" : "#/definitions/jsvalue"
  2274. }
  2275. }
  2276. },
  2277. "id" : "#jsarray",
  2278. "additionalProperties" : false,
  2279. "title" : "Js array",
  2280. "required" : [ "value" ]
  2281. },
  2282. "jsboolean" : {
  2283. "anyOf" : [ {
  2284. "$ref" : "#/definitions/jsfalse"
  2285. }, {
  2286. "$ref" : "#/definitions/jstrue"
  2287. } ]
  2288. },
  2289. "jsfalse" : {
  2290. "type" : "object",
  2291. "properties" : { },
  2292. "id" : "#jsfalse",
  2293. "additionalProperties" : false,
  2294. "title" : "Js false"
  2295. },
  2296. "jsnull" : {
  2297. "type" : "object",
  2298. "properties" : { },
  2299. "id" : "#jsnull",
  2300. "additionalProperties" : false,
  2301. "title" : "Js null"
  2302. },
  2303. "jsnumber" : {
  2304. "type" : "object",
  2305. "properties" : {
  2306. "value" : {
  2307. "type" : "number"
  2308. }
  2309. },
  2310. "id" : "#jsnumber",
  2311. "additionalProperties" : false,
  2312. "title" : "Js number",
  2313. "required" : [ "value" ]
  2314. },
  2315. "jsobject" : {
  2316. "type" : "object",
  2317. "properties" : {
  2318. "underlying" : {
  2319. "type" : "array",
  2320. "items" : {
  2321. "type" : "string",
  2322. "minLength" : 1
  2323. }
  2324. }
  2325. },
  2326. "id" : "#jsobject",
  2327. "additionalProperties" : false,
  2328. "title" : "Js object",
  2329. "required" : [ "underlying" ]
  2330. },
  2331. "jsstring" : {
  2332. "type" : "object",
  2333. "properties" : {
  2334. "value" : {
  2335. "type" : "string",
  2336. "minLength" : 1
  2337. }
  2338. },
  2339. "id" : "#jsstring",
  2340. "additionalProperties" : false,
  2341. "title" : "Js string",
  2342. "required" : [ "value" ]
  2343. },
  2344. "jstrue" : {
  2345. "type" : "object",
  2346. "properties" : { },
  2347. "id" : "#jstrue",
  2348. "additionalProperties" : false,
  2349. "title" : "Js true"
  2350. },
  2351. "jsvalue" : {
  2352. "anyOf" : [ {
  2353. "$ref" : "#/definitions/jsarray"
  2354. }, {
  2355. "$ref" : "#/definitions/jsboolean"
  2356. }, {
  2357. "$ref" : "#/definitions/jsfalse"
  2358. }, {
  2359. "$ref" : "#/definitions/jsnull"
  2360. }, {
  2361. "$ref" : "#/definitions/jsnumber"
  2362. }, {
  2363. "$ref" : "#/definitions/jsobject"
  2364. }, {
  2365. "$ref" : "#/definitions/jsstring"
  2366. }, {
  2367. "$ref" : "#/definitions/jstrue"
  2368. } ]
  2369. }
  2370. }
  2371. },
  2372. "jsonExample" : "not implemented yet"
  2373. },
  2374. "deprecatedRequests" : [ ]
  2375. }, {
  2376. "description" : "Execute custom scala code",
  2377. "name" : "ExecuteCustomCode",
  2378. "deprecatedNames" : [ ],
  2379. "request" : {
  2380. "jsonSchema" : {
  2381. "type" : "object",
  2382. "properties" : {
  2383. "action" : {
  2384. "type" : "string",
  2385. "minLength" : 1
  2386. },
  2387. "codeToExecute" : {
  2388. "type" : "string",
  2389. "minLength" : 1
  2390. },
  2391. "inputTables" : {
  2392. "type" : "array",
  2393. "items" : {
  2394. "$ref" : "#/definitions/inputtable"
  2395. }
  2396. },
  2397. "inputVariables" : {
  2398. "type" : "array",
  2399. "items" : {
  2400. "$ref" : "#/definitions/inputvariable"
  2401. }
  2402. }
  2403. },
  2404. "id" : "#executecustomcodeaction",
  2405. "additionalProperties" : false,
  2406. "title" : "Execute custom code action",
  2407. "required" : [ "action", "codeToExecute" ],
  2408. "definitions" : {
  2409. "inputtable" : {
  2410. "type" : "object",
  2411. "properties" : {
  2412. "tableId" : {
  2413. "type" : "string",
  2414. "minLength" : 1
  2415. },
  2416. "variableName" : {
  2417. "type" : "string",
  2418. "minLength" : 1
  2419. }
  2420. },
  2421. "id" : "#inputtable",
  2422. "additionalProperties" : false,
  2423. "title" : "Input table",
  2424. "required" : [ "tableId", "variableName" ]
  2425. },
  2426. "inputvariable" : {
  2427. "type" : "object",
  2428. "properties" : {
  2429. "name" : {
  2430. "type" : "string",
  2431. "minLength" : 1
  2432. },
  2433. "value" : {
  2434. "$ref" : "#/definitions/jsvalue"
  2435. }
  2436. },
  2437. "id" : "#inputvariable",
  2438. "additionalProperties" : false,
  2439. "title" : "Input variable",
  2440. "required" : [ "name", "value" ]
  2441. },
  2442. "jsarray" : {
  2443. "type" : "object",
  2444. "properties" : {
  2445. "value" : {
  2446. "type" : "array",
  2447. "items" : {
  2448. "$ref" : "#/definitions/jsvalue"
  2449. }
  2450. }
  2451. },
  2452. "id" : "#jsarray",
  2453. "additionalProperties" : false,
  2454. "title" : "Js array",
  2455. "required" : [ "value" ]
  2456. },
  2457. "jsboolean" : {
  2458. "anyOf" : [ {
  2459. "$ref" : "#/definitions/jsfalse"
  2460. }, {
  2461. "$ref" : "#/definitions/jstrue"
  2462. } ]
  2463. },
  2464. "jsfalse" : {
  2465. "type" : "object",
  2466. "properties" : { },
  2467. "id" : "#jsfalse",
  2468. "additionalProperties" : false,
  2469. "title" : "Js false"
  2470. },
  2471. "jsnull" : {
  2472. "type" : "object",
  2473. "properties" : { },
  2474. "id" : "#jsnull",
  2475. "additionalProperties" : false,
  2476. "title" : "Js null"
  2477. },
  2478. "jsnumber" : {
  2479. "type" : "object",
  2480. "properties" : {
  2481. "value" : {
  2482. "type" : "number"
  2483. }
  2484. },
  2485. "id" : "#jsnumber",
  2486. "additionalProperties" : false,
  2487. "title" : "Js number",
  2488. "required" : [ "value" ]
  2489. },
  2490. "jsobject" : {
  2491. "type" : "object",
  2492. "properties" : {
  2493. "underlying" : {
  2494. "type" : "array",
  2495. "items" : {
  2496. "type" : "string",
  2497. "minLength" : 1
  2498. }
  2499. }
  2500. },
  2501. "id" : "#jsobject",
  2502. "additionalProperties" : false,
  2503. "title" : "Js object",
  2504. "required" : [ "underlying" ]
  2505. },
  2506. "jsstring" : {
  2507. "type" : "object",
  2508. "properties" : {
  2509. "value" : {
  2510. "type" : "string",
  2511. "minLength" : 1
  2512. }
  2513. },
  2514. "id" : "#jsstring",
  2515. "additionalProperties" : false,
  2516. "title" : "Js string",
  2517. "required" : [ "value" ]
  2518. },
  2519. "jstrue" : {
  2520. "type" : "object",
  2521. "properties" : { },
  2522. "id" : "#jstrue",
  2523. "additionalProperties" : false,
  2524. "title" : "Js true"
  2525. },
  2526. "jsvalue" : {
  2527. "anyOf" : [ {
  2528. "$ref" : "#/definitions/jsarray"
  2529. }, {
  2530. "$ref" : "#/definitions/jsboolean"
  2531. }, {
  2532. "$ref" : "#/definitions/jsfalse"
  2533. }, {
  2534. "$ref" : "#/definitions/jsnull"
  2535. }, {
  2536. "$ref" : "#/definitions/jsnumber"
  2537. }, {
  2538. "$ref" : "#/definitions/jsobject"
  2539. }, {
  2540. "$ref" : "#/definitions/jsstring"
  2541. }, {
  2542. "$ref" : "#/definitions/jstrue"
  2543. } ]
  2544. }
  2545. }
  2546. },
  2547. "jsonExample" : "not implemented yet"
  2548. },
  2549. "deprecatedRequests" : [ ]
  2550. }, {
  2551. "description" : "Extract length from values in a string column",
  2552. "name" : "ExtractLength",
  2553. "deprecatedNames" : [ ],
  2554. "request" : {
  2555. "jsonSchema" : {
  2556. "type" : "object",
  2557. "properties" : {
  2558. "action" : {
  2559. "type" : "string",
  2560. "minLength" : 1
  2561. },
  2562. "table" : {
  2563. "type" : "string",
  2564. "minLength" : 1
  2565. },
  2566. "col" : {
  2567. "type" : "string",
  2568. "minLength" : 1
  2569. },
  2570. "newcolumn" : {
  2571. "type" : "string",
  2572. "minLength" : 1
  2573. }
  2574. },
  2575. "id" : "#extractlengthaction",
  2576. "additionalProperties" : false,
  2577. "title" : "Extract length action",
  2578. "required" : [ "action", "table", "col" ]
  2579. },
  2580. "jsonExample" : "not implemented yet"
  2581. },
  2582. "deprecatedRequests" : [ ]
  2583. }, {
  2584. "description" : "Extract substring from values in a string column",
  2585. "name" : "ExtractRange",
  2586. "deprecatedNames" : [ ],
  2587. "request" : {
  2588. "jsonSchema" : {
  2589. "type" : "object",
  2590. "properties" : {
  2591. "action" : {
  2592. "type" : "string",
  2593. "minLength" : 1
  2594. },
  2595. "table" : {
  2596. "type" : "string",
  2597. "minLength" : 1
  2598. },
  2599. "col" : {
  2600. "type" : "string",
  2601. "minLength" : 1
  2602. },
  2603. "startIndex" : {
  2604. "type" : "number"
  2605. },
  2606. "length" : {
  2607. "type" : "number"
  2608. },
  2609. "newcolumn" : {
  2610. "type" : "string",
  2611. "minLength" : 1
  2612. }
  2613. },
  2614. "id" : "#extractrangeaction",
  2615. "additionalProperties" : false,
  2616. "title" : "Extract range action",
  2617. "required" : [ "action", "table", "col", "startIndex", "length" ]
  2618. },
  2619. "jsonExample" : "not implemented yet"
  2620. },
  2621. "deprecatedRequests" : [ ]
  2622. }, {
  2623. "description" : "Return table from spark",
  2624. "name" : "FileInfo",
  2625. "deprecatedNames" : [ ],
  2626. "request" : {
  2627. "jsonSchema" : {
  2628. "type" : "object",
  2629. "properties" : {
  2630. "action" : {
  2631. "type" : "string",
  2632. "minLength" : 1
  2633. },
  2634. "table" : {
  2635. "type" : "string",
  2636. "minLength" : 1
  2637. }
  2638. },
  2639. "id" : "#fileinfoaction",
  2640. "additionalProperties" : false,
  2641. "title" : "File info action",
  2642. "required" : [ "action", "table" ]
  2643. },
  2644. "jsonExample" : "not implemented yet"
  2645. },
  2646. "deprecatedRequests" : [ ]
  2647. }, {
  2648. "description" : "Filter values",
  2649. "name" : "Filter",
  2650. "deprecatedNames" : [ ],
  2651. "request" : {
  2652. "jsonSchema" : {
  2653. "type" : "object",
  2654. "properties" : {
  2655. "action" : {
  2656. "type" : "string",
  2657. "minLength" : 1
  2658. },
  2659. "table" : {
  2660. "type" : "string",
  2661. "minLength" : 1
  2662. },
  2663. "filterGroup" : {
  2664. "$ref" : "#/definitions/filtergroup"
  2665. }
  2666. },
  2667. "id" : "#filteraction",
  2668. "additionalProperties" : false,
  2669. "title" : "Filter action",
  2670. "required" : [ "action", "table", "filterGroup" ],
  2671. "definitions" : {
  2672. "dateafter" : {
  2673. "type" : "string",
  2674. "minLength" : 1,
  2675. "enum" : [ "DateAfter" ]
  2676. },
  2677. "datebefore" : {
  2678. "type" : "string",
  2679. "minLength" : 1,
  2680. "enum" : [ "DateBefore" ]
  2681. },
  2682. "dateis" : {
  2683. "type" : "string",
  2684. "minLength" : 1,
  2685. "enum" : [ "DateIs" ]
  2686. },
  2687. "filter" : {
  2688. "type" : "object",
  2689. "properties" : {
  2690. "name" : {
  2691. "$ref" : "#/definitions/filtertype"
  2692. },
  2693. "value" : {
  2694. "type" : "string",
  2695. "minLength" : 1
  2696. },
  2697. "col" : {
  2698. "type" : "string",
  2699. "minLength" : 1
  2700. },
  2701. "isValueAColumn" : {
  2702. "type" : "boolean"
  2703. }
  2704. },
  2705. "id" : "#filter",
  2706. "additionalProperties" : false,
  2707. "title" : "Filter",
  2708. "required" : [ "name", "col" ]
  2709. },
  2710. "filtergroup" : {
  2711. "type" : "object",
  2712. "properties" : {
  2713. "filters" : {
  2714. "type" : "array",
  2715. "items" : {
  2716. "$ref" : "#/definitions/filter"
  2717. }
  2718. },
  2719. "grouping" : {
  2720. "type" : "string",
  2721. "minLength" : 1
  2722. },
  2723. "children" : {
  2724. "type" : "array",
  2725. "items" : {
  2726. "$ref" : "#/definitions/filtergroup"
  2727. }
  2728. }
  2729. },
  2730. "id" : "#filtergroup",
  2731. "additionalProperties" : false,
  2732. "title" : "Filter group",
  2733. "required" : [ "filters", "grouping", "children" ]
  2734. },
  2735. "filtertype" : {
  2736. "anyOf" : [ {
  2737. "$ref" : "#/definitions/dateafter"
  2738. }, {
  2739. "$ref" : "#/definitions/datebefore"
  2740. }, {
  2741. "$ref" : "#/definitions/dateis"
  2742. }, {
  2743. "$ref" : "#/definitions/greaterthen"
  2744. }, {
  2745. "$ref" : "#/definitions/greaterthenoreq"
  2746. }, {
  2747. "$ref" : "#/definitions/isbetween"
  2748. }, {
  2749. "$ref" : "#/definitions/iseq"
  2750. }, {
  2751. "$ref" : "#/definitions/isnotbetween"
  2752. }, {
  2753. "$ref" : "#/definitions/isnoteq"
  2754. }, {
  2755. "$ref" : "#/definitions/isnotnull"
  2756. }, {
  2757. "$ref" : "#/definitions/isnotunique"
  2758. }, {
  2759. "$ref" : "#/definitions/isnull"
  2760. }, {
  2761. "$ref" : "#/definitions/isunique"
  2762. }, {
  2763. "$ref" : "#/definitions/lessthen"
  2764. }, {
  2765. "$ref" : "#/definitions/lessthenoreq"
  2766. }, {
  2767. "$ref" : "#/definitions/textcontains"
  2768. }, {
  2769. "$ref" : "#/definitions/textends"
  2770. }, {
  2771. "$ref" : "#/definitions/textis"
  2772. }, {
  2773. "$ref" : "#/definitions/textisempty"
  2774. }, {
  2775. "$ref" : "#/definitions/textisnot"
  2776. }, {
  2777. "$ref" : "#/definitions/textisnotempty"
  2778. }, {
  2779. "$ref" : "#/definitions/textnotcontains"
  2780. }, {
  2781. "$ref" : "#/definitions/textnotends"
  2782. }, {
  2783. "$ref" : "#/definitions/textnotstarts"
  2784. }, {
  2785. "$ref" : "#/definitions/textstarts"
  2786. } ]
  2787. },
  2788. "greaterthen" : {
  2789. "type" : "string",
  2790. "minLength" : 1,
  2791. "enum" : [ "GreaterThen" ]
  2792. },
  2793. "greaterthenoreq" : {
  2794. "type" : "string",
  2795. "minLength" : 1,
  2796. "enum" : [ "GreaterThenOrEq" ]
  2797. },
  2798. "isbetween" : {
  2799. "type" : "string",
  2800. "minLength" : 1,
  2801. "enum" : [ "IsBetween" ]
  2802. },
  2803. "iseq" : {
  2804. "type" : "string",
  2805. "minLength" : 1,
  2806. "enum" : [ "IsEq" ]
  2807. },
  2808. "isnotbetween" : {
  2809. "type" : "string",
  2810. "minLength" : 1,
  2811. "enum" : [ "IsNotBetween" ]
  2812. },
  2813. "isnoteq" : {
  2814. "type" : "string",
  2815. "minLength" : 1,
  2816. "enum" : [ "IsNotEq" ]
  2817. },
  2818. "isnotnull" : {
  2819. "type" : "string",
  2820. "minLength" : 1,
  2821. "enum" : [ "IsNotNull" ]
  2822. },
  2823. "isnotunique" : {
  2824. "type" : "string",
  2825. "minLength" : 1,
  2826. "enum" : [ "IsNotUnique" ]
  2827. },
  2828. "isnull" : {
  2829. "type" : "string",
  2830. "minLength" : 1,
  2831. "enum" : [ "IsNull" ]
  2832. },
  2833. "isunique" : {
  2834. "type" : "string",
  2835. "minLength" : 1,
  2836. "enum" : [ "IsUnique" ]
  2837. },
  2838. "lessthen" : {
  2839. "type" : "string",
  2840. "minLength" : 1,
  2841. "enum" : [ "LessThen" ]
  2842. },
  2843. "lessthenoreq" : {
  2844. "type" : "string",
  2845. "minLength" : 1,
  2846. "enum" : [ "LessThenOrEq" ]
  2847. },
  2848. "textcontains" : {
  2849. "type" : "string",
  2850. "minLength" : 1,
  2851. "enum" : [ "TextContains" ]
  2852. },
  2853. "textends" : {
  2854. "type" : "string",
  2855. "minLength" : 1,
  2856. "enum" : [ "TextEnds" ]
  2857. },
  2858. "textis" : {
  2859. "type" : "string",
  2860. "minLength" : 1,
  2861. "enum" : [ "TextIs" ]
  2862. },
  2863. "textisempty" : {
  2864. "type" : "string",
  2865. "minLength" : 1,
  2866. "enum" : [ "TextIsEmpty" ]
  2867. },
  2868. "textisnot" : {
  2869. "type" : "string",
  2870. "minLength" : 1,
  2871. "enum" : [ "TextIsNot" ]
  2872. },
  2873. "textisnotempty" : {
  2874. "type" : "string",
  2875. "minLength" : 1,
  2876. "enum" : [ "TextIsNotEmpty" ]
  2877. },
  2878. "textnotcontains" : {
  2879. "type" : "string",
  2880. "minLength" : 1,
  2881. "enum" : [ "TextNotContains" ]
  2882. },
  2883. "textnotends" : {
  2884. "type" : "string",
  2885. "minLength" : 1,
  2886. "enum" : [ "TextNotEnds" ]
  2887. },
  2888. "textnotstarts" : {
  2889. "type" : "string",
  2890. "minLength" : 1,
  2891. "enum" : [ "TextNotStarts" ]
  2892. },
  2893. "textstarts" : {
  2894. "type" : "string",
  2895. "minLength" : 1,
  2896. "enum" : [ "TextStarts" ]
  2897. }
  2898. }
  2899. },
  2900. "jsonExample" : "not implemented yet"
  2901. },
  2902. "deprecatedRequests" : [ ]
  2903. }, {
  2904. "description" : "Return rows that contain selected values",
  2905. "name" : "FilterBySelectedColumnValues",
  2906. "deprecatedNames" : [ ],
  2907. "request" : {
  2908. "jsonSchema" : {
  2909. "type" : "object",
  2910. "properties" : {
  2911. "action" : {
  2912. "type" : "string",
  2913. "minLength" : 1
  2914. },
  2915. "table" : {
  2916. "type" : "string",
  2917. "minLength" : 1
  2918. },
  2919. "columnName" : {
  2920. "type" : "string",
  2921. "minLength" : 1
  2922. },
  2923. "values" : {
  2924. "type" : "array",
  2925. "items" : {
  2926. "type" : "string",
  2927. "minLength" : 1
  2928. }
  2929. }
  2930. },
  2931. "id" : "#filterbyselectedcolumnvaluesaction",
  2932. "additionalProperties" : false,
  2933. "title" : "Filter by selected column values action",
  2934. "required" : [ "action", "table", "columnName", "values" ]
  2935. },
  2936. "jsonExample" : "not implemented yet"
  2937. },
  2938. "deprecatedRequests" : [ ]
  2939. }, {
  2940. "description" : "Find difference between two tables and mark rows as: Added, Updated or Deleted",
  2941. "name" : "FindDifference",
  2942. "deprecatedNames" : [ ],
  2943. "request" : {
  2944. "jsonSchema" : {
  2945. "type" : "object",
  2946. "properties" : {
  2947. "action" : {
  2948. "type" : "string",
  2949. "minLength" : 1
  2950. },
  2951. "source" : {
  2952. "type" : "string",
  2953. "minLength" : 1
  2954. },
  2955. "target" : {
  2956. "type" : "string",
  2957. "minLength" : 1
  2958. },
  2959. "filterKey" : {
  2960. "type" : "string",
  2961. "minLength" : 1
  2962. },
  2963. "primaryKeys" : {
  2964. "type" : "array",
  2965. "items" : {
  2966. "type" : "string",
  2967. "minLength" : 1
  2968. }
  2969. }
  2970. },
  2971. "id" : "#finddifferenceaction",
  2972. "additionalProperties" : false,
  2973. "title" : "Find difference action",
  2974. "required" : [ "action", "source", "target" ]
  2975. },
  2976. "jsonExample" : "not implemented yet"
  2977. },
  2978. "deprecatedRequests" : [ ]
  2979. }, {
  2980. "description" : "Computes the floor of the given column",
  2981. "name" : "Floor",
  2982. "deprecatedNames" : [ ],
  2983. "request" : {
  2984. "jsonSchema" : {
  2985. "type" : "object",
  2986. "properties" : {
  2987. "action" : {
  2988. "type" : "string",
  2989. "minLength" : 1
  2990. },
  2991. "table" : {
  2992. "type" : "string",
  2993. "minLength" : 1
  2994. },
  2995. "col" : {
  2996. "type" : "string",
  2997. "minLength" : 1
  2998. },
  2999. "newcolumn" : {
  3000. "type" : "string",
  3001. "minLength" : 1
  3002. }
  3003. },
  3004. "id" : "#flooraction",
  3005. "additionalProperties" : false,
  3006. "title" : "Floor action",
  3007. "required" : [ "action", "table", "col" ]
  3008. },
  3009. "jsonExample" : "not implemented yet"
  3010. },
  3011. "deprecatedRequests" : [ ]
  3012. }, {
  3013. "description" : "Count frequencies of values in a column. E.g. 'v1', 'v2', 'v1' => 'v1' -> 2, 'v2' -> 1",
  3014. "name" : "Frequency",
  3015. "deprecatedNames" : [ ],
  3016. "request" : {
  3017. "jsonSchema" : {
  3018. "type" : "object",
  3019. "properties" : {
  3020. "action" : {
  3021. "type" : "string",
  3022. "minLength" : 1
  3023. },
  3024. "table" : {
  3025. "type" : "string",
  3026. "minLength" : 1
  3027. },
  3028. "col" : {
  3029. "type" : "string",
  3030. "minLength" : 1
  3031. }
  3032. },
  3033. "id" : "#frequencyaction",
  3034. "additionalProperties" : false,
  3035. "title" : "Frequency action",
  3036. "required" : [ "action", "table", "col" ]
  3037. },
  3038. "jsonExample" : "not implemented yet"
  3039. },
  3040. "deprecatedRequests" : [ ]
  3041. }, {
  3042. "description" : "Return geometric mean",
  3043. "name" : "GeoMean",
  3044. "deprecatedNames" : [ ],
  3045. "request" : {
  3046. "jsonSchema" : {
  3047. "type" : "object",
  3048. "properties" : {
  3049. "action" : {
  3050. "type" : "string",
  3051. "minLength" : 1
  3052. },
  3053. "table" : {
  3054. "type" : "string",
  3055. "minLength" : 1
  3056. },
  3057. "col" : {
  3058. "type" : "string",
  3059. "minLength" : 1
  3060. }
  3061. },
  3062. "id" : "#geomeanaction",
  3063. "additionalProperties" : false,
  3064. "title" : "Geo mean action",
  3065. "required" : [ "action", "table", "col" ]
  3066. },
  3067. "jsonExample" : "not implemented yet"
  3068. },
  3069. "deprecatedRequests" : [ ]
  3070. }, {
  3071. "description" : "Return a specific table",
  3072. "name" : "GetCompleteInMemoryFile",
  3073. "deprecatedNames" : [ ],
  3074. "request" : {
  3075. "jsonSchema" : {
  3076. "type" : "object",
  3077. "properties" : {
  3078. "action" : {
  3079. "type" : "string",
  3080. "minLength" : 1
  3081. },
  3082. "table" : {
  3083. "type" : "string",
  3084. "minLength" : 1
  3085. }
  3086. },
  3087. "id" : "#getfilerowlimitaction",
  3088. "additionalProperties" : false,
  3089. "title" : "Get file row limit action",
  3090. "required" : [ "action", "table" ]
  3091. },
  3092. "jsonExample" : "not implemented yet"
  3093. },
  3094. "deprecatedRequests" : [ ]
  3095. }, {
  3096. "description" : "Read file from a storage",
  3097. "name" : "GetFile",
  3098. "deprecatedNames" : [ ],
  3099. "request" : {
  3100. "jsonSchema" : {
  3101. "type" : "object",
  3102. "properties" : {
  3103. "action" : {
  3104. "type" : "string",
  3105. "minLength" : 1
  3106. },
  3107. "file" : {
  3108. "$ref" : "#/definitions/filerequest"
  3109. },
  3110. "fieldsMapping" : {
  3111. "type" : "array",
  3112. "items" : {
  3113. "$ref" : "#/definitions/field"
  3114. }
  3115. },
  3116. "delimiter" : {
  3117. "type" : "string",
  3118. "minLength" : 1
  3119. },
  3120. "addIndexColumn" : {
  3121. "type" : "boolean"
  3122. }
  3123. },
  3124. "id" : "#getfilerequest",
  3125. "additionalProperties" : false,
  3126. "title" : "Get file request",
  3127. "required" : [ "action", "file" ],
  3128. "definitions" : {
  3129. "acceptabletype" : {
  3130. "anyOf" : [ {
  3131. "$ref" : "#/definitions/tauto"
  3132. }, {
  3133. "$ref" : "#/definitions/tboolean"
  3134. }, {
  3135. "$ref" : "#/definitions/tdate"
  3136. }, {
  3137. "$ref" : "#/definitions/tdatewithformat"
  3138. }, {
  3139. "$ref" : "#/definitions/tdouble"
  3140. }, {
  3141. "$ref" : "#/definitions/tlong"
  3142. }, {
  3143. "$ref" : "#/definitions/tnull"
  3144. }, {
  3145. "$ref" : "#/definitions/tstring"
  3146. } ]
  3147. },
  3148. "field" : {
  3149. "type" : "object",
  3150. "properties" : {
  3151. "oldName" : {
  3152. "type" : "string",
  3153. "minLength" : 1
  3154. },
  3155. "newName" : {
  3156. "type" : "string",
  3157. "minLength" : 1
  3158. },
  3159. "fieldType" : {
  3160. "$ref" : "#/definitions/acceptabletype"
  3161. },
  3162. "dateFormat" : {
  3163. "type" : "string",
  3164. "minLength" : 1
  3165. }
  3166. },
  3167. "id" : "#field",
  3168. "additionalProperties" : false,
  3169. "title" : "Field",
  3170. "required" : [ "oldName", "newName", "fieldType" ]
  3171. },
  3172. "filerequest" : {
  3173. "type" : "object",
  3174. "properties" : {
  3175. "file" : {
  3176. "type" : "string",
  3177. "minLength" : 1
  3178. },
  3179. "storage" : {
  3180. "type" : "string",
  3181. "minLength" : 1
  3182. }
  3183. },
  3184. "id" : "#filerequest",
  3185. "additionalProperties" : false,
  3186. "title" : "File request",
  3187. "required" : [ "file", "storage" ]
  3188. },
  3189. "tauto" : {
  3190. "type" : "string",
  3191. "minLength" : 1,
  3192. "enum" : [ "Auto" ]
  3193. },
  3194. "tboolean" : {
  3195. "type" : "string",
  3196. "minLength" : 1,
  3197. "enum" : [ "Boolean" ]
  3198. },
  3199. "tdate" : {
  3200. "type" : "string",
  3201. "minLength" : 1,
  3202. "enum" : [ "Date" ]
  3203. },
  3204. "tdatewithformat" : {
  3205. "type" : "object",
  3206. "properties" : {
  3207. "dateFormat" : {
  3208. "type" : "string",
  3209. "minLength" : 1
  3210. },
  3211. "type" : {
  3212. "enum" : [ "DateWithFormat" ],
  3213. "type" : "string"
  3214. }
  3215. },
  3216. "id" : "#tdatewithformat",
  3217. "additionalProperties" : false,
  3218. "title" : "T date with format",
  3219. "required" : [ "dateFormat", "type" ]
  3220. },
  3221. "tdouble" : {
  3222. "type" : "string",
  3223. "minLength" : 1,
  3224. "enum" : [ "Number" ]
  3225. },
  3226. "tlong" : {
  3227. "type" : "string",
  3228. "minLength" : 1,
  3229. "enum" : [ "Long" ]
  3230. },
  3231. "tnull" : {
  3232. "type" : "string",
  3233. "minLength" : 1,
  3234. "enum" : [ "Null" ]
  3235. },
  3236. "tstring" : {
  3237. "type" : "string",
  3238. "minLength" : 1,
  3239. "enum" : [ "String" ]
  3240. }
  3241. }
  3242. },
  3243. "jsonExample" : "not implemented yet"
  3244. },
  3245. "deprecatedRequests" : [ {
  3246. "jsonSchema" : {
  3247. "type" : "object",
  3248. "properties" : {
  3249. "action" : {
  3250. "type" : "string",
  3251. "minLength" : 1
  3252. },
  3253. "file" : {
  3254. "type" : "string",
  3255. "minLength" : 1
  3256. },
  3257. "store" : {
  3258. "type" : "string",
  3259. "minLength" : 1
  3260. },
  3261. "fieldsMapping" : {
  3262. "type" : "array",
  3263. "items" : {
  3264. "$ref" : "#/definitions/field"
  3265. }
  3266. },
  3267. "delimiter" : {
  3268. "type" : "string",
  3269. "minLength" : 1
  3270. },
  3271. "add_index_col" : {
  3272. "type" : "boolean"
  3273. }
  3274. },
  3275. "id" : "#getfileoldrequest1",
  3276. "additionalProperties" : false,
  3277. "title" : "Get file old request1",
  3278. "required" : [ "action", "file", "store" ],
  3279. "definitions" : {
  3280. "acceptabletype" : {
  3281. "anyOf" : [ {
  3282. "$ref" : "#/definitions/tauto"
  3283. }, {
  3284. "$ref" : "#/definitions/tboolean"
  3285. }, {
  3286. "$ref" : "#/definitions/tdate"
  3287. }, {
  3288. "$ref" : "#/definitions/tdatewithformat"
  3289. }, {
  3290. "$ref" : "#/definitions/tdouble"
  3291. }, {
  3292. "$ref" : "#/definitions/tlong"
  3293. }, {
  3294. "$ref" : "#/definitions/tnull"
  3295. }, {
  3296. "$ref" : "#/definitions/tstring"
  3297. } ]
  3298. },
  3299. "field" : {
  3300. "type" : "object",
  3301. "properties" : {
  3302. "oldName" : {
  3303. "type" : "string",
  3304. "minLength" : 1
  3305. },
  3306. "newName" : {
  3307. "type" : "string",
  3308. "minLength" : 1
  3309. },
  3310. "fieldType" : {
  3311. "$ref" : "#/definitions/acceptabletype"
  3312. },
  3313. "dateFormat" : {
  3314. "type" : "string",
  3315. "minLength" : 1
  3316. }
  3317. },
  3318. "id" : "#field",
  3319. "additionalProperties" : false,
  3320. "title" : "Field",
  3321. "required" : [ "oldName", "newName", "fieldType" ]
  3322. },
  3323. "tauto" : {
  3324. "type" : "string",
  3325. "minLength" : 1,
  3326. "enum" : [ "Auto" ]
  3327. },
  3328. "tboolean" : {
  3329. "type" : "string",
  3330. "minLength" : 1,
  3331. "enum" : [ "Boolean" ]
  3332. },
  3333. "tdate" : {
  3334. "type" : "string",
  3335. "minLength" : 1,
  3336. "enum" : [ "Date" ]
  3337. },
  3338. "tdatewithformat" : {
  3339. "type" : "object",
  3340. "properties" : {
  3341. "dateFormat" : {
  3342. "type" : "string",
  3343. "minLength" : 1
  3344. },
  3345. "type" : {
  3346. "enum" : [ "DateWithFormat" ],
  3347. "type" : "string"
  3348. }
  3349. },
  3350. "id" : "#tdatewithformat",
  3351. "additionalProperties" : false,
  3352. "title" : "T date with format",
  3353. "required" : [ "dateFormat", "type" ]
  3354. },
  3355. "tdouble" : {
  3356. "type" : "string",
  3357. "minLength" : 1,
  3358. "enum" : [ "Number" ]
  3359. },
  3360. "tlong" : {
  3361. "type" : "string",
  3362. "minLength" : 1,
  3363. "enum" : [ "Long" ]
  3364. },
  3365. "tnull" : {
  3366. "type" : "string",
  3367. "minLength" : 1,
  3368. "enum" : [ "Null" ]
  3369. },
  3370. "tstring" : {
  3371. "type" : "string",
  3372. "minLength" : 1,
  3373. "enum" : [ "String" ]
  3374. }
  3375. }
  3376. },
  3377. "jsonExample" : "not implemented yet"
  3378. }, {
  3379. "jsonSchema" : {
  3380. "type" : "object",
  3381. "properties" : {
  3382. "action" : {
  3383. "type" : "string",
  3384. "minLength" : 1
  3385. },
  3386. "file" : {
  3387. "type" : "string",
  3388. "minLength" : 1
  3389. },
  3390. "store" : {
  3391. "type" : "string",
  3392. "minLength" : 1
  3393. },
  3394. "fieldsMapping" : {
  3395. "type" : "array",
  3396. "items" : {
  3397. "$ref" : "#/definitions/field"
  3398. }
  3399. },
  3400. "delimiter" : {
  3401. "type" : "string",
  3402. "minLength" : 1
  3403. },
  3404. "addIndexColumn" : {
  3405. "type" : "boolean"
  3406. }
  3407. },
  3408. "id" : "#getfileoldrequest2",
  3409. "additionalProperties" : false,
  3410. "title" : "Get file old request2",
  3411. "required" : [ "action", "file", "store" ],
  3412. "definitions" : {
  3413. "acceptabletype" : {
  3414. "anyOf" : [ {
  3415. "$ref" : "#/definitions/tauto"
  3416. }, {
  3417. "$ref" : "#/definitions/tboolean"
  3418. }, {
  3419. "$ref" : "#/definitions/tdate"
  3420. }, {
  3421. "$ref" : "#/definitions/tdatewithformat"
  3422. }, {
  3423. "$ref" : "#/definitions/tdouble"
  3424. }, {
  3425. "$ref" : "#/definitions/tlong"
  3426. }, {
  3427. "$ref" : "#/definitions/tnull"
  3428. }, {
  3429. "$ref" : "#/definitions/tstring"
  3430. } ]
  3431. },
  3432. "field" : {
  3433. "type" : "object",
  3434. "properties" : {
  3435. "oldName" : {
  3436. "type" : "string",
  3437. "minLength" : 1
  3438. },
  3439. "newName" : {
  3440. "type" : "string",
  3441. "minLength" : 1
  3442. },
  3443. "fieldType" : {
  3444. "$ref" : "#/definitions/acceptabletype"
  3445. },
  3446. "dateFormat" : {
  3447. "type" : "string",
  3448. "minLength" : 1
  3449. }
  3450. },
  3451. "id" : "#field",
  3452. "additionalProperties" : false,
  3453. "title" : "Field",
  3454. "required" : [ "oldName", "newName", "fieldType" ]
  3455. },
  3456. "tauto" : {
  3457. "type" : "string",
  3458. "minLength" : 1,
  3459. "enum" : [ "Auto" ]
  3460. },
  3461. "tboolean" : {
  3462. "type" : "string",
  3463. "minLength" : 1,
  3464. "enum" : [ "Boolean" ]
  3465. },
  3466. "tdate" : {
  3467. "type" : "string",
  3468. "minLength" : 1,
  3469. "enum" : [ "Date" ]
  3470. },
  3471. "tdatewithformat" : {
  3472. "type" : "object",
  3473. "properties" : {
  3474. "dateFormat" : {
  3475. "type" : "string",
  3476. "minLength" : 1
  3477. },
  3478. "type" : {
  3479. "enum" : [ "DateWithFormat" ],
  3480. "type" : "string"
  3481. }
  3482. },
  3483. "id" : "#tdatewithformat",
  3484. "additionalProperties" : false,
  3485. "title" : "T date with format",
  3486. "required" : [ "dateFormat", "type" ]
  3487. },
  3488. "tdouble" : {
  3489. "type" : "string",
  3490. "minLength" : 1,
  3491. "enum" : [ "Number" ]
  3492. },
  3493. "tlong" : {
  3494. "type" : "string",
  3495. "minLength" : 1,
  3496. "enum" : [ "Long" ]
  3497. },
  3498. "tnull" : {
  3499. "type" : "string",
  3500. "minLength" : 1,
  3501. "enum" : [ "Null" ]
  3502. },
  3503. "tstring" : {
  3504. "type" : "string",
  3505. "minLength" : 1,
  3506. "enum" : [ "String" ]
  3507. }
  3508. }
  3509. },
  3510. "jsonExample" : "not implemented yet"
  3511. } ]
  3512. }, {
  3513. "description" : "Return n distinct rows",
  3514. "name" : "GetNDistinctRows",
  3515. "deprecatedNames" : [ ],
  3516. "request" : {
  3517. "jsonSchema" : {
  3518. "type" : "object",
  3519. "properties" : {
  3520. "action" : {
  3521. "type" : "string",
  3522. "minLength" : 1
  3523. },
  3524. "table" : {
  3525. "type" : "string",
  3526. "minLength" : 1
  3527. },
  3528. "rowsCount" : {
  3529. "type" : "number"
  3530. },
  3531. "columnName" : {
  3532. "type" : "string",
  3533. "minLength" : 1
  3534. },
  3535. "filterValues" : {
  3536. "type" : "array",
  3537. "items" : {
  3538. "type" : "string",
  3539. "minLength" : 1
  3540. }
  3541. }
  3542. },
  3543. "id" : "#getndistinctrowsaction",
  3544. "additionalProperties" : false,
  3545. "title" : "Get n distinct rows action",
  3546. "required" : [ "action", "table", "rowsCount", "columnName" ]
  3547. },
  3548. "jsonExample" : "not implemented yet"
  3549. },
  3550. "deprecatedRequests" : [ ]
  3551. }, {
  3552. "description" : "not implemented yet",
  3553. "name" : "GetSystemInfo",
  3554. "deprecatedNames" : [ ],
  3555. "request" : {
  3556. "jsonSchema" : {
  3557. "type" : "object",
  3558. "properties" : {
  3559. "action" : {
  3560. "type" : "string",
  3561. "minLength" : 1
  3562. }
  3563. },
  3564. "id" : "#getsysteminfoaction",
  3565. "additionalProperties" : false,
  3566. "title" : "Get system info action",
  3567. "required" : [ "action" ]
  3568. },
  3569. "jsonExample" : "not implemented yet"
  3570. },
  3571. "deprecatedRequests" : [ ]
  3572. }, {
  3573. "description" : "Similar to 'group by' from sql",
  3574. "name" : "GroupBy",
  3575. "deprecatedNames" : [ ],
  3576. "request" : {
  3577. "jsonSchema" : {
  3578. "type" : "object",
  3579. "properties" : {
  3580. "action" : {
  3581. "type" : "string",
  3582. "minLength" : 1
  3583. },
  3584. "table" : {
  3585. "type" : "string",
  3586. "minLength" : 1
  3587. },
  3588. "operations" : {
  3589. "type" : "array",
  3590. "items" : {
  3591. "$ref" : "#/definitions/operation"
  3592. }
  3593. },
  3594. "group" : {
  3595. "type" : "array",
  3596. "items" : {
  3597. "type" : "string",
  3598. "minLength" : 1
  3599. }
  3600. }
  3601. },
  3602. "id" : "#groupbyaction",
  3603. "additionalProperties" : false,
  3604. "title" : "Group by action",
  3605. "required" : [ "action", "table", "operations", "group" ],
  3606. "definitions" : {
  3607. "average" : {
  3608. "type" : "object",
  3609. "properties" : {
  3610. "col" : {
  3611. "type" : "string",
  3612. "minLength" : 1
  3613. },
  3614. "function" : {
  3615. "enum" : [ "Average" ],
  3616. "type" : "string"
  3617. }
  3618. },
  3619. "id" : "#average",
  3620. "additionalProperties" : false,
  3621. "title" : "Average",
  3622. "required" : [ "col", "function" ]
  3623. },
  3624. "count" : {
  3625. "type" : "object",
  3626. "properties" : {
  3627. "col" : {
  3628. "type" : "string",
  3629. "minLength" : 1
  3630. },
  3631. "function" : {
  3632. "enum" : [ "Count" ],
  3633. "type" : "string"
  3634. }
  3635. },
  3636. "id" : "#count",
  3637. "additionalProperties" : false,
  3638. "title" : "Count",
  3639. "required" : [ "col", "function" ]
  3640. },
  3641. "counta" : {
  3642. "type" : "object",
  3643. "properties" : {
  3644. "col" : {
  3645. "type" : "string",
  3646. "minLength" : 1
  3647. },
  3648. "function" : {
  3649. "enum" : [ "Counta" ],
  3650. "type" : "string"
  3651. }
  3652. },
  3653. "id" : "#counta",
  3654. "additionalProperties" : false,
  3655. "title" : "Counta",
  3656. "required" : [ "col", "function" ]
  3657. },
  3658. "countunique" : {
  3659. "type" : "object",
  3660. "properties" : {
  3661. "col" : {
  3662. "type" : "string",
  3663. "minLength" : 1
  3664. },
  3665. "function" : {
  3666. "enum" : [ "Countunique" ],
  3667. "type" : "string"
  3668. }
  3669. },
  3670. "id" : "#countunique",
  3671. "additionalProperties" : false,
  3672. "title" : "Countunique",
  3673. "required" : [ "col", "function" ]
  3674. },
  3675. "max" : {
  3676. "type" : "object",
  3677. "properties" : {
  3678. "col" : {
  3679. "type" : "string",
  3680. "minLength" : 1
  3681. },
  3682. "function" : {
  3683. "enum" : [ "Max" ],
  3684. "type" : "string"
  3685. }
  3686. },
  3687. "id" : "#max",
  3688. "additionalProperties" : false,
  3689. "title" : "Max",
  3690. "required" : [ "col", "function" ]
  3691. },
  3692. "median" : {
  3693. "type" : "object",
  3694. "properties" : {
  3695. "col" : {
  3696. "type" : "string",
  3697. "minLength" : 1
  3698. },
  3699. "function" : {
  3700. "enum" : [ "Median" ],
  3701. "type" : "string"
  3702. }
  3703. },
  3704. "id" : "#median",
  3705. "additionalProperties" : false,
  3706. "title" : "Median",
  3707. "required" : [ "col", "function" ]
  3708. },
  3709. "min" : {
  3710. "type" : "object",
  3711. "properties" : {
  3712. "col" : {
  3713. "type" : "string",
  3714. "minLength" : 1
  3715. },
  3716. "function" : {
  3717. "enum" : [ "Min" ],
  3718. "type" : "string"
  3719. }
  3720. },
  3721. "id" : "#min",
  3722. "additionalProperties" : false,
  3723. "title" : "Min",
  3724. "required" : [ "col", "function" ]
  3725. },
  3726. "operation" : {
  3727. "anyOf" : [ {
  3728. "$ref" : "#/definitions/average"
  3729. }, {
  3730. "$ref" : "#/definitions/count"
  3731. }, {
  3732. "$ref" : "#/definitions/counta"
  3733. }, {
  3734. "$ref" : "#/definitions/countunique"
  3735. }, {
  3736. "$ref" : "#/definitions/max"
  3737. }, {
  3738. "$ref" : "#/definitions/median"
  3739. }, {
  3740. "$ref" : "#/definitions/min"
  3741. }, {
  3742. "$ref" : "#/definitions/sum"
  3743. } ]
  3744. },
  3745. "sum" : {
  3746. "type" : "object",
  3747. "properties" : {
  3748. "col" : {
  3749. "type" : "string",
  3750. "minLength" : 1
  3751. },
  3752. "function" : {
  3753. "enum" : [ "Sum" ],
  3754. "type" : "string"
  3755. }
  3756. },
  3757. "id" : "#sum",
  3758. "additionalProperties" : false,
  3759. "title" : "Sum",
  3760. "required" : [ "col", "function" ]
  3761. }
  3762. }
  3763. },
  3764. "jsonExample" : "not implemented yet"
  3765. },
  3766. "deprecatedRequests" : [ ]
  3767. }, {
  3768. "description" : "not implemented yet",
  3769. "name" : "InferSchema",
  3770. "deprecatedNames" : [ ],
  3771. "request" : {
  3772. "jsonSchema" : {
  3773. "type" : "object",
  3774. "properties" : {
  3775. "action" : {
  3776. "type" : "string",
  3777. "minLength" : 1
  3778. },
  3779. "table" : {
  3780. "type" : "string",
  3781. "minLength" : 1
  3782. }
  3783. },
  3784. "id" : "#inferschemaaction",
  3785. "additionalProperties" : false,
  3786. "title" : "Infer schema action",
  3787. "required" : [ "action", "table" ]
  3788. },
  3789. "jsonExample" : "not implemented yet"
  3790. },
  3791. "deprecatedRequests" : [ ]
  3792. }, {
  3793. "description" : "Join tables",
  3794. "name" : "JoinTables",
  3795. "deprecatedNames" : [ ],
  3796. "request" : {
  3797. "jsonSchema" : {
  3798. "type" : "object",
  3799. "properties" : {
  3800. "action" : {
  3801. "type" : "string",
  3802. "minLength" : 1
  3803. },
  3804. "table1" : {
  3805. "type" : "string",
  3806. "minLength" : 1
  3807. },
  3808. "table2" : {
  3809. "type" : "string",
  3810. "minLength" : 1
  3811. },
  3812. "join_type" : {
  3813. "$ref" : "#/definitions/join"
  3814. },
  3815. "joincolumns" : {
  3816. "type" : "array",
  3817. "items" : {
  3818. "$ref" : "#/definitions/joincolumns"
  3819. }
  3820. }
  3821. },
  3822. "id" : "#jointablesaction",
  3823. "additionalProperties" : false,
  3824. "title" : "Join tables action",
  3825. "required" : [ "action", "table1", "table2", "join_type", "joincolumns" ],
  3826. "definitions" : {
  3827. "fullouter" : {
  3828. "type" : "string",
  3829. "minLength" : 1,
  3830. "enum" : [ "FullOuter" ]
  3831. },
  3832. "inner" : {
  3833. "type" : "string",
  3834. "minLength" : 1,
  3835. "enum" : [ "Inner" ]
  3836. },
  3837. "join" : {
  3838. "anyOf" : [ {
  3839. "$ref" : "#/definitions/fullouter"
  3840. }, {
  3841. "$ref" : "#/definitions/inner"
  3842. }, {
  3843. "$ref" : "#/definitions/leftanti"
  3844. }, {
  3845. "$ref" : "#/definitions/leftouter"
  3846. }, {
  3847. "$ref" : "#/definitions/rightanti"
  3848. }, {
  3849. "$ref" : "#/definitions/rightouter"
  3850. } ]
  3851. },
  3852. "joincolumns" : {
  3853. "type" : "object",
  3854. "properties" : {
  3855. "table1field" : {
  3856. "type" : "string",
  3857. "minLength" : 1
  3858. },
  3859. "table2field" : {
  3860. "type" : "string",
  3861. "minLength" : 1
  3862. }
  3863. },
  3864. "id" : "#joincolumns",
  3865. "additionalProperties" : false,
  3866. "title" : "Join columns",
  3867. "required" : [ "table1field", "table2field" ]
  3868. },
  3869. "leftanti" : {
  3870. "type" : "string",
  3871. "minLength" : 1,
  3872. "enum" : [ "LeftAnti" ]
  3873. },
  3874. "leftouter" : {
  3875. "type" : "string",
  3876. "minLength" : 1,
  3877. "enum" : [ "LeftOuter" ]
  3878. },
  3879. "rightanti" : {
  3880. "type" : "string",
  3881. "minLength" : 1,
  3882. "enum" : [ "RightAnti" ]
  3883. },
  3884. "rightouter" : {
  3885. "type" : "string",
  3886. "minLength" : 1,
  3887. "enum" : [ "RightOuter" ]
  3888. }
  3889. }
  3890. },
  3891. "jsonExample" : "not implemented yet"
  3892. },
  3893. "deprecatedRequests" : [ ]
  3894. }, {
  3895. "description" : "Return the kurtosis of the values in a group",
  3896. "name" : "Kurtosis",
  3897. "deprecatedNames" : [ ],
  3898. "request" : {
  3899. "jsonSchema" : {
  3900. "type" : "object",
  3901. "properties" : {
  3902. "action" : {
  3903. "type" : "string",
  3904. "minLength" : 1
  3905. },
  3906. "table" : {
  3907. "type" : "string",
  3908. "minLength" : 1
  3909. },
  3910. "col" : {
  3911. "type" : "string",
  3912. "minLength" : 1
  3913. }
  3914. },
  3915. "id" : "#kurtosisaction",
  3916. "additionalProperties" : false,
  3917. "title" : "Kurtosis action",
  3918. "required" : [ "action", "table", "col" ]
  3919. },
  3920. "jsonExample" : "not implemented yet"
  3921. },
  3922. "deprecatedRequests" : [ ]
  3923. }, {
  3924. "description" : "Check if a value in the column matches the value (or values from another column) specified in the request or not",
  3925. "name" : "Lookup",
  3926. "deprecatedNames" : [ ],
  3927. "request" : {
  3928. "jsonSchema" : {
  3929. "type" : "object",
  3930. "properties" : {
  3931. "action" : {
  3932. "type" : "string",
  3933. "minLength" : 1
  3934. },
  3935. "table" : {
  3936. "type" : "string",
  3937. "minLength" : 1
  3938. },
  3939. "target_table" : {
  3940. "type" : "string",
  3941. "minLength" : 1
  3942. },
  3943. "lookup_table" : {
  3944. "type" : "string",
  3945. "minLength" : 1
  3946. },
  3947. "lookup_column" : {
  3948. "type" : "string",
  3949. "minLength" : 1
  3950. },
  3951. "target_column" : {
  3952. "type" : "string",
  3953. "minLength" : 1
  3954. },
  3955. "new_column" : {
  3956. "type" : "string",
  3957. "minLength" : 1
  3958. },
  3959. "field_match_value" : {
  3960. "type" : "string",
  3961. "minLength" : 1
  3962. },
  3963. "field_match_column" : {
  3964. "type" : "string",
  3965. "minLength" : 1
  3966. },
  3967. "field_not_match_value" : {
  3968. "type" : "string",
  3969. "minLength" : 1
  3970. }
  3971. },
  3972. "id" : "#lookupaction",
  3973. "additionalProperties" : false,
  3974. "title" : "Lookup action",
  3975. "required" : [ "action", "table", "target_table", "lookup_table", "lookup_column", "target_column", "new_column", "field_not_match_value" ]
  3976. },
  3977. "jsonExample" : "not implemented yet"
  3978. },
  3979. "deprecatedRequests" : [ ]
  3980. }, {
  3981. "description" : "Convert a column to lower case",
  3982. "name" : "LowerCase",
  3983. "deprecatedNames" : [ ],
  3984. "request" : {
  3985. "jsonSchema" : {
  3986. "type" : "object",
  3987. "properties" : {
  3988. "action" : {
  3989. "type" : "string",
  3990. "minLength" : 1
  3991. },
  3992. "table" : {
  3993. "type" : "string",
  3994. "minLength" : 1
  3995. },
  3996. "col" : {
  3997. "type" : "string",
  3998. "minLength" : 1
  3999. }
  4000. },
  4001. "id" : "#lowercaseaction",
  4002. "additionalProperties" : false,
  4003. "title" : "Lower case action",
  4004. "required" : [ "action", "table", "col" ]
  4005. },
  4006. "jsonExample" : "not implemented yet"
  4007. },
  4008. "deprecatedRequests" : [ ]
  4009. }, {
  4010. "description" : "Map values of a table",
  4011. "name" : "MapValues",
  4012. "deprecatedNames" : [ ],
  4013. "request" : {
  4014. "jsonSchema" : {
  4015. "type" : "object",
  4016. "properties" : {
  4017. "action" : {
  4018. "type" : "string",
  4019. "minLength" : 1
  4020. },
  4021. "table" : {
  4022. "type" : "string",
  4023. "minLength" : 1
  4024. },
  4025. "mapValues" : {
  4026. "type" : "array",
  4027. "items" : {
  4028. "$ref" : "#/definitions/mapvaluescolumnrequest"
  4029. }
  4030. }
  4031. },
  4032. "id" : "#mapvaluesfullrequest",
  4033. "additionalProperties" : false,
  4034. "title" : "Map values full request",
  4035. "required" : [ "action", "table", "mapValues" ],
  4036. "definitions" : {
  4037. "mapvalue" : {
  4038. "type" : "object",
  4039. "properties" : {
  4040. "from" : {
  4041. "type" : "string",
  4042. "minLength" : 1
  4043. },
  4044. "to" : {
  4045. "type" : "string",
  4046. "minLength" : 1
  4047. }
  4048. },
  4049. "id" : "#mapvalue",
  4050. "additionalProperties" : false,
  4051. "title" : "Map value",
  4052. "required" : [ "from", "to" ]
  4053. },
  4054. "mapvaluescolumnrequest" : {
  4055. "type" : "object",
  4056. "properties" : {
  4057. "columnFrom" : {
  4058. "type" : "string",
  4059. "minLength" : 1
  4060. },
  4061. "columnTo" : {
  4062. "type" : "string",
  4063. "minLength" : 1
  4064. },
  4065. "values" : {
  4066. "type" : "array",
  4067. "items" : {
  4068. "$ref" : "#/definitions/mapvalue"
  4069. }
  4070. }
  4071. },
  4072. "id" : "#mapvaluescolumnrequest",
  4073. "additionalProperties" : false,
  4074. "title" : "Map values column request",
  4075. "required" : [ "columnFrom", "columnTo", "values" ]
  4076. }
  4077. }
  4078. },
  4079. "jsonExample" : "not implemented yet"
  4080. },
  4081. "deprecatedRequests" : [ ]
  4082. }, {
  4083. "description" : "Job can map column types or add new columns",
  4084. "name" : "Mapping",
  4085. "deprecatedNames" : [ ],
  4086. "request" : {
  4087. "jsonSchema" : {
  4088. "type" : "object",
  4089. "properties" : {
  4090. "action" : {
  4091. "type" : "string",
  4092. "minLength" : 1
  4093. },
  4094. "table" : {
  4095. "type" : "string",
  4096. "minLength" : 1
  4097. },
  4098. "addNewColumns" : {
  4099. "type" : "array",
  4100. "items" : {
  4101. "$ref" : "#/definitions/addnewcolumn"
  4102. }
  4103. },
  4104. "fieldsMapping" : {
  4105. "type" : "array",
  4106. "items" : {
  4107. "$ref" : "#/definitions/field"
  4108. }
  4109. }
  4110. },
  4111. "id" : "#mappingrequest",
  4112. "additionalProperties" : false,
  4113. "title" : "Mapping request",
  4114. "required" : [ "action", "table", "fieldsMapping" ],
  4115. "definitions" : {
  4116. "acceptabletype" : {
  4117. "anyOf" : [ {
  4118. "$ref" : "#/definitions/tauto"
  4119. }, {
  4120. "$ref" : "#/definitions/tboolean"
  4121. }, {
  4122. "$ref" : "#/definitions/tdate"
  4123. }, {
  4124. "$ref" : "#/definitions/tdatewithformat"
  4125. }, {
  4126. "$ref" : "#/definitions/tdouble"
  4127. }, {
  4128. "$ref" : "#/definitions/tlong"
  4129. }, {
  4130. "$ref" : "#/definitions/tnull"
  4131. }, {
  4132. "$ref" : "#/definitions/tstring"
  4133. } ]
  4134. },
  4135. "addnewcolumn" : {
  4136. "type" : "object",
  4137. "properties" : {
  4138. "colName" : {
  4139. "type" : "string",
  4140. "minLength" : 1
  4141. },
  4142. "value" : {
  4143. "type" : "string",
  4144. "minLength" : 1
  4145. }
  4146. },
  4147. "id" : "#addnewcolumn",
  4148. "additionalProperties" : false,
  4149. "title" : "Add new column",
  4150. "required" : [ "colName", "value" ]
  4151. },
  4152. "field" : {
  4153. "type" : "object",
  4154. "properties" : {
  4155. "oldName" : {
  4156. "type" : "string",
  4157. "minLength" : 1
  4158. },
  4159. "newName" : {
  4160. "type" : "string",
  4161. "minLength" : 1
  4162. },
  4163. "fieldType" : {
  4164. "$ref" : "#/definitions/acceptabletype"
  4165. },
  4166. "dateFormat" : {
  4167. "type" : "string",
  4168. "minLength" : 1
  4169. }
  4170. },
  4171. "id" : "#field",
  4172. "additionalProperties" : false,
  4173. "title" : "Field",
  4174. "required" : [ "oldName", "newName", "fieldType" ]
  4175. },
  4176. "tauto" : {
  4177. "type" : "string",
  4178. "minLength" : 1,
  4179. "enum" : [ "Auto" ]
  4180. },
  4181. "tboolean" : {
  4182. "type" : "string",
  4183. "minLength" : 1,
  4184. "enum" : [ "Boolean" ]
  4185. },
  4186. "tdate" : {
  4187. "type" : "string",
  4188. "minLength" : 1,
  4189. "enum" : [ "Date" ]
  4190. },
  4191. "tdatewithformat" : {
  4192. "type" : "object",
  4193. "properties" : {
  4194. "dateFormat" : {
  4195. "type" : "string",
  4196. "minLength" : 1
  4197. },
  4198. "type" : {
  4199. "enum" : [ "DateWithFormat" ],
  4200. "type" : "string"
  4201. }
  4202. },
  4203. "id" : "#tdatewithformat",
  4204. "additionalProperties" : false,
  4205. "title" : "T date with format",
  4206. "required" : [ "dateFormat", "type" ]
  4207. },
  4208. "tdouble" : {
  4209. "type" : "string",
  4210. "minLength" : 1,
  4211. "enum" : [ "Number" ]
  4212. },
  4213. "tlong" : {
  4214. "type" : "string",
  4215. "minLength" : 1,
  4216. "enum" : [ "Long" ]
  4217. },
  4218. "tnull" : {
  4219. "type" : "string",
  4220. "minLength" : 1,
  4221. "enum" : [ "Null" ]
  4222. },
  4223. "tstring" : {
  4224. "type" : "string",
  4225. "minLength" : 1,
  4226. "enum" : [ "String" ]
  4227. }
  4228. }
  4229. },
  4230. "jsonExample" : "not implemented yet"
  4231. },
  4232. "deprecatedRequests" : [ ]
  4233. }, {
  4234. "description" : "Return the maximum value of the column in a group",
  4235. "name" : "Maximum",
  4236. "deprecatedNames" : [ ],
  4237. "request" : {
  4238. "jsonSchema" : {
  4239. "type" : "object",
  4240. "properties" : {
  4241. "action" : {
  4242. "type" : "string",
  4243. "minLength" : 1
  4244. },
  4245. "table" : {
  4246. "type" : "string",
  4247. "minLength" : 1
  4248. },
  4249. "col" : {
  4250. "type" : "string",
  4251. "minLength" : 1
  4252. }
  4253. },
  4254. "id" : "#maximumaction",
  4255. "additionalProperties" : false,
  4256. "title" : "Maximum action",
  4257. "required" : [ "action", "table", "col" ]
  4258. },
  4259. "jsonExample" : "not implemented yet"
  4260. },
  4261. "deprecatedRequests" : [ ]
  4262. }, {
  4263. "description" : "Return median value",
  4264. "name" : "Median",
  4265. "deprecatedNames" : [ ],
  4266. "request" : {
  4267. "jsonSchema" : {
  4268. "type" : "object",
  4269. "properties" : {
  4270. "action" : {
  4271. "type" : "string",
  4272. "minLength" : 1
  4273. },
  4274. "table" : {
  4275. "type" : "string",
  4276. "minLength" : 1
  4277. },
  4278. "col" : {
  4279. "type" : "string",
  4280. "minLength" : 1
  4281. }
  4282. },
  4283. "id" : "#medianaction",
  4284. "additionalProperties" : false,
  4285. "title" : "Median action",
  4286. "required" : [ "action", "table", "col" ]
  4287. },
  4288. "jsonExample" : "not implemented yet"
  4289. },
  4290. "deprecatedRequests" : [ ]
  4291. }, {
  4292. "description" : "Merge values from several columns into one",
  4293. "name" : "MergeColumns",
  4294. "deprecatedNames" : [ ],
  4295. "request" : {
  4296. "jsonSchema" : {
  4297. "type" : "object",
  4298. "properties" : {
  4299. "action" : {
  4300. "type" : "string",
  4301. "minLength" : 1
  4302. },
  4303. "table" : {
  4304. "type" : "string",
  4305. "minLength" : 1
  4306. },
  4307. "cols" : {
  4308. "type" : "array",
  4309. "items" : {
  4310. "type" : "string",
  4311. "minLength" : 1
  4312. }
  4313. },
  4314. "delimiter" : {
  4315. "type" : "string",
  4316. "minLength" : 1
  4317. },
  4318. "newcolumn" : {
  4319. "type" : "string",
  4320. "minLength" : 1
  4321. }
  4322. },
  4323. "id" : "#mergecolumnsaction",
  4324. "additionalProperties" : false,
  4325. "title" : "Merge columns action",
  4326. "required" : [ "action", "table", "cols" ]
  4327. },
  4328. "jsonExample" : "not implemented yet"
  4329. },
  4330. "deprecatedRequests" : [ ]
  4331. }, {
  4332. "description" : "Returns the minimum value of the column in a group",
  4333. "name" : "Minimum",
  4334. "deprecatedNames" : [ ],
  4335. "request" : {
  4336. "jsonSchema" : {
  4337. "type" : "object",
  4338. "properties" : {
  4339. "action" : {
  4340. "type" : "string",
  4341. "minLength" : 1
  4342. },
  4343. "table" : {
  4344. "type" : "string",
  4345. "minLength" : 1
  4346. },
  4347. "col" : {
  4348. "type" : "string",
  4349. "minLength" : 1
  4350. }
  4351. },
  4352. "id" : "#minimumaction",
  4353. "additionalProperties" : false,
  4354. "title" : "Minimum action",
  4355. "required" : [ "action", "table", "col" ]
  4356. },
  4357. "jsonExample" : "not implemented yet"
  4358. },
  4359. "deprecatedRequests" : [ ]
  4360. }, {
  4361. "description" : "Return most often occurred (mode) value",
  4362. "name" : "Mode",
  4363. "deprecatedNames" : [ ],
  4364. "request" : {
  4365. "jsonSchema" : {
  4366. "type" : "object",
  4367. "properties" : {
  4368. "action" : {
  4369. "type" : "string",
  4370. "minLength" : 1
  4371. },
  4372. "table" : {
  4373. "type" : "string",
  4374. "minLength" : 1
  4375. },
  4376. "col" : {
  4377. "type" : "string",
  4378. "minLength" : 1
  4379. }
  4380. },
  4381. "id" : "#modeaction",
  4382. "additionalProperties" : false,
  4383. "title" : "Mode action",
  4384. "required" : [ "action", "table", "col" ]
  4385. },
  4386. "jsonExample" : "not implemented yet"
  4387. },
  4388. "deprecatedRequests" : [ ]
  4389. }, {
  4390. "description" : "Return modulo",
  4391. "name" : "Modulo",
  4392. "deprecatedNames" : [ ],
  4393. "request" : {
  4394. "jsonSchema" : {
  4395. "type" : "object",
  4396. "properties" : {
  4397. "action" : {
  4398. "type" : "string",
  4399. "minLength" : 1
  4400. },
  4401. "table" : {
  4402. "type" : "string",
  4403. "minLength" : 1
  4404. },
  4405. "col" : {
  4406. "type" : "string",
  4407. "minLength" : 1
  4408. },
  4409. "number" : {
  4410. "type" : "number"
  4411. },
  4412. "precision" : {
  4413. "type" : "number"
  4414. },
  4415. "newcolumn" : {
  4416. "type" : "string",
  4417. "minLength" : 1
  4418. }
  4419. },
  4420. "id" : "#moduloaction",
  4421. "additionalProperties" : false,
  4422. "title" : "Modulo action",
  4423. "required" : [ "action", "table", "col", "number" ]
  4424. },
  4425. "jsonExample" : "not implemented yet"
  4426. },
  4427. "deprecatedRequests" : [ ]
  4428. }, {
  4429. "description" : "Return the month number in a year",
  4430. "name" : "MonthExtract",
  4431. "deprecatedNames" : [ ],
  4432. "request" : {
  4433. "jsonSchema" : {
  4434. "type" : "object",
  4435. "properties" : {
  4436. "action" : {
  4437. "type" : "string",
  4438. "minLength" : 1
  4439. },
  4440. "table" : {
  4441. "type" : "string",
  4442. "minLength" : 1
  4443. },
  4444. "col" : {
  4445. "type" : "string",
  4446. "minLength" : 1
  4447. },
  4448. "newcolumn" : {
  4449. "type" : "string",
  4450. "minLength" : 1
  4451. }
  4452. },
  4453. "id" : "#monthextractaction",
  4454. "additionalProperties" : false,
  4455. "title" : "Month extract action",
  4456. "required" : [ "action", "table", "col" ]
  4457. },
  4458. "jsonExample" : "not implemented yet"
  4459. },
  4460. "deprecatedRequests" : [ ]
  4461. }, {
  4462. "description" : "Move column",
  4463. "name" : "MoveColumn",
  4464. "deprecatedNames" : [ ],
  4465. "request" : {
  4466. "jsonSchema" : {
  4467. "type" : "object",
  4468. "properties" : {
  4469. "action" : {
  4470. "type" : "string",
  4471. "minLength" : 1
  4472. },
  4473. "table" : {
  4474. "type" : "string",
  4475. "minLength" : 1
  4476. },
  4477. "col" : {
  4478. "type" : "string",
  4479. "minLength" : 1
  4480. },
  4481. "neighbour_col" : {
  4482. "type" : "string",
  4483. "minLength" : 1
  4484. },
  4485. "placement" : {
  4486. "$ref" : "#/definitions/columnside"
  4487. }
  4488. },
  4489. "id" : "#movecolumnaction",
  4490. "additionalProperties" : false,
  4491. "title" : "Move column action",
  4492. "required" : [ "action", "table", "col", "placement" ],
  4493. "definitions" : {
  4494. "columnside" : {
  4495. "anyOf" : [ {
  4496. "$ref" : "#/definitions/endside"
  4497. }, {
  4498. "$ref" : "#/definitions/leftside"
  4499. }, {
  4500. "$ref" : "#/definitions/rightside"
  4501. }, {
  4502. "$ref" : "#/definitions/startside"
  4503. } ]
  4504. },
  4505. "endside" : {
  4506. "type" : "string",
  4507. "minLength" : 1,
  4508. "enum" : [ "end" ]
  4509. },
  4510. "leftside" : {
  4511. "type" : "string",
  4512. "minLength" : 1,
  4513. "enum" : [ "left" ]
  4514. },
  4515. "rightside" : {
  4516. "type" : "string",
  4517. "minLength" : 1,
  4518. "enum" : [ "right" ]
  4519. },
  4520. "startside" : {
  4521. "type" : "string",
  4522. "minLength" : 1,
  4523. "enum" : [ "start" ]
  4524. }
  4525. }
  4526. },
  4527. "jsonExample" : "not implemented yet"
  4528. },
  4529. "deprecatedRequests" : [ ]
  4530. }, {
  4531. "description" : "Move column one position to the left",
  4532. "name" : "MoveColumnLeft",
  4533. "deprecatedNames" : [ ],
  4534. "request" : {
  4535. "jsonSchema" : {
  4536. "type" : "object",
  4537. "properties" : {
  4538. "action" : {
  4539. "type" : "string",
  4540. "minLength" : 1
  4541. },
  4542. "table" : {
  4543. "type" : "string",
  4544. "minLength" : 1
  4545. },
  4546. "col" : {
  4547. "type" : "string",
  4548. "minLength" : 1
  4549. }
  4550. },
  4551. "id" : "#movecolumnleftaction",
  4552. "additionalProperties" : false,
  4553. "title" : "Move column left action",
  4554. "required" : [ "action", "table", "col" ]
  4555. },
  4556. "jsonExample" : "not implemented yet"
  4557. },
  4558. "deprecatedRequests" : [ ]
  4559. }, {
  4560. "description" : "Move column one position to the right",
  4561. "name" : "MoveColumnRight",
  4562. "deprecatedNames" : [ ],
  4563. "request" : {
  4564. "jsonSchema" : {
  4565. "type" : "object",
  4566. "properties" : {
  4567. "action" : {
  4568. "type" : "string",
  4569. "minLength" : 1
  4570. },
  4571. "table" : {
  4572. "type" : "string",
  4573. "minLength" : 1
  4574. },
  4575. "col" : {
  4576. "type" : "string",
  4577. "minLength" : 1
  4578. }
  4579. },
  4580. "id" : "#movecolumnrightaction",
  4581. "additionalProperties" : false,
  4582. "title" : "Move column right action",
  4583. "required" : [ "action", "table", "col" ]
  4584. },
  4585. "jsonExample" : "not implemented yet"
  4586. },
  4587. "deprecatedRequests" : [ ]
  4588. }, {
  4589. "description" : "Move file from one place to another",
  4590. "name" : "MoveFiles",
  4591. "deprecatedNames" : [ "MoveRawFileToRawTableDL" ],
  4592. "request" : {
  4593. "jsonSchema" : {
  4594. "type" : "object",
  4595. "properties" : {
  4596. "action" : {
  4597. "type" : "string",
  4598. "minLength" : 1
  4599. },
  4600. "filesToMove" : {
  4601. "type" : "array",
  4602. "items" : {
  4603. "$ref" : "#/definitions/sourceanddestinationrequest"
  4604. }
  4605. }
  4606. },
  4607. "id" : "#movefilesrequest",
  4608. "additionalProperties" : false,
  4609. "title" : "Move files request",
  4610. "required" : [ "action", "filesToMove" ],
  4611. "definitions" : {
  4612. "filerequest" : {
  4613. "type" : "object",
  4614. "properties" : {
  4615. "file" : {
  4616. "type" : "string",
  4617. "minLength" : 1
  4618. },
  4619. "storage" : {
  4620. "type" : "string",
  4621. "minLength" : 1
  4622. }
  4623. },
  4624. "id" : "#filerequest",
  4625. "additionalProperties" : false,
  4626. "title" : "File request",
  4627. "required" : [ "file", "storage" ]
  4628. },
  4629. "sourceanddestinationrequest" : {
  4630. "type" : "object",
  4631. "properties" : {
  4632. "source" : {
  4633. "$ref" : "#/definitions/filerequest"
  4634. },
  4635. "destination" : {
  4636. "$ref" : "#/definitions/filerequest"
  4637. },
  4638. "scheduleToken" : {
  4639. "type" : "string",
  4640. "minLength" : 1
  4641. }
  4642. },
  4643. "id" : "#sourceanddestinationrequest",
  4644. "additionalProperties" : false,
  4645. "title" : "Source and destination request",
  4646. "required" : [ "source", "destination" ]
  4647. }
  4648. }
  4649. },
  4650. "jsonExample" : "not implemented yet"
  4651. },
  4652. "deprecatedRequests" : [ {
  4653. "jsonSchema" : {
  4654. "type" : "object",
  4655. "properties" : {
  4656. "action" : {
  4657. "type" : "string",
  4658. "minLength" : 1
  4659. },
  4660. "store" : {
  4661. "type" : "string",
  4662. "minLength" : 1
  4663. },
  4664. "input_paths" : {
  4665. "type" : "array",
  4666. "items" : {
  4667. "$ref" : "#/definitions/inputpathfiletotabledl"
  4668. }
  4669. },
  4670. "output_path" : {
  4671. "type" : "string",
  4672. "minLength" : 1
  4673. }
  4674. },
  4675. "id" : "#movefilesrequestold",
  4676. "additionalProperties" : false,
  4677. "title" : "Move files request old",
  4678. "required" : [ "action", "store", "input_paths", "output_path" ],
  4679. "definitions" : {
  4680. "inputpathfiletotabledl" : {
  4681. "type" : "object",
  4682. "properties" : {
  4683. "path" : {
  4684. "type" : "string",
  4685. "minLength" : 1
  4686. },
  4687. "outputFileName" : {
  4688. "type" : "string",
  4689. "minLength" : 1
  4690. }
  4691. },
  4692. "id" : "#inputpathfiletotabledl",
  4693. "additionalProperties" : false,
  4694. "title" : "Input path file to table d l",
  4695. "required" : [ "path", "outputFileName" ]
  4696. }
  4697. }
  4698. },
  4699. "jsonExample" : "not implemented yet"
  4700. } ]
  4701. }, {
  4702. "description" : "Read data from several sources then union and then save into a single file",
  4703. "name" : "MoveFilesConsolidated",
  4704. "deprecatedNames" : [ "MoveRawTableToRawConsolidatedDL" ],
  4705. "request" : {
  4706. "jsonSchema" : {
  4707. "type" : "object",
  4708. "properties" : {
  4709. "action" : {
  4710. "type" : "string",
  4711. "minLength" : 1
  4712. },
  4713. "filesToMove" : {
  4714. "type" : "array",
  4715. "items" : {
  4716. "$ref" : "#/definitions/sourcesanddestinationrequest"
  4717. }
  4718. }
  4719. },
  4720. "id" : "#movefilesconsolidatedrequest",
  4721. "additionalProperties" : false,
  4722. "title" : "Move files consolidated request",
  4723. "required" : [ "action", "filesToMove" ],
  4724. "definitions" : {
  4725. "filerequest" : {
  4726. "type" : "object",
  4727. "properties" : {
  4728. "file" : {
  4729. "type" : "string",
  4730. "minLength" : 1
  4731. },
  4732. "storage" : {
  4733. "type" : "string",
  4734. "minLength" : 1
  4735. }
  4736. },
  4737. "id" : "#filerequest",
  4738. "additionalProperties" : false,
  4739. "title" : "File request",
  4740. "required" : [ "file", "storage" ]
  4741. },
  4742. "sourcesanddestinationrequest" : {
  4743. "type" : "object",
  4744. "properties" : {
  4745. "sourcesToUnion" : {
  4746. "type" : "array",
  4747. "items" : {
  4748. "$ref" : "#/definitions/filerequest"
  4749. }
  4750. },
  4751. "destination" : {
  4752. "$ref" : "#/definitions/filerequest"
  4753. }
  4754. },
  4755. "id" : "#sourcesanddestinationrequest",
  4756. "additionalProperties" : false,
  4757. "title" : "Sources and destination request",
  4758. "required" : [ "sourcesToUnion", "destination" ]
  4759. }
  4760. }
  4761. },
  4762. "jsonExample" : "not implemented yet"
  4763. },
  4764. "deprecatedRequests" : [ {
  4765. "jsonSchema" : {
  4766. "type" : "object",
  4767. "properties" : {
  4768. "action" : {
  4769. "type" : "string",
  4770. "minLength" : 1
  4771. },
  4772. "store" : {
  4773. "type" : "string",
  4774. "minLength" : 1
  4775. },
  4776. "input_paths" : {
  4777. "type" : "array",
  4778. "items" : {
  4779. "$ref" : "#/definitions/inputpathtabletoconsolidateddl"
  4780. }
  4781. },
  4782. "output_path" : {
  4783. "type" : "string",
  4784. "minLength" : 1
  4785. }
  4786. },
  4787. "id" : "#movefilesconsolidatedrequestold",
  4788. "additionalProperties" : false,
  4789. "title" : "Move files consolidated request old",
  4790. "required" : [ "action", "store", "input_paths", "output_path" ],
  4791. "definitions" : {
  4792. "inputpathtabletoconsolidateddl" : {
  4793. "type" : "object",
  4794. "properties" : {
  4795. "paths" : {
  4796. "type" : "array",
  4797. "items" : {
  4798. "type" : "string",
  4799. "minLength" : 1
  4800. }
  4801. },
  4802. "outputFileName" : {
  4803. "type" : "string",
  4804. "minLength" : 1
  4805. }
  4806. },
  4807. "id" : "#inputpathtabletoconsolidateddl",
  4808. "additionalProperties" : false,
  4809. "title" : "Input path table to consolidated d l",
  4810. "required" : [ "paths", "outputFileName" ]
  4811. }
  4812. }
  4813. },
  4814. "jsonExample" : "not implemented yet"
  4815. } ]
  4816. }, {
  4817. "description" : "Check if a value in the column matches the value (or values from another column) specified in the request or not",
  4818. "name" : "MultiColumnLookup",
  4819. "deprecatedNames" : [ ],
  4820. "request" : {
  4821. "jsonSchema" : {
  4822. "type" : "object",
  4823. "properties" : {
  4824. "action" : {
  4825. "type" : "string",
  4826. "minLength" : 1
  4827. },
  4828. "table" : {
  4829. "type" : "string",
  4830. "minLength" : 1
  4831. },
  4832. "lookupTable" : {
  4833. "type" : "string",
  4834. "minLength" : 1
  4835. },
  4836. "sourceColumn" : {
  4837. "type" : "string",
  4838. "minLength" : 1
  4839. },
  4840. "lookupColumns" : {
  4841. "type" : "array",
  4842. "items" : {
  4843. "type" : "string",
  4844. "minLength" : 1
  4845. }
  4846. },
  4847. "lookupTargetColumns" : {
  4848. "type" : "array",
  4849. "items" : {
  4850. "type" : "string",
  4851. "minLength" : 1
  4852. }
  4853. },
  4854. "targetColumns" : {
  4855. "type" : "array",
  4856. "items" : {
  4857. "type" : "string",
  4858. "minLength" : 1
  4859. }
  4860. }
  4861. },
  4862. "id" : "#multicolumnlookupaction",
  4863. "additionalProperties" : false,
  4864. "title" : "Multi column lookup action",
  4865. "required" : [ "action", "table", "lookupTable", "sourceColumn", "lookupColumns", "lookupTargetColumns", "targetColumns" ]
  4866. },
  4867. "jsonExample" : "not implemented yet"
  4868. },
  4869. "deprecatedRequests" : [ ]
  4870. }, {
  4871. "description" : "Multiply values in a column with the value for request",
  4872. "name" : "Multiply",
  4873. "deprecatedNames" : [ ],
  4874. "request" : {
  4875. "jsonSchema" : {
  4876. "type" : "object",
  4877. "properties" : {
  4878. "action" : {
  4879. "type" : "string",
  4880. "minLength" : 1
  4881. },
  4882. "table" : {
  4883. "type" : "string",
  4884. "minLength" : 1
  4885. },
  4886. "col" : {
  4887. "type" : "string",
  4888. "minLength" : 1
  4889. },
  4890. "number" : {
  4891. "type" : "number"
  4892. },
  4893. "precision" : {
  4894. "type" : "number"
  4895. },
  4896. "newcolumn" : {
  4897. "type" : "string",
  4898. "minLength" : 1
  4899. }
  4900. },
  4901. "id" : "#multiplyaction",
  4902. "additionalProperties" : false,
  4903. "title" : "Multiply action",
  4904. "required" : [ "action", "table", "col", "number" ]
  4905. },
  4906. "jsonExample" : "not implemented yet"
  4907. },
  4908. "deprecatedRequests" : [ ]
  4909. }, {
  4910. "description" : "Return the name of a day by date",
  4911. "name" : "NameOfDay",
  4912. "deprecatedNames" : [ ],
  4913. "request" : {
  4914. "jsonSchema" : {
  4915. "type" : "object",
  4916. "properties" : {
  4917. "action" : {
  4918. "type" : "string",
  4919. "minLength" : 1
  4920. },
  4921. "table" : {
  4922. "type" : "string",
  4923. "minLength" : 1
  4924. },
  4925. "col" : {
  4926. "type" : "string",
  4927. "minLength" : 1
  4928. },
  4929. "newcolumn" : {
  4930. "type" : "string",
  4931. "minLength" : 1
  4932. }
  4933. },
  4934. "id" : "#nameofdayaction",
  4935. "additionalProperties" : false,
  4936. "title" : "Name of day action",
  4937. "required" : [ "action", "table", "col" ]
  4938. },
  4939. "jsonExample" : "not implemented yet"
  4940. },
  4941. "deprecatedRequests" : [ ]
  4942. }, {
  4943. "description" : "Return name of the month",
  4944. "name" : "NameOfMonth",
  4945. "deprecatedNames" : [ ],
  4946. "request" : {
  4947. "jsonSchema" : {
  4948. "type" : "object",
  4949. "properties" : {
  4950. "action" : {
  4951. "type" : "string",
  4952. "minLength" : 1
  4953. },
  4954. "table" : {
  4955. "type" : "string",
  4956. "minLength" : 1
  4957. },
  4958. "col" : {
  4959. "type" : "string",
  4960. "minLength" : 1
  4961. },
  4962. "newcolumn" : {
  4963. "type" : "string",
  4964. "minLength" : 1
  4965. }
  4966. },
  4967. "id" : "#nameofmonthaction",
  4968. "additionalProperties" : false,
  4969. "title" : "Name of month action",
  4970. "required" : [ "action", "table", "col" ]
  4971. },
  4972. "jsonExample" : "not implemented yet"
  4973. },
  4974. "deprecatedRequests" : [ ]
  4975. }, {
  4976. "description" : "Return count of negative values",
  4977. "name" : "NegativeCount",
  4978. "deprecatedNames" : [ ],
  4979. "request" : {
  4980. "jsonSchema" : {
  4981. "type" : "object",
  4982. "properties" : {
  4983. "action" : {
  4984. "type" : "string",
  4985. "minLength" : 1
  4986. },
  4987. "table" : {
  4988. "type" : "string",
  4989. "minLength" : 1
  4990. },
  4991. "col" : {
  4992. "type" : "string",
  4993. "minLength" : 1
  4994. }
  4995. },
  4996. "id" : "#negativecountaction",
  4997. "additionalProperties" : false,
  4998. "title" : "Negative count action",
  4999. "required" : [ "action", "table", "col" ]
  5000. },
  5001. "jsonExample" : "not implemented yet"
  5002. },
  5003. "deprecatedRequests" : [ ]
  5004. }, {
  5005. "description" : "Add new conditional column",
  5006. "name" : "NewConditionalColumn",
  5007. "deprecatedNames" : [ ],
  5008. "request" : {
  5009. "jsonSchema" : {
  5010. "type" : "object",
  5011. "properties" : {
  5012. "action" : {
  5013. "type" : "string",
  5014. "minLength" : 1
  5015. },
  5016. "table" : {
  5017. "type" : "string",
  5018. "minLength" : 1
  5019. },
  5020. "if_groups" : {
  5021. "type" : "array",
  5022. "items" : {
  5023. "$ref" : "#/definitions/ifconditionalcolumn"
  5024. }
  5025. },
  5026. "otherwise_value" : {
  5027. "type" : "string",
  5028. "minLength" : 1
  5029. },
  5030. "otherwise_value_column" : {
  5031. "type" : "boolean"
  5032. },
  5033. "otherwise_value_expr" : {
  5034. "type" : "boolean"
  5035. },
  5036. "newcolumn" : {
  5037. "type" : "string",
  5038. "minLength" : 1
  5039. }
  5040. },
  5041. "id" : "#newconditionalcolumnaction",
  5042. "additionalProperties" : false,
  5043. "title" : "New conditional column action",
  5044. "required" : [ "action", "table", "if_groups", "otherwise_value_column" ],
  5045. "definitions" : {
  5046. "dateafter" : {
  5047. "type" : "string",
  5048. "minLength" : 1,
  5049. "enum" : [ "DateAfter" ]
  5050. },
  5051. "datebefore" : {
  5052. "type" : "string",
  5053. "minLength" : 1,
  5054. "enum" : [ "DateBefore" ]
  5055. },
  5056. "dateis" : {
  5057. "type" : "string",
  5058. "minLength" : 1,
  5059. "enum" : [ "DateIs" ]
  5060. },
  5061. "filter" : {
  5062. "type" : "object",
  5063. "properties" : {
  5064. "name" : {
  5065. "$ref" : "#/definitions/filtertype"
  5066. },
  5067. "value" : {
  5068. "type" : "string",
  5069. "minLength" : 1
  5070. },
  5071. "col" : {
  5072. "type" : "string",
  5073. "minLength" : 1
  5074. },
  5075. "isValueAColumn" : {
  5076. "type" : "boolean"
  5077. }
  5078. },
  5079. "id" : "#filter",
  5080. "additionalProperties" : false,
  5081. "title" : "Filter",
  5082. "required" : [ "name", "col" ]
  5083. },
  5084. "filtergroup" : {
  5085. "type" : "object",
  5086. "properties" : {
  5087. "filters" : {
  5088. "type" : "array",
  5089. "items" : {
  5090. "$ref" : "#/definitions/filter"
  5091. }
  5092. },
  5093. "grouping" : {
  5094. "type" : "string",
  5095. "minLength" : 1
  5096. },
  5097. "children" : {
  5098. "type" : "array",
  5099. "items" : {
  5100. "$ref" : "#/definitions/filtergroup"
  5101. }
  5102. }
  5103. },
  5104. "id" : "#filtergroup",
  5105. "additionalProperties" : false,
  5106. "title" : "Filter group",
  5107. "required" : [ "filters", "grouping", "children" ]
  5108. },
  5109. "filtertype" : {
  5110. "anyOf" : [ {
  5111. "$ref" : "#/definitions/dateafter"
  5112. }, {
  5113. "$ref" : "#/definitions/datebefore"
  5114. }, {
  5115. "$ref" : "#/definitions/dateis"
  5116. }, {
  5117. "$ref" : "#/definitions/greaterthen"
  5118. }, {
  5119. "$ref" : "#/definitions/greaterthenoreq"
  5120. }, {
  5121. "$ref" : "#/definitions/isbetween"
  5122. }, {
  5123. "$ref" : "#/definitions/iseq"
  5124. }, {
  5125. "$ref" : "#/definitions/isnotbetween"
  5126. }, {
  5127. "$ref" : "#/definitions/isnoteq"
  5128. }, {
  5129. "$ref" : "#/definitions/isnotnull"
  5130. }, {
  5131. "$ref" : "#/definitions/isnotunique"
  5132. }, {
  5133. "$ref" : "#/definitions/isnull"
  5134. }, {
  5135. "$ref" : "#/definitions/isunique"
  5136. }, {
  5137. "$ref" : "#/definitions/lessthen"
  5138. }, {
  5139. "$ref" : "#/definitions/lessthenoreq"
  5140. }, {
  5141. "$ref" : "#/definitions/textcontains"
  5142. }, {
  5143. "$ref" : "#/definitions/textends"
  5144. }, {
  5145. "$ref" : "#/definitions/textis"
  5146. }, {
  5147. "$ref" : "#/definitions/textisempty"
  5148. }, {
  5149. "$ref" : "#/definitions/textisnot"
  5150. }, {
  5151. "$ref" : "#/definitions/textisnotempty"
  5152. }, {
  5153. "$ref" : "#/definitions/textnotcontains"
  5154. }, {
  5155. "$ref" : "#/definitions/textnotends"
  5156. }, {
  5157. "$ref" : "#/definitions/textnotstarts"
  5158. }, {
  5159. "$ref" : "#/definitions/textstarts"
  5160. } ]
  5161. },
  5162. "greaterthen" : {
  5163. "type" : "string",
  5164. "minLength" : 1,
  5165. "enum" : [ "GreaterThen" ]
  5166. },
  5167. "greaterthenoreq" : {
  5168. "type" : "string",
  5169. "minLength" : 1,
  5170. "enum" : [ "GreaterThenOrEq" ]
  5171. },
  5172. "ifconditionalcolumn" : {
  5173. "type" : "object",
  5174. "properties" : {
  5175. "ifexpressiongroup" : {
  5176. "$ref" : "#/definitions/filtergroup"
  5177. },
  5178. "true_value" : {
  5179. "type" : "string",
  5180. "minLength" : 1
  5181. },
  5182. "true_value_column" : {
  5183. "type" : "boolean"
  5184. },
  5185. "true_value_expression" : {
  5186. "type" : "boolean"
  5187. }
  5188. },
  5189. "id" : "#ifconditionalcolumn",
  5190. "additionalProperties" : false,
  5191. "title" : "If conditional column",
  5192. "required" : [ "ifexpressiongroup", "true_value_column" ]
  5193. },
  5194. "isbetween" : {
  5195. "type" : "string",
  5196. "minLength" : 1,
  5197. "enum" : [ "IsBetween" ]
  5198. },
  5199. "iseq" : {
  5200. "type" : "string",
  5201. "minLength" : 1,
  5202. "enum" : [ "IsEq" ]
  5203. },
  5204. "isnotbetween" : {
  5205. "type" : "string",
  5206. "minLength" : 1,
  5207. "enum" : [ "IsNotBetween" ]
  5208. },
  5209. "isnoteq" : {
  5210. "type" : "string",
  5211. "minLength" : 1,
  5212. "enum" : [ "IsNotEq" ]
  5213. },
  5214. "isnotnull" : {
  5215. "type" : "string",
  5216. "minLength" : 1,
  5217. "enum" : [ "IsNotNull" ]
  5218. },
  5219. "isnotunique" : {
  5220. "type" : "string",
  5221. "minLength" : 1,
  5222. "enum" : [ "IsNotUnique" ]
  5223. },
  5224. "isnull" : {
  5225. "type" : "string",
  5226. "minLength" : 1,
  5227. "enum" : [ "IsNull" ]
  5228. },
  5229. "isunique" : {
  5230. "type" : "string",
  5231. "minLength" : 1,
  5232. "enum" : [ "IsUnique" ]
  5233. },
  5234. "lessthen" : {
  5235. "type" : "string",
  5236. "minLength" : 1,
  5237. "enum" : [ "LessThen" ]
  5238. },
  5239. "lessthenoreq" : {
  5240. "type" : "string",
  5241. "minLength" : 1,
  5242. "enum" : [ "LessThenOrEq" ]
  5243. },
  5244. "textcontains" : {
  5245. "type" : "string",
  5246. "minLength" : 1,
  5247. "enum" : [ "TextContains" ]
  5248. },
  5249. "textends" : {
  5250. "type" : "string",
  5251. "minLength" : 1,
  5252. "enum" : [ "TextEnds" ]
  5253. },
  5254. "textis" : {
  5255. "type" : "string",
  5256. "minLength" : 1,
  5257. "enum" : [ "TextIs" ]
  5258. },
  5259. "textisempty" : {
  5260. "type" : "string",
  5261. "minLength" : 1,
  5262. "enum" : [ "TextIsEmpty" ]
  5263. },
  5264. "textisnot" : {
  5265. "type" : "string",
  5266. "minLength" : 1,
  5267. "enum" : [ "TextIsNot" ]
  5268. },
  5269. "textisnotempty" : {
  5270. "type" : "string",
  5271. "minLength" : 1,
  5272. "enum" : [ "TextIsNotEmpty" ]
  5273. },
  5274. "textnotcontains" : {
  5275. "type" : "string",
  5276. "minLength" : 1,
  5277. "enum" : [ "TextNotContains" ]
  5278. },
  5279. "textnotends" : {
  5280. "type" : "string",
  5281. "minLength" : 1,
  5282. "enum" : [ "TextNotEnds" ]
  5283. },
  5284. "textnotstarts" : {
  5285. "type" : "string",
  5286. "minLength" : 1,
  5287. "enum" : [ "TextNotStarts" ]
  5288. },
  5289. "textstarts" : {
  5290. "type" : "string",
  5291. "minLength" : 1,
  5292. "enum" : [ "TextStarts" ]
  5293. }
  5294. }
  5295. },
  5296. "jsonExample" : "not implemented yet"
  5297. },
  5298. "deprecatedRequests" : [ ]
  5299. }, {
  5300. "description" : "Add a new column with values from expression evaluation",
  5301. "name" : "NewCustomColumn",
  5302. "deprecatedNames" : [ ],
  5303. "request" : {
  5304. "jsonSchema" : {
  5305. "type" : "object",
  5306. "properties" : {
  5307. "action" : {
  5308. "type" : "string",
  5309. "minLength" : 1
  5310. },
  5311. "table" : {
  5312. "type" : "string",
  5313. "minLength" : 1
  5314. },
  5315. "expression" : {
  5316. "type" : "string",
  5317. "minLength" : 1
  5318. },
  5319. "newcolumn" : {
  5320. "type" : "string",
  5321. "minLength" : 1
  5322. }
  5323. },
  5324. "id" : "#newcustomcolumnaction",
  5325. "additionalProperties" : false,
  5326. "title" : "New custom column action",
  5327. "required" : [ "action", "table", "expression" ]
  5328. },
  5329. "jsonExample" : "not implemented yet"
  5330. },
  5331. "deprecatedRequests" : [ ]
  5332. }, {
  5333. "description" : "Extract an Nth word from a string. E.g. 'mi ke er da' => 'er' for 3rd word and empty delimiter",
  5334. "name" : "NthWordInString",
  5335. "deprecatedNames" : [ ],
  5336. "request" : {
  5337. "jsonSchema" : {
  5338. "type" : "object",
  5339. "properties" : {
  5340. "action" : {
  5341. "type" : "string",
  5342. "minLength" : 1
  5343. },
  5344. "table" : {
  5345. "type" : "string",
  5346. "minLength" : 1
  5347. },
  5348. "col" : {
  5349. "type" : "string",
  5350. "minLength" : 1
  5351. },
  5352. "position" : {
  5353. "type" : "number"
  5354. },
  5355. "placement" : {
  5356. "$ref" : "#/definitions/columnside"
  5357. },
  5358. "delimeter" : {
  5359. "type" : "string",
  5360. "minLength" : 1
  5361. },
  5362. "newcolumn" : {
  5363. "type" : "string",
  5364. "minLength" : 1
  5365. }
  5366. },
  5367. "id" : "#nthwordinstringaction",
  5368. "additionalProperties" : false,
  5369. "title" : "Nth word in string action",
  5370. "required" : [ "action", "table", "col", "position", "placement" ],
  5371. "definitions" : {
  5372. "columnside" : {
  5373. "anyOf" : [ {
  5374. "$ref" : "#/definitions/endside"
  5375. }, {
  5376. "$ref" : "#/definitions/leftside"
  5377. }, {
  5378. "$ref" : "#/definitions/rightside"
  5379. }, {
  5380. "$ref" : "#/definitions/startside"
  5381. } ]
  5382. },
  5383. "endside" : {
  5384. "type" : "string",
  5385. "minLength" : 1,
  5386. "enum" : [ "end" ]
  5387. },
  5388. "leftside" : {
  5389. "type" : "string",
  5390. "minLength" : 1,
  5391. "enum" : [ "left" ]
  5392. },
  5393. "rightside" : {
  5394. "type" : "string",
  5395. "minLength" : 1,
  5396. "enum" : [ "right" ]
  5397. },
  5398. "startside" : {
  5399. "type" : "string",
  5400. "minLength" : 1,
  5401. "enum" : [ "start" ]
  5402. }
  5403. }
  5404. },
  5405. "jsonExample" : "not implemented yet"
  5406. },
  5407. "deprecatedRequests" : [ ]
  5408. }, {
  5409. "description" : "Override values from several table into one according to their priorities",
  5410. "name" : "OverrideWithPriority",
  5411. "deprecatedNames" : [ ],
  5412. "request" : {
  5413. "jsonSchema" : {
  5414. "type" : "object",
  5415. "properties" : {
  5416. "action" : {
  5417. "type" : "string",
  5418. "minLength" : 1
  5419. },
  5420. "tables" : {
  5421. "type" : "array",
  5422. "items" : {
  5423. "type" : "string",
  5424. "minLength" : 1
  5425. }
  5426. },
  5427. "primaryKeys" : {
  5428. "type" : "array",
  5429. "items" : {
  5430. "type" : "string",
  5431. "minLength" : 1
  5432. }
  5433. }
  5434. },
  5435. "id" : "#overridewithpriorityaction",
  5436. "additionalProperties" : false,
  5437. "title" : "Override with priority action",
  5438. "required" : [ "action", "tables", "primaryKeys" ]
  5439. },
  5440. "jsonExample" : "not implemented yet"
  5441. },
  5442. "deprecatedRequests" : [ ]
  5443. }, {
  5444. "description" : "Divide values in a column on the value from request in order to get percents",
  5445. "name" : "PercentOf",
  5446. "deprecatedNames" : [ ],
  5447. "request" : {
  5448. "jsonSchema" : {
  5449. "type" : "object",
  5450. "properties" : {
  5451. "action" : {
  5452. "type" : "string",
  5453. "minLength" : 1
  5454. },
  5455. "table" : {
  5456. "type" : "string",
  5457. "minLength" : 1
  5458. },
  5459. "col" : {
  5460. "type" : "string",
  5461. "minLength" : 1
  5462. },
  5463. "value" : {
  5464. "type" : "number"
  5465. },
  5466. "precision" : {
  5467. "type" : "number"
  5468. },
  5469. "newcolumn" : {
  5470. "type" : "string",
  5471. "minLength" : 1
  5472. }
  5473. },
  5474. "id" : "#percentofaction",
  5475. "additionalProperties" : false,
  5476. "title" : "Percent of action",
  5477. "required" : [ "action", "table", "col", "value" ]
  5478. },
  5479. "jsonExample" : "not implemented yet"
  5480. },
  5481. "deprecatedRequests" : [ ]
  5482. }, {
  5483. "description" : "Multiply values in a column on the percent from request in order to get new values",
  5484. "name" : "Percentage",
  5485. "deprecatedNames" : [ ],
  5486. "request" : {
  5487. "jsonSchema" : {
  5488. "type" : "object",
  5489. "properties" : {
  5490. "action" : {
  5491. "type" : "string",
  5492. "minLength" : 1
  5493. },
  5494. "table" : {
  5495. "type" : "string",
  5496. "minLength" : 1
  5497. },
  5498. "col" : {
  5499. "type" : "string",
  5500. "minLength" : 1
  5501. },
  5502. "percentage" : {
  5503. "type" : "number"
  5504. },
  5505. "precision" : {
  5506. "type" : "number"
  5507. },
  5508. "newcolumn" : {
  5509. "type" : "string",
  5510. "minLength" : 1
  5511. }
  5512. },
  5513. "id" : "#percentageaction",
  5514. "additionalProperties" : false,
  5515. "title" : "Percentage action",
  5516. "required" : [ "action", "table", "col", "percentage" ]
  5517. },
  5518. "jsonExample" : "not implemented yet"
  5519. },
  5520. "deprecatedRequests" : [ ]
  5521. }, {
  5522. "description" : "Return count of positive values",
  5523. "name" : "PositiveCount",
  5524. "deprecatedNames" : [ ],
  5525. "request" : {
  5526. "jsonSchema" : {
  5527. "type" : "object",
  5528. "properties" : {
  5529. "action" : {
  5530. "type" : "string",
  5531. "minLength" : 1
  5532. },
  5533. "table" : {
  5534. "type" : "string",
  5535. "minLength" : 1
  5536. },
  5537. "col" : {
  5538. "type" : "string",
  5539. "minLength" : 1
  5540. }
  5541. },
  5542. "id" : "#positivecountaction",
  5543. "additionalProperties" : false,
  5544. "title" : "Positive count action",
  5545. "required" : [ "action", "table", "col" ]
  5546. },
  5547. "jsonExample" : "not implemented yet"
  5548. },
  5549. "deprecatedRequests" : [ ]
  5550. }, {
  5551. "description" : "Register custom UDF which later can be used via EvalUDF",
  5552. "name" : "RegisterUDF",
  5553. "deprecatedNames" : [ ],
  5554. "request" : {
  5555. "jsonSchema" : {
  5556. "type" : "object",
  5557. "properties" : {
  5558. "action" : {
  5559. "type" : "string",
  5560. "minLength" : 1
  5561. },
  5562. "functions" : {
  5563. "type" : "array",
  5564. "items" : {
  5565. "$ref" : "#/definitions/userdefinedfunction"
  5566. }
  5567. }
  5568. },
  5569. "id" : "#registerudfaction",
  5570. "additionalProperties" : false,
  5571. "title" : "Register u d f action",
  5572. "required" : [ "action", "functions" ],
  5573. "definitions" : {
  5574. "userdefinedfunction" : {
  5575. "type" : "object",
  5576. "properties" : {
  5577. "id" : {
  5578. "type" : "string",
  5579. "minLength" : 1
  5580. },
  5581. "body" : {
  5582. "type" : "string",
  5583. "minLength" : 1
  5584. }
  5585. },
  5586. "id" : "#userdefinedfunction",
  5587. "additionalProperties" : false,
  5588. "title" : "User defined function",
  5589. "required" : [ "id", "body" ]
  5590. }
  5591. }
  5592. },
  5593. "jsonExample" : "not implemented yet"
  5594. },
  5595. "deprecatedRequests" : [ ]
  5596. }, {
  5597. "description" : "Remove nulls and empty strings",
  5598. "name" : "RemoveBlankRows",
  5599. "deprecatedNames" : [ ],
  5600. "request" : {
  5601. "jsonSchema" : {
  5602. "type" : "object",
  5603. "properties" : {
  5604. "action" : {
  5605. "type" : "string",
  5606. "minLength" : 1
  5607. },
  5608. "table" : {
  5609. "type" : "string",
  5610. "minLength" : 1
  5611. }
  5612. },
  5613. "id" : "#removeblankrowsaction",
  5614. "additionalProperties" : false,
  5615. "title" : "Remove blank rows action",
  5616. "required" : [ "action", "table" ]
  5617. },
  5618. "jsonExample" : "not implemented yet"
  5619. },
  5620. "deprecatedRequests" : [ ]
  5621. }, {
  5622. "description" : "Removes columns from a table",
  5623. "name" : "RemoveColumn",
  5624. "deprecatedNames" : [ ],
  5625. "request" : {
  5626. "jsonSchema" : {
  5627. "type" : "object",
  5628. "properties" : {
  5629. "action" : {
  5630. "type" : "string",
  5631. "minLength" : 1
  5632. },
  5633. "table" : {
  5634. "type" : "string",
  5635. "minLength" : 1
  5636. },
  5637. "cols" : {
  5638. "type" : "array",
  5639. "items" : {
  5640. "type" : "string",
  5641. "minLength" : 1
  5642. }
  5643. }
  5644. },
  5645. "id" : "#removecolumnaction",
  5646. "additionalProperties" : false,
  5647. "title" : "Remove column action",
  5648. "required" : [ "action", "table", "cols" ]
  5649. },
  5650. "jsonExample" : "not implemented yet"
  5651. },
  5652. "deprecatedRequests" : [ ]
  5653. }, {
  5654. "description" : "Remove duplicated rows",
  5655. "name" : "RemoveDuplicates",
  5656. "deprecatedNames" : [ ],
  5657. "request" : {
  5658. "jsonSchema" : {
  5659. "type" : "object",
  5660. "properties" : {
  5661. "action" : {
  5662. "type" : "string",
  5663. "minLength" : 1
  5664. },
  5665. "table" : {
  5666. "type" : "string",
  5667. "minLength" : 1
  5668. },
  5669. "cols" : {
  5670. "type" : "array",
  5671. "items" : {
  5672. "type" : "string",
  5673. "minLength" : 1
  5674. }
  5675. }
  5676. },
  5677. "id" : "#removeduplicatesaction",
  5678. "additionalProperties" : false,
  5679. "title" : "Remove duplicates action",
  5680. "required" : [ "action", "table", "cols" ]
  5681. },
  5682. "jsonExample" : "not implemented yet"
  5683. },
  5684. "deprecatedRequests" : [ ]
  5685. }, {
  5686. "description" : "Remove rows according to the expression from request",
  5687. "name" : "RemoveErrors",
  5688. "deprecatedNames" : [ ],
  5689. "request" : {
  5690. "jsonSchema" : {
  5691. "type" : "object",
  5692. "properties" : {
  5693. "action" : {
  5694. "type" : "string",
  5695. "minLength" : 1
  5696. },
  5697. "table" : {
  5698. "type" : "string",
  5699. "minLength" : 1
  5700. },
  5701. "expression" : {
  5702. "type" : "string",
  5703. "minLength" : 1
  5704. }
  5705. },
  5706. "id" : "#removeerrorsaction",
  5707. "additionalProperties" : false,
  5708. "title" : "Remove errors action",
  5709. "required" : [ "action", "table", "expression" ]
  5710. },
  5711. "jsonExample" : "not implemented yet"
  5712. },
  5713. "deprecatedRequests" : [ ]
  5714. }, {
  5715. "description" : "Rename column names in a table",
  5716. "name" : "RenameColumns",
  5717. "deprecatedNames" : [ ],
  5718. "request" : {
  5719. "jsonSchema" : {
  5720. "type" : "object",
  5721. "properties" : {
  5722. "action" : {
  5723. "type" : "string",
  5724. "minLength" : 1
  5725. },
  5726. "table" : {
  5727. "type" : "string",
  5728. "minLength" : 1
  5729. },
  5730. "changes" : {
  5731. "type" : "array",
  5732. "items" : {
  5733. "$ref" : "#/definitions/col"
  5734. }
  5735. }
  5736. },
  5737. "id" : "#renamecolumnsaction",
  5738. "additionalProperties" : false,
  5739. "title" : "Rename columns action",
  5740. "required" : [ "action", "table", "changes" ],
  5741. "definitions" : {
  5742. "col" : {
  5743. "type" : "object",
  5744. "properties" : {
  5745. "col" : {
  5746. "type" : "string",
  5747. "minLength" : 1
  5748. },
  5749. "newcolumn" : {
  5750. "type" : "string",
  5751. "minLength" : 1
  5752. }
  5753. },
  5754. "id" : "#col",
  5755. "additionalProperties" : false,
  5756. "title" : "Col",
  5757. "required" : [ "col", "newcolumn" ]
  5758. }
  5759. }
  5760. },
  5761. "jsonExample" : "not implemented yet"
  5762. },
  5763. "deprecatedRequests" : [ ]
  5764. }, {
  5765. "description" : "Replace values in a column if `expression` is true",
  5766. "name" : "ReplaceErrors",
  5767. "deprecatedNames" : [ ],
  5768. "request" : {
  5769. "jsonSchema" : {
  5770. "type" : "object",
  5771. "properties" : {
  5772. "action" : {
  5773. "type" : "string",
  5774. "minLength" : 1
  5775. },
  5776. "table" : {
  5777. "type" : "string",
  5778. "minLength" : 1
  5779. },
  5780. "expression" : {
  5781. "type" : "string",
  5782. "minLength" : 1
  5783. },
  5784. "newValue" : {
  5785. "type" : "string",
  5786. "minLength" : 1
  5787. },
  5788. "col" : {
  5789. "type" : "string",
  5790. "minLength" : 1
  5791. },
  5792. "newcolumn" : {
  5793. "type" : "string",
  5794. "minLength" : 1
  5795. }
  5796. },
  5797. "id" : "#replaceerrorsaction",
  5798. "additionalProperties" : false,
  5799. "title" : "Replace errors action",
  5800. "required" : [ "action", "table", "expression", "newValue", "col" ]
  5801. },
  5802. "jsonExample" : "not implemented yet"
  5803. },
  5804. "deprecatedRequests" : [ ]
  5805. }, {
  5806. "description" : "Replace nulls with a specific literal from the request",
  5807. "name" : "ReplaceNull",
  5808. "deprecatedNames" : [ ],
  5809. "request" : {
  5810. "jsonSchema" : {
  5811. "type" : "object",
  5812. "properties" : {
  5813. "action" : {
  5814. "type" : "string",
  5815. "minLength" : 1
  5816. },
  5817. "table" : {
  5818. "type" : "string",
  5819. "minLength" : 1
  5820. },
  5821. "col" : {
  5822. "type" : "string",
  5823. "minLength" : 1
  5824. },
  5825. "newValue" : {
  5826. "type" : "string",
  5827. "minLength" : 1
  5828. },
  5829. "newcolumn" : {
  5830. "type" : "string",
  5831. "minLength" : 1
  5832. }
  5833. },
  5834. "id" : "#replacenullaction",
  5835. "additionalProperties" : false,
  5836. "title" : "Replace null action",
  5837. "required" : [ "action", "table", "col", "newValue" ]
  5838. },
  5839. "jsonExample" : "not implemented yet"
  5840. },
  5841. "deprecatedRequests" : [ ]
  5842. }, {
  5843. "description" : "Replace a substring",
  5844. "name" : "ReplaceSubstring",
  5845. "deprecatedNames" : [ ],
  5846. "request" : {
  5847. "jsonSchema" : {
  5848. "type" : "object",
  5849. "properties" : {
  5850. "action" : {
  5851. "type" : "string",
  5852. "minLength" : 1
  5853. },
  5854. "table" : {
  5855. "type" : "string",
  5856. "minLength" : 1
  5857. },
  5858. "replace_type" : {
  5859. "$ref" : "#/definitions/replacesubstringtype"
  5860. },
  5861. "col" : {
  5862. "type" : "string",
  5863. "minLength" : 1
  5864. },
  5865. "oldValue" : {
  5866. "type" : "string",
  5867. "minLength" : 1
  5868. },
  5869. "newValue" : {
  5870. "type" : "string",
  5871. "minLength" : 1
  5872. },
  5873. "newcolumn" : {
  5874. "type" : "string",
  5875. "minLength" : 1
  5876. }
  5877. },
  5878. "id" : "#replacesubstringaction",
  5879. "additionalProperties" : false,
  5880. "title" : "Replace substring action",
  5881. "required" : [ "action", "table", "replace_type", "col", "oldValue", "newValue" ],
  5882. "definitions" : {
  5883. "anywhereonstring" : {
  5884. "type" : "string",
  5885. "minLength" : 1,
  5886. "enum" : [ "AnywhereOnString" ]
  5887. },
  5888. "endofstring" : {
  5889. "type" : "string",
  5890. "minLength" : 1,
  5891. "enum" : [ "EndOfString" ]
  5892. },
  5893. "exactmatch" : {
  5894. "type" : "string",
  5895. "minLength" : 1,
  5896. "enum" : [ "ExactMatch" ]
  5897. },
  5898. "replacesubstringtype" : {
  5899. "anyOf" : [ {
  5900. "$ref" : "#/definitions/anywhereonstring"
  5901. }, {
  5902. "$ref" : "#/definitions/endofstring"
  5903. }, {
  5904. "$ref" : "#/definitions/exactmatch"
  5905. }, {
  5906. "$ref" : "#/definitions/startofstring"
  5907. } ]
  5908. },
  5909. "startofstring" : {
  5910. "type" : "string",
  5911. "minLength" : 1,
  5912. "enum" : [ "StartOfString" ]
  5913. }
  5914. }
  5915. },
  5916. "jsonExample" : "not implemented yet"
  5917. },
  5918. "deprecatedRequests" : [ ]
  5919. }, {
  5920. "description" : "Replace values in a column to the new specific value",
  5921. "name" : "ReplaceValues",
  5922. "deprecatedNames" : [ ],
  5923. "request" : {
  5924. "jsonSchema" : {
  5925. "type" : "object",
  5926. "properties" : {
  5927. "action" : {
  5928. "type" : "string",
  5929. "minLength" : 1
  5930. },
  5931. "table" : {
  5932. "type" : "string",
  5933. "minLength" : 1
  5934. },
  5935. "col" : {
  5936. "type" : "string",
  5937. "minLength" : 1
  5938. },
  5939. "oldValues" : {
  5940. "type" : "array",
  5941. "items" : {
  5942. "type" : "string",
  5943. "minLength" : 1
  5944. }
  5945. },
  5946. "newValue" : {
  5947. "type" : "string",
  5948. "minLength" : 1
  5949. },
  5950. "newcolumn" : {
  5951. "type" : "string",
  5952. "minLength" : 1
  5953. }
  5954. },
  5955. "id" : "#replacevaluesaction",
  5956. "additionalProperties" : false,
  5957. "title" : "Replace values action",
  5958. "required" : [ "action", "table", "col", "oldValues", "newValue" ]
  5959. },
  5960. "jsonExample" : "not implemented yet"
  5961. },
  5962. "deprecatedRequests" : [ ]
  5963. }, {
  5964. "description" : "Round value with specified precision",
  5965. "name" : "RoundDecimal",
  5966. "deprecatedNames" : [ ],
  5967. "request" : {
  5968. "jsonSchema" : {
  5969. "type" : "object",
  5970. "properties" : {
  5971. "action" : {
  5972. "type" : "string",
  5973. "minLength" : 1
  5974. },
  5975. "table" : {
  5976. "type" : "string",
  5977. "minLength" : 1
  5978. },
  5979. "col" : {
  5980. "type" : "string",
  5981. "minLength" : 1
  5982. },
  5983. "precision" : {
  5984. "type" : "number"
  5985. },
  5986. "newcolumn" : {
  5987. "type" : "string",
  5988. "minLength" : 1
  5989. }
  5990. },
  5991. "id" : "#rounddecimalaction",
  5992. "additionalProperties" : false,
  5993. "title" : "Round decimal action",
  5994. "required" : [ "action", "table", "col", "precision" ]
  5995. },
  5996. "jsonExample" : "not implemented yet"
  5997. },
  5998. "deprecatedRequests" : [ ]
  5999. }, {
  6000. "description" : "Round fractional numbers down",
  6001. "name" : "RoundDown",
  6002. "deprecatedNames" : [ ],
  6003. "request" : {
  6004. "jsonSchema" : {
  6005. "type" : "object",
  6006. "properties" : {
  6007. "action" : {
  6008. "type" : "string",
  6009. "minLength" : 1
  6010. },
  6011. "table" : {
  6012. "type" : "string",
  6013. "minLength" : 1
  6014. },
  6015. "col" : {
  6016. "type" : "string",
  6017. "minLength" : 1
  6018. },
  6019. "newcolumn" : {
  6020. "type" : "string",
  6021. "minLength" : 1
  6022. }
  6023. },
  6024. "id" : "#rounddownaction",
  6025. "additionalProperties" : false,
  6026. "title" : "Round down action",
  6027. "required" : [ "action", "table", "col" ]
  6028. },
  6029. "jsonExample" : "not implemented yet"
  6030. },
  6031. "deprecatedRequests" : [ ]
  6032. }, {
  6033. "description" : "Round fractional numbers up",
  6034. "name" : "RoundUp",
  6035. "deprecatedNames" : [ ],
  6036. "request" : {
  6037. "jsonSchema" : {
  6038. "type" : "object",
  6039. "properties" : {
  6040. "action" : {
  6041. "type" : "string",
  6042. "minLength" : 1
  6043. },
  6044. "table" : {
  6045. "type" : "string",
  6046. "minLength" : 1
  6047. },
  6048. "col" : {
  6049. "type" : "string",
  6050. "minLength" : 1
  6051. },
  6052. "newcolumn" : {
  6053. "type" : "string",
  6054. "minLength" : 1
  6055. }
  6056. },
  6057. "id" : "#roundupaction",
  6058. "additionalProperties" : false,
  6059. "title" : "Round up action",
  6060. "required" : [ "action", "table", "col" ]
  6061. },
  6062. "jsonExample" : "not implemented yet"
  6063. },
  6064. "deprecatedRequests" : [ ]
  6065. }, {
  6066. "description" : "Filter values with an ability to inverse the filter",
  6067. "name" : "Rule",
  6068. "deprecatedNames" : [ ],
  6069. "request" : {
  6070. "jsonSchema" : {
  6071. "type" : "object",
  6072. "properties" : {
  6073. "action" : {
  6074. "type" : "string",
  6075. "minLength" : 1
  6076. },
  6077. "table" : {
  6078. "type" : "string",
  6079. "minLength" : 1
  6080. },
  6081. "filterGroup" : {
  6082. "$ref" : "#/definitions/filtergroup"
  6083. },
  6084. "output_condition_true_data" : {
  6085. "type" : "boolean"
  6086. }
  6087. },
  6088. "id" : "#ruleaction",
  6089. "additionalProperties" : false,
  6090. "title" : "Rule action",
  6091. "required" : [ "action", "table", "filterGroup" ],
  6092. "definitions" : {
  6093. "dateafter" : {
  6094. "type" : "string",
  6095. "minLength" : 1,
  6096. "enum" : [ "DateAfter" ]
  6097. },
  6098. "datebefore" : {
  6099. "type" : "string",
  6100. "minLength" : 1,
  6101. "enum" : [ "DateBefore" ]
  6102. },
  6103. "dateis" : {
  6104. "type" : "string",
  6105. "minLength" : 1,
  6106. "enum" : [ "DateIs" ]
  6107. },
  6108. "filter" : {
  6109. "type" : "object",
  6110. "properties" : {
  6111. "name" : {
  6112. "$ref" : "#/definitions/filtertype"
  6113. },
  6114. "value" : {
  6115. "type" : "string",
  6116. "minLength" : 1
  6117. },
  6118. "col" : {
  6119. "type" : "string",
  6120. "minLength" : 1
  6121. },
  6122. "isValueAColumn" : {
  6123. "type" : "boolean"
  6124. }
  6125. },
  6126. "id" : "#filter",
  6127. "additionalProperties" : false,
  6128. "title" : "Filter",
  6129. "required" : [ "name", "col" ]
  6130. },
  6131. "filtergroup" : {
  6132. "type" : "object",
  6133. "properties" : {
  6134. "filters" : {
  6135. "type" : "array",
  6136. "items" : {
  6137. "$ref" : "#/definitions/filter"
  6138. }
  6139. },
  6140. "grouping" : {
  6141. "type" : "string",
  6142. "minLength" : 1
  6143. },
  6144. "children" : {
  6145. "type" : "array",
  6146. "items" : {
  6147. "$ref" : "#/definitions/filtergroup"
  6148. }
  6149. }
  6150. },
  6151. "id" : "#filtergroup",
  6152. "additionalProperties" : false,
  6153. "title" : "Filter group",
  6154. "required" : [ "filters", "grouping", "children" ]
  6155. },
  6156. "filtertype" : {
  6157. "anyOf" : [ {
  6158. "$ref" : "#/definitions/dateafter"
  6159. }, {
  6160. "$ref" : "#/definitions/datebefore"
  6161. }, {
  6162. "$ref" : "#/definitions/dateis"
  6163. }, {
  6164. "$ref" : "#/definitions/greaterthen"
  6165. }, {
  6166. "$ref" : "#/definitions/greaterthenoreq"
  6167. }, {
  6168. "$ref" : "#/definitions/isbetween"
  6169. }, {
  6170. "$ref" : "#/definitions/iseq"
  6171. }, {
  6172. "$ref" : "#/definitions/isnotbetween"
  6173. }, {
  6174. "$ref" : "#/definitions/isnoteq"
  6175. }, {
  6176. "$ref" : "#/definitions/isnotnull"
  6177. }, {
  6178. "$ref" : "#/definitions/isnotunique"
  6179. }, {
  6180. "$ref" : "#/definitions/isnull"
  6181. }, {
  6182. "$ref" : "#/definitions/isunique"
  6183. }, {
  6184. "$ref" : "#/definitions/lessthen"
  6185. }, {
  6186. "$ref" : "#/definitions/lessthenoreq"
  6187. }, {
  6188. "$ref" : "#/definitions/textcontains"
  6189. }, {
  6190. "$ref" : "#/definitions/textends"
  6191. }, {
  6192. "$ref" : "#/definitions/textis"
  6193. }, {
  6194. "$ref" : "#/definitions/textisempty"
  6195. }, {
  6196. "$ref" : "#/definitions/textisnot"
  6197. }, {
  6198. "$ref" : "#/definitions/textisnotempty"
  6199. }, {
  6200. "$ref" : "#/definitions/textnotcontains"
  6201. }, {
  6202. "$ref" : "#/definitions/textnotends"
  6203. }, {
  6204. "$ref" : "#/definitions/textnotstarts"
  6205. }, {
  6206. "$ref" : "#/definitions/textstarts"
  6207. } ]
  6208. },
  6209. "greaterthen" : {
  6210. "type" : "string",
  6211. "minLength" : 1,
  6212. "enum" : [ "GreaterThen" ]
  6213. },
  6214. "greaterthenoreq" : {
  6215. "type" : "string",
  6216. "minLength" : 1,
  6217. "enum" : [ "GreaterThenOrEq" ]
  6218. },
  6219. "isbetween" : {
  6220. "type" : "string",
  6221. "minLength" : 1,
  6222. "enum" : [ "IsBetween" ]
  6223. },
  6224. "iseq" : {
  6225. "type" : "string",
  6226. "minLength" : 1,
  6227. "enum" : [ "IsEq" ]
  6228. },
  6229. "isnotbetween" : {
  6230. "type" : "string",
  6231. "minLength" : 1,
  6232. "enum" : [ "IsNotBetween" ]
  6233. },
  6234. "isnoteq" : {
  6235. "type" : "string",
  6236. "minLength" : 1,
  6237. "enum" : [ "IsNotEq" ]
  6238. },
  6239. "isnotnull" : {
  6240. "type" : "string",
  6241. "minLength" : 1,
  6242. "enum" : [ "IsNotNull" ]
  6243. },
  6244. "isnotunique" : {
  6245. "type" : "string",
  6246. "minLength" : 1,
  6247. "enum" : [ "IsNotUnique" ]
  6248. },
  6249. "isnull" : {
  6250. "type" : "string",
  6251. "minLength" : 1,
  6252. "enum" : [ "IsNull" ]
  6253. },
  6254. "isunique" : {
  6255. "type" : "string",
  6256. "minLength" : 1,
  6257. "enum" : [ "IsUnique" ]
  6258. },
  6259. "lessthen" : {
  6260. "type" : "string",
  6261. "minLength" : 1,
  6262. "enum" : [ "LessThen" ]
  6263. },
  6264. "lessthenoreq" : {
  6265. "type" : "string",
  6266. "minLength" : 1,
  6267. "enum" : [ "LessThenOrEq" ]
  6268. },
  6269. "textcontains" : {
  6270. "type" : "string",
  6271. "minLength" : 1,
  6272. "enum" : [ "TextContains" ]
  6273. },
  6274. "textends" : {
  6275. "type" : "string",
  6276. "minLength" : 1,
  6277. "enum" : [ "TextEnds" ]
  6278. },
  6279. "textis" : {
  6280. "type" : "string",
  6281. "minLength" : 1,
  6282. "enum" : [ "TextIs" ]
  6283. },
  6284. "textisempty" : {
  6285. "type" : "string",
  6286. "minLength" : 1,
  6287. "enum" : [ "TextIsEmpty" ]
  6288. },
  6289. "textisnot" : {
  6290. "type" : "string",
  6291. "minLength" : 1,
  6292. "enum" : [ "TextIsNot" ]
  6293. },
  6294. "textisnotempty" : {
  6295. "type" : "string",
  6296. "minLength" : 1,
  6297. "enum" : [ "TextIsNotEmpty" ]
  6298. },
  6299. "textnotcontains" : {
  6300. "type" : "string",
  6301. "minLength" : 1,
  6302. "enum" : [ "TextNotContains" ]
  6303. },
  6304. "textnotends" : {
  6305. "type" : "string",
  6306. "minLength" : 1,
  6307. "enum" : [ "TextNotEnds" ]
  6308. },
  6309. "textnotstarts" : {
  6310. "type" : "string",
  6311. "minLength" : 1,
  6312. "enum" : [ "TextNotStarts" ]
  6313. },
  6314. "textstarts" : {
  6315. "type" : "string",
  6316. "minLength" : 1,
  6317. "enum" : [ "TextStarts" ]
  6318. }
  6319. }
  6320. },
  6321. "jsonExample" : "not implemented yet"
  6322. },
  6323. "deprecatedRequests" : [ ]
  6324. }, {
  6325. "description" : "Save table from spark into relational db",
  6326. "name" : "SaveFileToSqlServer",
  6327. "deprecatedNames" : [ ],
  6328. "request" : {
  6329. "jsonSchema" : {
  6330. "type" : "object",
  6331. "properties" : {
  6332. "action" : {
  6333. "type" : "string",
  6334. "minLength" : 1
  6335. },
  6336. "table" : {
  6337. "type" : "string",
  6338. "minLength" : 1
  6339. },
  6340. "sqlServerUrl" : {
  6341. "$ref" : "#/definitions/jdbcconnectioninfo"
  6342. },
  6343. "database" : {
  6344. "type" : "string",
  6345. "minLength" : 1
  6346. },
  6347. "dbUser" : {
  6348. "type" : "string",
  6349. "minLength" : 1
  6350. },
  6351. "dbPasswordEncrypted" : {
  6352. "$ref" : "#/definitions/encryptedvalue"
  6353. },
  6354. "dbTable" : {
  6355. "type" : "string",
  6356. "minLength" : 1
  6357. },
  6358. "fields" : {
  6359. "type" : "array",
  6360. "items" : {
  6361. "$ref" : "#/definitions/fieldssql"
  6362. }
  6363. },
  6364. "mode" : {
  6365. "type" : "string",
  6366. "minLength" : 1
  6367. },
  6368. "batchSize" : {
  6369. "type" : "number"
  6370. }
  6371. },
  6372. "id" : "#savefiletosqlserverrequest",
  6373. "additionalProperties" : false,
  6374. "title" : "Save file to sql server request",
  6375. "required" : [ "action", "table", "sqlServerUrl", "database", "dbUser", "dbPasswordEncrypted", "dbTable" ],
  6376. "definitions" : {
  6377. "encryptedvalue" : {
  6378. "type" : "object",
  6379. "properties" : {
  6380. "value" : {
  6381. "type" : "string",
  6382. "minLength" : 1
  6383. },
  6384. "iv" : {
  6385. "type" : "string",
  6386. "minLength" : 1
  6387. }
  6388. },
  6389. "id" : "#encryptedvalue",
  6390. "additionalProperties" : false,
  6391. "title" : "Encrypted value",
  6392. "required" : [ "value", "iv" ]
  6393. },
  6394. "fieldssql" : {
  6395. "type" : "object",
  6396. "properties" : {
  6397. "oldFieldName" : {
  6398. "type" : "string",
  6399. "minLength" : 1
  6400. },
  6401. "newFieldName" : {
  6402. "type" : "string",
  6403. "minLength" : 1
  6404. }
  6405. },
  6406. "id" : "#fieldssql",
  6407. "additionalProperties" : false,
  6408. "title" : "Fields s q l",
  6409. "required" : [ "oldFieldName", "newFieldName" ]
  6410. },
  6411. "h2connectioninfo" : {
  6412. "type" : "object",
  6413. "properties" : {
  6414. "fullUrl" : {
  6415. "type" : "string",
  6416. "minLength" : 1
  6417. }
  6418. },
  6419. "id" : "#h2connectioninfo",
  6420. "additionalProperties" : false,
  6421. "title" : "H2 connection info",
  6422. "required" : [ "fullUrl" ]
  6423. },
  6424. "jdbcconnectioninfo" : {
  6425. "anyOf" : [ {
  6426. "$ref" : "#/definitions/h2connectioninfo"
  6427. }, {
  6428. "$ref" : "#/definitions/sqlserverconnectioninfo"
  6429. } ]
  6430. },
  6431. "sqlserverconnectioninfo" : {
  6432. "type" : "object",
  6433. "properties" : {
  6434. "url" : {
  6435. "type" : "string",
  6436. "minLength" : 1
  6437. }
  6438. },
  6439. "id" : "#sqlserverconnectioninfo",
  6440. "additionalProperties" : false,
  6441. "title" : "Sql server connection info",
  6442. "required" : [ "url" ]
  6443. }
  6444. }
  6445. },
  6446. "jsonExample" : "not implemented yet"
  6447. },
  6448. "deprecatedRequests" : [ ]
  6449. }, {
  6450. "description" : "Save tables to files",
  6451. "name" : "SaveTablesToStorage",
  6452. "deprecatedNames" : [ ],
  6453. "request" : {
  6454. "jsonSchema" : {
  6455. "type" : "object",
  6456. "properties" : {
  6457. "action" : {
  6458. "type" : "string",
  6459. "minLength" : 1
  6460. },
  6461. "tablesToSave" : {
  6462. "type" : "array",
  6463. "items" : {
  6464. "$ref" : "#/definitions/savetablerequest"
  6465. }
  6466. }
  6467. },
  6468. "id" : "#savetablestostoragerequest",
  6469. "additionalProperties" : false,
  6470. "title" : "Save tables to storage request",
  6471. "required" : [ "action", "tablesToSave" ],
  6472. "definitions" : {
  6473. "append" : {
  6474. "type" : "object",
  6475. "properties" : { },
  6476. "id" : "#append",
  6477. "additionalProperties" : false,
  6478. "title" : "Append"
  6479. },
  6480. "errorifexists" : {
  6481. "type" : "object",
  6482. "properties" : { },
  6483. "id" : "#errorifexists",
  6484. "additionalProperties" : false,
  6485. "title" : "Error if exists"
  6486. },
  6487. "filerequest" : {
  6488. "type" : "object",
  6489. "properties" : {
  6490. "file" : {
  6491. "type" : "string",
  6492. "minLength" : 1
  6493. },
  6494. "storage" : {
  6495. "type" : "string",
  6496. "minLength" : 1
  6497. }
  6498. },
  6499. "id" : "#filerequest",
  6500. "additionalProperties" : false,
  6501. "title" : "File request",
  6502. "required" : [ "file", "storage" ]
  6503. },
  6504. "ignore" : {
  6505. "type" : "object",
  6506. "properties" : { },
  6507. "id" : "#ignore",
  6508. "additionalProperties" : false,
  6509. "title" : "Ignore"
  6510. },
  6511. "overwrite" : {
  6512. "type" : "object",
  6513. "properties" : { },
  6514. "id" : "#overwrite",
  6515. "additionalProperties" : false,
  6516. "title" : "Overwrite"
  6517. },
  6518. "savemoderequest" : {
  6519. "anyOf" : [ {
  6520. "$ref" : "#/definitions/append"
  6521. }, {
  6522. "$ref" : "#/definitions/errorifexists"
  6523. }, {
  6524. "$ref" : "#/definitions/ignore"
  6525. }, {
  6526. "$ref" : "#/definitions/overwrite"
  6527. } ]
  6528. },
  6529. "savetablerequest" : {
  6530. "type" : "object",
  6531. "properties" : {
  6532. "tableId" : {
  6533. "type" : "string",
  6534. "minLength" : 1
  6535. },
  6536. "outputFile" : {
  6537. "$ref" : "#/definitions/filerequest"
  6538. },
  6539. "saveMode" : {
  6540. "$ref" : "#/definitions/savemoderequest"
  6541. }
  6542. },
  6543. "id" : "#savetablerequest",
  6544. "additionalProperties" : false,
  6545. "title" : "Save table request",
  6546. "required" : [ "tableId", "outputFile" ]
  6547. }
  6548. }
  6549. },
  6550. "jsonExample" : "not implemented yet"
  6551. },
  6552. "deprecatedRequests" : [ ]
  6553. }, {
  6554. "description" : "Save table into a file",
  6555. "name" : "SaveToStorage",
  6556. "deprecatedNames" : [ "SaveToDLStore" ],
  6557. "request" : {
  6558. "jsonSchema" : {
  6559. "type" : "object",
  6560. "properties" : {
  6561. "action" : {
  6562. "type" : "string",
  6563. "minLength" : 1
  6564. },
  6565. "table" : {
  6566. "type" : "string",
  6567. "minLength" : 1
  6568. },
  6569. "file" : {
  6570. "$ref" : "#/definitions/filerequest"
  6571. },
  6572. "saveMode" : {
  6573. "$ref" : "#/definitions/savemoderequest"
  6574. },
  6575. "orderingColumn" : {
  6576. "type" : "boolean"
  6577. }
  6578. },
  6579. "id" : "#savetostoragerequest",
  6580. "additionalProperties" : false,
  6581. "title" : "Save to storage request",
  6582. "required" : [ "action", "table", "file" ],
  6583. "definitions" : {
  6584. "append" : {
  6585. "type" : "object",
  6586. "properties" : { },
  6587. "id" : "#append",
  6588. "additionalProperties" : false,
  6589. "title" : "Append"
  6590. },
  6591. "errorifexists" : {
  6592. "type" : "object",
  6593. "properties" : { },
  6594. "id" : "#errorifexists",
  6595. "additionalProperties" : false,
  6596. "title" : "Error if exists"
  6597. },
  6598. "filerequest" : {
  6599. "type" : "object",
  6600. "properties" : {
  6601. "file" : {
  6602. "type" : "string",
  6603. "minLength" : 1
  6604. },
  6605. "storage" : {
  6606. "type" : "string",
  6607. "minLength" : 1
  6608. }
  6609. },
  6610. "id" : "#filerequest",
  6611. "additionalProperties" : false,
  6612. "title" : "File request",
  6613. "required" : [ "file", "storage" ]
  6614. },
  6615. "ignore" : {
  6616. "type" : "object",
  6617. "properties" : { },
  6618. "id" : "#ignore",
  6619. "additionalProperties" : false,
  6620. "title" : "Ignore"
  6621. },
  6622. "overwrite" : {
  6623. "type" : "object",
  6624. "properties" : { },
  6625. "id" : "#overwrite",
  6626. "additionalProperties" : false,
  6627. "title" : "Overwrite"
  6628. },
  6629. "savemoderequest" : {
  6630. "anyOf" : [ {
  6631. "$ref" : "#/definitions/append"
  6632. }, {
  6633. "$ref" : "#/definitions/errorifexists"
  6634. }, {
  6635. "$ref" : "#/definitions/ignore"
  6636. }, {
  6637. "$ref" : "#/definitions/overwrite"
  6638. } ]
  6639. }
  6640. }
  6641. },
  6642. "jsonExample" : "not implemented yet"
  6643. },
  6644. "deprecatedRequests" : [ {
  6645. "jsonSchema" : {
  6646. "type" : "object",
  6647. "properties" : {
  6648. "action" : {
  6649. "type" : "string",
  6650. "minLength" : 1
  6651. },
  6652. "store" : {
  6653. "type" : "string",
  6654. "minLength" : 1
  6655. },
  6656. "table" : {
  6657. "type" : "string",
  6658. "minLength" : 1
  6659. },
  6660. "output_path" : {
  6661. "type" : "string",
  6662. "minLength" : 1
  6663. },
  6664. "file_name" : {
  6665. "type" : "string",
  6666. "minLength" : 1
  6667. },
  6668. "ordering_column" : {
  6669. "type" : "boolean"
  6670. }
  6671. },
  6672. "id" : "#savetostoragerequestold",
  6673. "additionalProperties" : false,
  6674. "title" : "Save to storage request old",
  6675. "required" : [ "action", "store", "table", "output_path", "file_name" ]
  6676. },
  6677. "jsonExample" : "not implemented yet"
  6678. } ]
  6679. }, {
  6680. "description" : "Set config for prep.spark",
  6681. "name" : "SetSessionParams",
  6682. "deprecatedNames" : [ ],
  6683. "request" : {
  6684. "jsonSchema" : {
  6685. "type" : "object",
  6686. "properties" : {
  6687. "action" : {
  6688. "type" : "string",
  6689. "minLength" : 1
  6690. },
  6691. "checkPointPath" : {
  6692. "type" : "string",
  6693. "minLength" : 1
  6694. },
  6695. "blockSize" : {
  6696. "type" : "number"
  6697. },
  6698. "storages" : {
  6699. "type" : "array",
  6700. "items" : {
  6701. "$ref" : "#/definitions/storage"
  6702. }
  6703. },
  6704. "pathAliases" : {
  6705. "type" : "array",
  6706. "items" : {
  6707. "$ref" : "#/definitions/pathalias"
  6708. }
  6709. },
  6710. "translationUrl" : {
  6711. "type" : "string",
  6712. "minLength" : 1
  6713. },
  6714. "smallFileSettings" : {
  6715. "type" : "boolean"
  6716. }
  6717. },
  6718. "id" : "#setsessionparamsaction",
  6719. "additionalProperties" : false,
  6720. "title" : "Set session params action",
  6721. "required" : [ "action", "checkPointPath" ],
  6722. "definitions" : {
  6723. "dlstorage" : {
  6724. "type" : "object",
  6725. "properties" : {
  6726. "name" : {
  6727. "type" : "string",
  6728. "minLength" : 1
  6729. },
  6730. "store" : {
  6731. "type" : "string",
  6732. "minLength" : 1
  6733. }
  6734. },
  6735. "id" : "#dlstorage",
  6736. "additionalProperties" : false,
  6737. "title" : "D l storage",
  6738. "required" : [ "name", "store" ]
  6739. },
  6740. "pathalias" : {
  6741. "type" : "object",
  6742. "properties" : {
  6743. "alias" : {
  6744. "type" : "string",
  6745. "minLength" : 1
  6746. },
  6747. "path" : {
  6748. "type" : "string",
  6749. "minLength" : 1
  6750. }
  6751. },
  6752. "id" : "#pathalias",
  6753. "additionalProperties" : false,
  6754. "title" : "Path alias",
  6755. "required" : [ "alias", "path" ]
  6756. },
  6757. "s3storage" : {
  6758. "type" : "object",
  6759. "properties" : {
  6760. "name" : {
  6761. "type" : "string",
  6762. "minLength" : 1
  6763. },
  6764. "awsKey" : {
  6765. "type" : "string",
  6766. "minLength" : 1
  6767. },
  6768. "awsSecret" : {
  6769. "type" : "string",
  6770. "minLength" : 1
  6771. },
  6772. "bucket" : {
  6773. "type" : "string",
  6774. "minLength" : 1
  6775. }
  6776. },
  6777. "id" : "#s3storage",
  6778. "additionalProperties" : false,
  6779. "title" : "S3 storage",
  6780. "required" : [ "name", "awsKey", "awsSecret", "bucket" ]
  6781. },
  6782. "storage" : {
  6783. "anyOf" : [ {
  6784. "$ref" : "#/definitions/dlstorage"
  6785. }, {
  6786. "$ref" : "#/definitions/s3storage"
  6787. } ]
  6788. }
  6789. }
  6790. },
  6791. "jsonExample" : "not implemented yet"
  6792. },
  6793. "deprecatedRequests" : [ ]
  6794. }, {
  6795. "description" : "No-op job for testing purposes, hangs execution for specified time",
  6796. "name" : "Sleep",
  6797. "deprecatedNames" : [ ],
  6798. "request" : {
  6799. "jsonSchema" : {
  6800. "type" : "object",
  6801. "properties" : {
  6802. "action" : {
  6803. "type" : "string",
  6804. "minLength" : 1
  6805. },
  6806. "seconds" : {
  6807. "type" : "number"
  6808. }
  6809. },
  6810. "id" : "#sleepaction",
  6811. "additionalProperties" : false,
  6812. "title" : "Sleep action",
  6813. "required" : [ "action", "seconds" ]
  6814. },
  6815. "jsonExample" : "not implemented yet"
  6816. },
  6817. "deprecatedRequests" : [ ]
  6818. }, {
  6819. "description" : "Sort values",
  6820. "name" : "Sort",
  6821. "deprecatedNames" : [ ],
  6822. "request" : {
  6823. "jsonSchema" : {
  6824. "type" : "object",
  6825. "properties" : {
  6826. "action" : {
  6827. "type" : "string",
  6828. "minLength" : 1
  6829. },
  6830. "table" : {
  6831. "type" : "string",
  6832. "minLength" : 1
  6833. },
  6834. "cols" : {
  6835. "type" : "array",
  6836. "items" : {
  6837. "$ref" : "#/definitions/sortelement"
  6838. }
  6839. }
  6840. },
  6841. "id" : "#sortaction",
  6842. "additionalProperties" : false,
  6843. "title" : "Sort action",
  6844. "required" : [ "action", "table", "cols" ],
  6845. "definitions" : {
  6846. "asc" : {
  6847. "type" : "string",
  6848. "minLength" : 1,
  6849. "enum" : [ "asc" ]
  6850. },
  6851. "desc" : {
  6852. "type" : "string",
  6853. "minLength" : 1,
  6854. "enum" : [ "desc" ]
  6855. },
  6856. "sortelement" : {
  6857. "type" : "object",
  6858. "properties" : {
  6859. "col" : {
  6860. "type" : "string",
  6861. "minLength" : 1
  6862. },
  6863. "sort_order" : {
  6864. "$ref" : "#/definitions/sortordering"
  6865. }
  6866. },
  6867. "id" : "#sortelement",
  6868. "additionalProperties" : false,
  6869. "title" : "Sort element",
  6870. "required" : [ "col", "sort_order" ]
  6871. },
  6872. "sortordering" : {
  6873. "anyOf" : [ {
  6874. "$ref" : "#/definitions/asc"
  6875. }, {
  6876. "$ref" : "#/definitions/desc"
  6877. } ]
  6878. }
  6879. }
  6880. },
  6881. "jsonExample" : "not implemented yet"
  6882. },
  6883. "deprecatedRequests" : [ ]
  6884. }, {
  6885. "description" : "Split values using the delimiter into new columns. E.g. 'jo|hn|pas' => 'jo', 'hn', 'pas'",
  6886. "name" : "SplitByDelimeter",
  6887. "deprecatedNames" : [ ],
  6888. "request" : {
  6889. "jsonSchema" : {
  6890. "type" : "object",
  6891. "properties" : {
  6892. "action" : {
  6893. "type" : "string",
  6894. "minLength" : 1
  6895. },
  6896. "table" : {
  6897. "type" : "string",
  6898. "minLength" : 1
  6899. },
  6900. "col" : {
  6901. "type" : "string",
  6902. "minLength" : 1
  6903. },
  6904. "outCols" : {
  6905. "type" : "array",
  6906. "items" : {
  6907. "type" : "string",
  6908. "minLength" : 1
  6909. }
  6910. },
  6911. "delimeter" : {
  6912. "type" : "string",
  6913. "minLength" : 1
  6914. },
  6915. "noOfEntries" : {
  6916. "type" : "number"
  6917. }
  6918. },
  6919. "id" : "#splitbydelimiteraction",
  6920. "additionalProperties" : false,
  6921. "title" : "Split by delimiter action",
  6922. "required" : [ "action", "table", "col", "outCols", "delimeter", "noOfEntries" ]
  6923. },
  6924. "jsonExample" : "not implemented yet"
  6925. },
  6926. "deprecatedRequests" : [ ]
  6927. }, {
  6928. "description" : "Return substrings with respect to specified length starting from the most left symbol",
  6929. "name" : "SplitByLength",
  6930. "deprecatedNames" : [ ],
  6931. "request" : {
  6932. "jsonSchema" : {
  6933. "type" : "object",
  6934. "properties" : {
  6935. "action" : {
  6936. "type" : "string",
  6937. "minLength" : 1
  6938. },
  6939. "table" : {
  6940. "type" : "string",
  6941. "minLength" : 1
  6942. },
  6943. "col" : {
  6944. "type" : "string",
  6945. "minLength" : 1
  6946. },
  6947. "length" : {
  6948. "type" : "array",
  6949. "items" : {
  6950. "$ref" : "#/definitions/coloffset"
  6951. }
  6952. },
  6953. "placement" : {
  6954. "$ref" : "#/definitions/columnside"
  6955. }
  6956. },
  6957. "id" : "#splitbylengthaction",
  6958. "additionalProperties" : false,
  6959. "title" : "Split by length action",
  6960. "required" : [ "action", "table", "col", "length", "placement" ],
  6961. "definitions" : {
  6962. "coloffset" : {
  6963. "type" : "object",
  6964. "properties" : {
  6965. "colName" : {
  6966. "type" : "string",
  6967. "minLength" : 1
  6968. },
  6969. "offset" : {
  6970. "type" : "number"
  6971. }
  6972. },
  6973. "id" : "#coloffset",
  6974. "additionalProperties" : false,
  6975. "title" : "Col offset",
  6976. "required" : [ "colName", "offset" ]
  6977. },
  6978. "columnside" : {
  6979. "anyOf" : [ {
  6980. "$ref" : "#/definitions/endside"
  6981. }, {
  6982. "$ref" : "#/definitions/leftside"
  6983. }, {
  6984. "$ref" : "#/definitions/rightside"
  6985. }, {
  6986. "$ref" : "#/definitions/startside"
  6987. } ]
  6988. },
  6989. "endside" : {
  6990. "type" : "string",
  6991. "minLength" : 1,
  6992. "enum" : [ "end" ]
  6993. },
  6994. "leftside" : {
  6995. "type" : "string",
  6996. "minLength" : 1,
  6997. "enum" : [ "left" ]
  6998. },
  6999. "rightside" : {
  7000. "type" : "string",
  7001. "minLength" : 1,
  7002. "enum" : [ "right" ]
  7003. },
  7004. "startside" : {
  7005. "type" : "string",
  7006. "minLength" : 1,
  7007. "enum" : [ "start" ]
  7008. }
  7009. }
  7010. },
  7011. "jsonExample" : "not implemented yet"
  7012. },
  7013. "deprecatedRequests" : [ ]
  7014. }, {
  7015. "description" : "Return standard deviation",
  7016. "name" : "StandardDeviation",
  7017. "deprecatedNames" : [ ],
  7018. "request" : {
  7019. "jsonSchema" : {
  7020. "type" : "object",
  7021. "properties" : {
  7022. "action" : {
  7023. "type" : "string",
  7024. "minLength" : 1
  7025. },
  7026. "table" : {
  7027. "type" : "string",
  7028. "minLength" : 1
  7029. },
  7030. "col" : {
  7031. "type" : "string",
  7032. "minLength" : 1
  7033. }
  7034. },
  7035. "id" : "#standarddeviationaction",
  7036. "additionalProperties" : false,
  7037. "title" : "Standard deviation action",
  7038. "required" : [ "action", "table", "col" ]
  7039. },
  7040. "jsonExample" : "not implemented yet"
  7041. },
  7042. "deprecatedRequests" : [ ]
  7043. }, {
  7044. "description" : "Return name of the first day in a month",
  7045. "name" : "StartOfMonth",
  7046. "deprecatedNames" : [ ],
  7047. "request" : {
  7048. "jsonSchema" : {
  7049. "type" : "object",
  7050. "properties" : {
  7051. "action" : {
  7052. "type" : "string",
  7053. "minLength" : 1
  7054. },
  7055. "table" : {
  7056. "type" : "string",
  7057. "minLength" : 1
  7058. },
  7059. "col" : {
  7060. "type" : "string",
  7061. "minLength" : 1
  7062. },
  7063. "newcolumn" : {
  7064. "type" : "string",
  7065. "minLength" : 1
  7066. }
  7067. },
  7068. "id" : "#startofmonthaction",
  7069. "additionalProperties" : false,
  7070. "title" : "Start of month action",
  7071. "required" : [ "action", "table", "col" ]
  7072. },
  7073. "jsonExample" : "not implemented yet"
  7074. },
  7075. "deprecatedRequests" : [ ]
  7076. }, {
  7077. "description" : "Return date of start of the week",
  7078. "name" : "StartOfWeek",
  7079. "deprecatedNames" : [ ],
  7080. "request" : {
  7081. "jsonSchema" : {
  7082. "type" : "object",
  7083. "properties" : {
  7084. "action" : {
  7085. "type" : "string",
  7086. "minLength" : 1
  7087. },
  7088. "table" : {
  7089. "type" : "string",
  7090. "minLength" : 1
  7091. },
  7092. "col" : {
  7093. "type" : "string",
  7094. "minLength" : 1
  7095. },
  7096. "newcolumn" : {
  7097. "type" : "string",
  7098. "minLength" : 1
  7099. }
  7100. },
  7101. "id" : "#startofweekaction",
  7102. "additionalProperties" : false,
  7103. "title" : "Start of week action",
  7104. "required" : [ "action", "table", "col" ]
  7105. },
  7106. "jsonExample" : "not implemented yet"
  7107. },
  7108. "deprecatedRequests" : [ ]
  7109. }, {
  7110. "description" : "Subtract from values in a column",
  7111. "name" : "Subtract",
  7112. "deprecatedNames" : [ ],
  7113. "request" : {
  7114. "jsonSchema" : {
  7115. "type" : "object",
  7116. "properties" : {
  7117. "action" : {
  7118. "type" : "string",
  7119. "minLength" : 1
  7120. },
  7121. "table" : {
  7122. "type" : "string",
  7123. "minLength" : 1
  7124. },
  7125. "col" : {
  7126. "type" : "string",
  7127. "minLength" : 1
  7128. },
  7129. "number" : {
  7130. "type" : "number"
  7131. },
  7132. "precision" : {
  7133. "type" : "number"
  7134. },
  7135. "newcolumn" : {
  7136. "type" : "string",
  7137. "minLength" : 1
  7138. }
  7139. },
  7140. "id" : "#subtractaction",
  7141. "additionalProperties" : false,
  7142. "title" : "Subtract action",
  7143. "required" : [ "action", "table", "col", "number" ]
  7144. },
  7145. "jsonExample" : "not implemented yet"
  7146. },
  7147. "deprecatedRequests" : [ ]
  7148. }, {
  7149. "description" : "Return the sum of all values in the given column",
  7150. "name" : "Sum",
  7151. "deprecatedNames" : [ ],
  7152. "request" : {
  7153. "jsonSchema" : {
  7154. "type" : "object",
  7155. "properties" : {
  7156. "action" : {
  7157. "type" : "string",
  7158. "minLength" : 1
  7159. },
  7160. "table" : {
  7161. "type" : "string",
  7162. "minLength" : 1
  7163. },
  7164. "col" : {
  7165. "type" : "string",
  7166. "minLength" : 1
  7167. }
  7168. },
  7169. "id" : "#sumaction",
  7170. "additionalProperties" : false,
  7171. "title" : "Sum action",
  7172. "required" : [ "action", "table", "col" ]
  7173. },
  7174. "jsonExample" : "not implemented yet"
  7175. },
  7176. "deprecatedRequests" : [ ]
  7177. }, {
  7178. "description" : "Square values in a column and sum them",
  7179. "name" : "SumOfSquare",
  7180. "deprecatedNames" : [ ],
  7181. "request" : {
  7182. "jsonSchema" : {
  7183. "type" : "object",
  7184. "properties" : {
  7185. "action" : {
  7186. "type" : "string",
  7187. "minLength" : 1
  7188. },
  7189. "table" : {
  7190. "type" : "string",
  7191. "minLength" : 1
  7192. },
  7193. "col" : {
  7194. "type" : "string",
  7195. "minLength" : 1
  7196. }
  7197. },
  7198. "id" : "#sumofsquareaction",
  7199. "additionalProperties" : false,
  7200. "title" : "Sum of square action",
  7201. "required" : [ "action", "table", "col" ]
  7202. },
  7203. "jsonExample" : "not implemented yet"
  7204. },
  7205. "deprecatedRequests" : [ ]
  7206. }, {
  7207. "description" : "Check whether the table exists or not",
  7208. "name" : "TableExists",
  7209. "deprecatedNames" : [ ],
  7210. "request" : {
  7211. "jsonSchema" : {
  7212. "type" : "object",
  7213. "properties" : {
  7214. "action" : {
  7215. "type" : "string",
  7216. "minLength" : 1
  7217. },
  7218. "table" : {
  7219. "type" : "string",
  7220. "minLength" : 1
  7221. }
  7222. },
  7223. "id" : "#tableexistaction",
  7224. "additionalProperties" : false,
  7225. "title" : "Table exist action",
  7226. "required" : [ "action", "table" ]
  7227. },
  7228. "jsonExample" : "not implemented yet"
  7229. },
  7230. "deprecatedRequests" : [ ]
  7231. }, {
  7232. "description" : "Set that the column represent currency",
  7233. "name" : "ToggleNumericColumnToCurrency",
  7234. "deprecatedNames" : [ ],
  7235. "request" : {
  7236. "jsonSchema" : {
  7237. "type" : "object",
  7238. "properties" : {
  7239. "action" : {
  7240. "type" : "string",
  7241. "minLength" : 1
  7242. },
  7243. "table" : {
  7244. "type" : "string",
  7245. "minLength" : 1
  7246. },
  7247. "col" : {
  7248. "type" : "string",
  7249. "minLength" : 1
  7250. },
  7251. "convertToCurrency" : {
  7252. "type" : "boolean"
  7253. }
  7254. },
  7255. "id" : "#togglenumericcolumntocurrencyaction",
  7256. "additionalProperties" : false,
  7257. "title" : "Toggle numeric column to currency action",
  7258. "required" : [ "action", "table", "col", "convertToCurrency" ]
  7259. },
  7260. "jsonExample" : "not implemented yet"
  7261. },
  7262. "deprecatedRequests" : [ ]
  7263. }, {
  7264. "description" : "Translate values in a string column from one language to another",
  7265. "name" : "Translate",
  7266. "deprecatedNames" : [ ],
  7267. "request" : {
  7268. "jsonSchema" : {
  7269. "type" : "object",
  7270. "properties" : {
  7271. "action" : {
  7272. "type" : "string",
  7273. "minLength" : 1
  7274. },
  7275. "table" : {
  7276. "type" : "string",
  7277. "minLength" : 1
  7278. },
  7279. "cols" : {
  7280. "type" : "array",
  7281. "items" : {
  7282. "type" : "string",
  7283. "minLength" : 1
  7284. }
  7285. },
  7286. "srcLang" : {
  7287. "type" : "string",
  7288. "minLength" : 1
  7289. },
  7290. "trgLang" : {
  7291. "type" : "string",
  7292. "minLength" : 1
  7293. }
  7294. },
  7295. "id" : "#translateaction",
  7296. "additionalProperties" : false,
  7297. "title" : "Translate action",
  7298. "required" : [ "action", "table", "cols", "srcLang" ]
  7299. },
  7300. "jsonExample" : "not implemented yet"
  7301. },
  7302. "deprecatedRequests" : [ ]
  7303. }, {
  7304. "description" : "Trim strings in a column",
  7305. "name" : "Trim",
  7306. "deprecatedNames" : [ ],
  7307. "request" : {
  7308. "jsonSchema" : {
  7309. "type" : "object",
  7310. "properties" : {
  7311. "action" : {
  7312. "type" : "string",
  7313. "minLength" : 1
  7314. },
  7315. "table" : {
  7316. "type" : "string",
  7317. "minLength" : 1
  7318. },
  7319. "col" : {
  7320. "type" : "string",
  7321. "minLength" : 1
  7322. }
  7323. },
  7324. "id" : "#trimaction",
  7325. "additionalProperties" : false,
  7326. "title" : "Trim action",
  7327. "required" : [ "action", "table", "col" ]
  7328. },
  7329. "jsonExample" : "not implemented yet"
  7330. },
  7331. "deprecatedRequests" : [ ]
  7332. }, {
  7333. "description" : "Unpivot using unpivot columns",
  7334. "name" : "UnPivot",
  7335. "deprecatedNames" : [ ],
  7336. "request" : {
  7337. "jsonSchema" : {
  7338. "type" : "object",
  7339. "properties" : {
  7340. "action" : {
  7341. "type" : "string",
  7342. "minLength" : 1
  7343. },
  7344. "table" : {
  7345. "type" : "string",
  7346. "minLength" : 1
  7347. },
  7348. "unpivot_cols" : {
  7349. "type" : "array",
  7350. "items" : {
  7351. "type" : "string",
  7352. "minLength" : 1
  7353. }
  7354. },
  7355. "header_col_name" : {
  7356. "type" : "string",
  7357. "minLength" : 1
  7358. },
  7359. "value_col_name" : {
  7360. "type" : "string",
  7361. "minLength" : 1
  7362. }
  7363. },
  7364. "id" : "#unpivotaction",
  7365. "additionalProperties" : false,
  7366. "title" : "Un pivot action",
  7367. "required" : [ "action", "table", "unpivot_cols", "header_col_name", "value_col_name" ]
  7368. },
  7369. "jsonExample" : "not implemented yet"
  7370. },
  7371. "deprecatedRequests" : [ ]
  7372. }, {
  7373. "description" : "Unpivot by all columns except the specified",
  7374. "name" : "UnPivotOthers",
  7375. "deprecatedNames" : [ ],
  7376. "request" : {
  7377. "jsonSchema" : {
  7378. "type" : "object",
  7379. "properties" : {
  7380. "action" : {
  7381. "type" : "string",
  7382. "minLength" : 1
  7383. },
  7384. "table" : {
  7385. "type" : "string",
  7386. "minLength" : 1
  7387. },
  7388. "unpivot_cols" : {
  7389. "type" : "array",
  7390. "items" : {
  7391. "type" : "string",
  7392. "minLength" : 1
  7393. }
  7394. },
  7395. "header_col_name" : {
  7396. "type" : "string",
  7397. "minLength" : 1
  7398. },
  7399. "value_col_name" : {
  7400. "type" : "string",
  7401. "minLength" : 1
  7402. }
  7403. },
  7404. "id" : "#unpivotaction",
  7405. "additionalProperties" : false,
  7406. "title" : "Un pivot action",
  7407. "required" : [ "action", "table", "unpivot_cols", "header_col_name", "value_col_name" ]
  7408. },
  7409. "jsonExample" : "not implemented yet"
  7410. },
  7411. "deprecatedRequests" : [ ]
  7412. }, {
  7413. "description" : "Convert a column to upper case",
  7414. "name" : "UpperCase",
  7415. "deprecatedNames" : [ ],
  7416. "request" : {
  7417. "jsonSchema" : {
  7418. "type" : "object",
  7419. "properties" : {
  7420. "action" : {
  7421. "type" : "string",
  7422. "minLength" : 1
  7423. },
  7424. "table" : {
  7425. "type" : "string",
  7426. "minLength" : 1
  7427. },
  7428. "col" : {
  7429. "type" : "string",
  7430. "minLength" : 1
  7431. }
  7432. },
  7433. "id" : "#uppercaseaction",
  7434. "additionalProperties" : false,
  7435. "title" : "Upper case action",
  7436. "required" : [ "action", "table", "col" ]
  7437. },
  7438. "jsonExample" : "not implemented yet"
  7439. },
  7440. "deprecatedRequests" : [ ]
  7441. }, {
  7442. "description" : "Return the population variance of the values in a group",
  7443. "name" : "Variance",
  7444. "deprecatedNames" : [ ],
  7445. "request" : {
  7446. "jsonSchema" : {
  7447. "type" : "object",
  7448. "properties" : {
  7449. "action" : {
  7450. "type" : "string",
  7451. "minLength" : 1
  7452. },
  7453. "table" : {
  7454. "type" : "string",
  7455. "minLength" : 1
  7456. },
  7457. "col" : {
  7458. "type" : "string",
  7459. "minLength" : 1
  7460. }
  7461. },
  7462. "id" : "#varianceaction",
  7463. "additionalProperties" : false,
  7464. "title" : "Variance action",
  7465. "required" : [ "action", "table", "col" ]
  7466. },
  7467. "jsonExample" : "not implemented yet"
  7468. },
  7469. "deprecatedRequests" : [ ]
  7470. }, {
  7471. "description" : "Return week number of the month",
  7472. "name" : "WeekOfMonth",
  7473. "deprecatedNames" : [ ],
  7474. "request" : {
  7475. "jsonSchema" : {
  7476. "type" : "object",
  7477. "properties" : {
  7478. "action" : {
  7479. "type" : "string",
  7480. "minLength" : 1
  7481. },
  7482. "table" : {
  7483. "type" : "string",
  7484. "minLength" : 1
  7485. },
  7486. "col" : {
  7487. "type" : "string",
  7488. "minLength" : 1
  7489. },
  7490. "newcolumn" : {
  7491. "type" : "string",
  7492. "minLength" : 1
  7493. }
  7494. },
  7495. "id" : "#weekofmonthaction",
  7496. "additionalProperties" : false,
  7497. "title" : "Week of month action",
  7498. "required" : [ "action", "table", "col" ]
  7499. },
  7500. "jsonExample" : "not implemented yet"
  7501. },
  7502. "deprecatedRequests" : [ ]
  7503. }, {
  7504. "description" : "Return week number of the year",
  7505. "name" : "WeekOfYear",
  7506. "deprecatedNames" : [ ],
  7507. "request" : {
  7508. "jsonSchema" : {
  7509. "type" : "object",
  7510. "properties" : {
  7511. "action" : {
  7512. "type" : "string",
  7513. "minLength" : 1
  7514. },
  7515. "table" : {
  7516. "type" : "string",
  7517. "minLength" : 1
  7518. },
  7519. "col" : {
  7520. "type" : "string",
  7521. "minLength" : 1
  7522. },
  7523. "newcolumn" : {
  7524. "type" : "string",
  7525. "minLength" : 1
  7526. }
  7527. },
  7528. "id" : "#weekofyearaction",
  7529. "additionalProperties" : false,
  7530. "title" : "Week of year action",
  7531. "required" : [ "action", "table", "col" ]
  7532. },
  7533. "jsonExample" : "not implemented yet"
  7534. },
  7535. "deprecatedRequests" : [ ]
  7536. }, {
  7537. "description" : "Return number of a year",
  7538. "name" : "YearExtract",
  7539. "deprecatedNames" : [ ],
  7540. "request" : {
  7541. "jsonSchema" : {
  7542. "type" : "object",
  7543. "properties" : {
  7544. "action" : {
  7545. "type" : "string",
  7546. "minLength" : 1
  7547. },
  7548. "table" : {
  7549. "type" : "string",
  7550. "minLength" : 1
  7551. },
  7552. "col" : {
  7553. "type" : "string",
  7554. "minLength" : 1
  7555. },
  7556. "newcolumn" : {
  7557. "type" : "string",
  7558. "minLength" : 1
  7559. }
  7560. },
  7561. "id" : "#yearextractaction",
  7562. "additionalProperties" : false,
  7563. "title" : "Year extract action",
  7564. "required" : [ "action", "table", "col" ]
  7565. },
  7566. "jsonExample" : "not implemented yet"
  7567. },
  7568. "deprecatedRequests" : [ ]
  7569. }, {
  7570. "description" : "Return count of zero values ",
  7571. "name" : "ZeroCount",
  7572. "deprecatedNames" : [ ],
  7573. "request" : {
  7574. "jsonSchema" : {
  7575. "type" : "object",
  7576. "properties" : {
  7577. "action" : {
  7578. "type" : "string",
  7579. "minLength" : 1
  7580. },
  7581. "table" : {
  7582. "type" : "string",
  7583. "minLength" : 1
  7584. },
  7585. "col" : {
  7586. "type" : "string",
  7587. "minLength" : 1
  7588. }
  7589. },
  7590. "id" : "#zerocountaction",
  7591. "additionalProperties" : false,
  7592. "title" : "Zero count action",
  7593. "required" : [ "action", "table", "col" ]
  7594. },
  7595. "jsonExample" : "not implemented yet"
  7596. },
  7597. "deprecatedRequests" : [ ]
  7598. } ]
  7599. }
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!