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