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