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