{"objects":[{"metadata":{"identifier":{"packageName":"Matillion Exchange","name":"Show Schedules","revision":1,"type":"DYNAMIC"},"rootJobReference":{"name":"Show schedules","type":"ORCHESTRATION","parameterMetadata":[{"slot":2,"variableName":"jv_api_username","variableType":"SCALAR","displayName":"API Username","description":"A user that has permission to use the API","defaultValue":[{"values":{"1":""}}],"defaultValueType":"TEXT","required":true},{"slot":3,"variableName":"jv_api_password","variableType":"SCALAR","displayName":"API Password","description":"That user's password","defaultValue":[{"values":{"1":""}}],"defaultValueType":"TEXT","required":true},{"slot":4,"variableName":"jv_groupname","variableType":"SCALAR","displayName":"Group Name","description":"Name of the Group (optional)","defaultValue":[{"values":{"1":""}}],"defaultValueType":"TEXT","required":false},{"slot":5,"variableName":"jv_projectname","variableType":"SCALAR","displayName":"Project Name","description":"Name of the Project (optional)","defaultValue":[{"values":{"1":""}}],"defaultValueType":"TEXT","required":false},{"slot":6,"variableName":"g_schedules","variableType":"GRID","displayName":"g_schedules","description":"Output list of schedules","defaultValue":[],"defaultValueType":null,"required":true}]},"orchestrationJobs":["Show schedules"],"transformationJobs":[],"imageMetadata":{"componentIcon":"iVBORw0KGgoAAAANSUhEUgAAACAAAAAgCAYAAABzenr0AAACO0lEQVR42mP4P8CAYUg4YPee3f/3ADGxAKR2N5HqiXJAcGjQ/5DQYKId0NrWCtZDNQeYmBn/19DSINoBDY0NYD1UccDt27f/K6ko/pdTkP1/+fJlggZ++PDhv4eXO1gPSC/RDnj9+vX/+MR4sMuRMcggKRlJMFZUVsCQR8cgNTD1IL3o8iA7QHZhOMAvwBesycbO+n9IWAgcGxgZwA3U1ddFkcOGDY0N/0vLSoHVg/Qiy4HMBomD7MLpgDdv3qAE0cePH/9r62r91zPQ/f/27Rui4jUvP/e/jp42WC8y+PLlC9BR+vgd8PnLZwwD8wvz/5eWlxKdCBcvWfy/sakBq5ytnQ3pDqAmGPwO2LJ1CzD73KIJPnjwADhn4HUAPTBeBwQFB/5PSUuhCQ6PDCPsgA8f3tMs/n/+/AnOnkM7F4B8ASpQ0AFIDCSHDH7//v3/06dP1HVAbFwMMCUroVQ0kApLCSyHDIpLiv/Lysv837ptK/UcEBcfC65wHjx4ABcDsUFiIDlkUFJa/F9BSf7/rt27RktC8hzw/PnzgXPA0aNHwAmorr4OxYCi4qL/KmrK/1+8eAEXA7FBYiA5qjlg+YrlYH5OXg6KATFx0f9l5KQxcgFIDCRHNQf8+PHj/5KlS/6/fPkSxYDHjx//P33mNIbBIDGQ3PBKhNQG379//6+qroLfAZFREf8nTZ74f+rUKVTFIDNBZuOsDe/euwtuNtO6LQCyA2QX1o7Jo0eP/t+8eZOmGGTHoOodAwBDYFo0ZawulgAAAABJRU5ErkJggg==","smallIcon":"iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAABKElEQVR42qWQu04CURCGeRQhvoFK0ERBBNEnIDbEWtGoYIM9RtEaa3BFTCBxrbCFXpqt9wU2W+4le/llJoa4l5izcZI/+TOX75yZFP4ZqXBiOpuywjGff8XmI4CHxw7at+1I43g84los4Oy8jp3CNkr7e8isppHOrLD/LcqTyFMvzSwB69k1mKbJiV6/h2epH3lptvj+4HXA3nVdFEvFIMC27UTHK1fKQcDl1QVaNy0hNa8byOY2goDh2xCy/C6k0eKgm1u5v1dwHCfifd/n/WNXCAMKu3nous4iTzH5nOC0fiIGSHxEAsgfMlRV5YL0InGORF4I0H3qQlEULtx37mAYBou8EEA0PM9D/ucuDKgd13BwWEH1qCok6qWZJcCyLGialkg0Q/EN4xpWhpH/e3MAAAAASUVORK5CYII="},"description":"Show all the schedules on the server","helpHtml":"

Show Schedules

Show all the schedules on the server

Properties

PropertyTypeDescription
API UsernameVariableA user that has permission to use the API
API PasswordVariableThat user's password
Group NameVariableName of the Group (optional)
Project NameVariableName of the Project (optional)
g_schedulesGridOutput list of schedules
","created":1699896133090},"orchestrationJobs":{"Show schedules":{"id":-2,"revision":62,"created":1699895968969,"timestamp":1699895968969,"components":{"8268":{"id":8268,"inputCardinality":"ZERO","outputCardinality":"MANY","connectorHint":"UNCONDITIONAL","executionHint":"FLOW","implementationID":444132438,"x":-32,"y":-208,"width":32,"height":32,"inputConnectorIDs":[],"outputSuccessConnectorIDs":[],"outputFailureConnectorIDs":[],"outputUnconditionalConnectorIDs":[8279],"outputTrueConnectorIDs":[],"outputFalseConnectorIDs":[],"exportMappings":{},"parameters":{"1":{"slot":1,"name":"Start","elements":{"1":{"slot":1,"values":{"1":{"slot":1,"type":"STRING","value":"Start 0"}}}},"visible":true,"status":{},"columnNames":[]}},"validationStatus":{},"status":{},"expectedFailure":null,"activationStatus":"ENABLED","outputIterationConnectorIDs":[],"inputIterationConnectorIDs":[]},"8269":{"id":8269,"inputCardinality":"ONE","outputCardinality":"MANY","connectorHint":"SUCCESS_FAIL","executionHint":"EXECUTE","implementationID":-1773186829,"x":96,"y":-208,"width":32,"height":32,"inputConnectorIDs":[8279],"outputSuccessConnectorIDs":[8278],"outputFailureConnectorIDs":[],"outputUnconditionalConnectorIDs":[],"outputTrueConnectorIDs":[],"outputFalseConnectorIDs":[],"exportMappings":{},"parameters":{"1":{"slot":1,"name":"Name","elements":{"1":{"slot":1,"values":{"1":{"slot":1,"type":"STRING","value":"Generate the import statement"}}}},"visible":true,"status":{},"columnNames":[]},"2":{"slot":2,"name":"Script","elements":{"1":{"slot":1,"values":{"1":{"slot":1,"type":"STRING","value":"import pathlib\nfrom os import path\n\nmypath = pathlib.Path(path.expanduser(\"~\") + \"/\" + prvt_module_path).absolute()\ncontext.updateVariable('prvt_import_statement', 'import sys;sys.path.insert(0, \"{}\")'.format(mypath))\n"}}}},"visible":true,"status":{},"columnNames":[]},"3":{"slot":3,"name":"Interpreter","elements":{"1":{"slot":1,"values":{"1":{"slot":1,"type":"STRING","value":"Python 3"}}}},"visible":true,"status":{},"columnNames":[]},"4":{"slot":4,"name":"Timeout","elements":{"1":{"slot":1,"values":{"1":{"slot":1,"type":"INTEGER","value":"360"}}}},"visible":true,"status":{},"columnNames":[]},"5":{"slot":5,"name":"User","elements":{"1":{"slot":1,"values":{"1":{"slot":1,"type":"STRING","value":"Restricted"}}}},"visible":false,"status":{},"columnNames":[]}},"validationStatus":{},"status":{},"expectedFailure":null,"activationStatus":"ENABLED","outputIterationConnectorIDs":[],"inputIterationConnectorIDs":[]},"8270":{"id":8270,"inputCardinality":"ONE","outputCardinality":"MANY","connectorHint":"SUCCESS_FAIL","executionHint":"EXECUTE","implementationID":-30576485,"x":352,"y":-128,"width":32,"height":32,"inputConnectorIDs":[8281],"outputSuccessConnectorIDs":[8276],"outputFailureConnectorIDs":[],"outputUnconditionalConnectorIDs":[],"outputTrueConnectorIDs":[],"outputFalseConnectorIDs":[],"exportMappings":{},"parameters":{"1":{"slot":1,"name":"Name","elements":{"1":{"slot":1,"values":{"1":{"slot":1,"type":"STRING","value":"Ensure the Python libraries are available"}}}},"visible":true,"status":{},"columnNames":[]},"2":{"slot":2,"name":"Script","elements":{"1":{"slot":1,"values":{"1":{"slot":1,"type":"STRING","value":"# Ensure that requests is available\ncd\n\nmkdir -p \"$prvt_module_path\" || echo \"$prvt_module_path exists\"\n\n$prvt_python_bin -m pip install --target=\"$HOME/$prvt_module_path\" --ignore-installed requests\n\necho \"Installed prerequisites\"\n"}}}},"visible":true,"status":{},"columnNames":[]},"3":{"slot":3,"name":"Timeout","elements":{"1":{"slot":1,"values":{"1":{"slot":1,"type":"INTEGER","value":"360"}}}},"visible":true,"status":{},"columnNames":[]},"4":{"slot":4,"name":"User","elements":{"1":{"slot":1,"values":{"1":{"slot":1,"type":"STRING","value":"Restricted"}}}},"visible":false,"status":{},"columnNames":[]}},"validationStatus":{},"status":{},"expectedFailure":null,"activationStatus":"ENABLED","outputIterationConnectorIDs":[],"inputIterationConnectorIDs":[]},"8271":{"id":8271,"inputCardinality":"ONE","outputCardinality":"MANY","connectorHint":"SUCCESS_FAIL","executionHint":"EXECUTE","implementationID":-1773186829,"x":224,"y":-208,"width":32,"height":32,"inputConnectorIDs":[8278],"outputSuccessConnectorIDs":[8275],"outputFailureConnectorIDs":[8281],"outputUnconditionalConnectorIDs":[],"outputTrueConnectorIDs":[],"outputFalseConnectorIDs":[],"exportMappings":{},"parameters":{"1":{"slot":1,"name":"Name","elements":{"1":{"slot":1,"values":{"1":{"slot":1,"type":"STRING","value":"Verify libraries"}}}},"visible":true,"status":{},"columnNames":[]},"2":{"slot":2,"name":"Script","elements":{"1":{"slot":1,"values":{"1":{"slot":1,"type":"STRING","value":"${prvt_import_statement}\n\nimport requests \nimport time\nimport json\nimport math\n"}}}},"visible":true,"status":{},"columnNames":[]},"3":{"slot":3,"name":"Interpreter","elements":{"1":{"slot":1,"values":{"1":{"slot":1,"type":"STRING","value":"Python 3"}}}},"visible":true,"status":{},"columnNames":[]},"4":{"slot":4,"name":"Timeout","elements":{"1":{"slot":1,"values":{"1":{"slot":1,"type":"INTEGER","value":"360"}}}},"visible":true,"status":{},"columnNames":[]},"5":{"slot":5,"name":"User","elements":{"1":{"slot":1,"values":{"1":{"slot":1,"type":"STRING","value":"Restricted"}}}},"visible":false,"status":{},"columnNames":[]}},"validationStatus":{},"status":{},"expectedFailure":null,"activationStatus":"ENABLED","outputIterationConnectorIDs":[],"inputIterationConnectorIDs":[]},"8272":{"id":8272,"inputCardinality":"MANY","outputCardinality":"MANY","connectorHint":"UNCONDITIONAL","executionHint":"FLOW","implementationID":-1343684451,"x":464,"y":-208,"width":32,"height":32,"inputConnectorIDs":[8275,8276],"outputSuccessConnectorIDs":[],"outputFailureConnectorIDs":[],"outputUnconditionalConnectorIDs":[8280],"outputTrueConnectorIDs":[],"outputFalseConnectorIDs":[],"exportMappings":{},"parameters":{"1":{"slot":1,"name":"Name","elements":{"1":{"slot":1,"values":{"1":{"slot":1,"type":"STRING","value":"Or 0"}}}},"visible":true,"status":{},"columnNames":[]}},"validationStatus":{},"status":{},"expectedFailure":null,"activationStatus":"ENABLED","outputIterationConnectorIDs":[],"inputIterationConnectorIDs":[]},"8273":{"id":8273,"inputCardinality":"ONE","outputCardinality":"MANY","connectorHint":"SUCCESS_FAIL","executionHint":"EXECUTE","implementationID":-1773186829,"x":592,"y":-208,"width":32,"height":32,"inputConnectorIDs":[8280],"outputSuccessConnectorIDs":[8545],"outputFailureConnectorIDs":[],"outputUnconditionalConnectorIDs":[],"outputTrueConnectorIDs":[],"outputFalseConnectorIDs":[],"exportMappings":{},"parameters":{"1":{"slot":1,"name":"Name","elements":{"1":{"slot":1,"values":{"1":{"slot":1,"type":"STRING","value":"Reenerate the import statement"}}}},"visible":true,"status":{},"columnNames":[]},"2":{"slot":2,"name":"Script","elements":{"1":{"slot":1,"values":{"1":{"slot":1,"type":"STRING","value":"import pathlib\nfrom os import path\n\nmypath = pathlib.Path(path.expanduser(\"~\") + \"/\" + prvt_module_path).absolute()\ncontext.updateVariable('prvt_import_statement', 'import sys;sys.path.insert(0, \"{}\")'.format(mypath))\n"}}}},"visible":true,"status":{},"columnNames":[]},"3":{"slot":3,"name":"Interpreter","elements":{"1":{"slot":1,"values":{"1":{"slot":1,"type":"STRING","value":"Python 3"}}}},"visible":true,"status":{},"columnNames":[]},"4":{"slot":4,"name":"Timeout","elements":{"1":{"slot":1,"values":{"1":{"slot":1,"type":"INTEGER","value":"360"}}}},"visible":true,"status":{},"columnNames":[]},"5":{"slot":5,"name":"User","elements":{"1":{"slot":1,"values":{"1":{"slot":1,"type":"STRING","value":"Restricted"}}}},"visible":false,"status":{},"columnNames":[]}},"validationStatus":{},"status":{},"expectedFailure":null,"activationStatus":"ENABLED","outputIterationConnectorIDs":[],"inputIterationConnectorIDs":[]},"8306":{"id":8306,"inputCardinality":"ONE","outputCardinality":"MANY","connectorHint":"SUCCESS_FAIL","executionHint":"EXECUTE","implementationID":-1773186829,"x":736,"y":-208,"width":32,"height":32,"inputConnectorIDs":[8545],"outputSuccessConnectorIDs":[],"outputFailureConnectorIDs":[],"outputUnconditionalConnectorIDs":[],"outputTrueConnectorIDs":[],"outputFalseConnectorIDs":[],"exportMappings":{},"parameters":{"1":{"slot":1,"name":"Name","elements":{"1":{"slot":1,"values":{"1":{"slot":1,"type":"STRING","value":"Show schedules"}}}},"visible":true,"status":{},"columnNames":[]},"2":{"slot":2,"name":"Script","elements":{"1":{"slot":1,"values":{"1":{"slot":1,"type":"STRING","value":"${prvt_import_statement}\n\nimport requests\n\noutarr = []\n\n# Always call this, to verify the API credentials\ngjson = requests.get(prvt_endpoint + \"/rest/v1/group/\", auth=(jv_api_username, jv_api_password))\n\nif isinstance(gjson.json(), list):\n pass\nelse:\n raise Exception(\"API credentials are not valid\")\n\nif jv_groupname is None:\n gnames = gjson.json()\nelse:\n gnames = [ jv_groupname ]\n\nfor g in gnames:\n if jv_projectname is None:\n pjson = requests.get(prvt_endpoint + \"/rest/v1/group/name/\" + g + \"/projects/\", auth=(jv_api_username, jv_api_password))\n pnames = pjson.json()\n else:\n pnames = [ jv_projectname ]\n \n for p in pnames:\n sjson = requests.get(prvt_endpoint + \"/rest/v1/group/name/\" + g + \"/projects/name/\" + p + \"/schedule/export\", auth=(jv_api_username, jv_api_password))\n try:\n sobjarr = sjson.json()['objects']\n for sobj in sobjarr:\n print(g + \" / \" + p + \" / \" + sobj['name'])\n outarr.append([g, p, sobj['name']])\n except KeyError as ke:\n # This happens if the group / project name combination does not exist\n pass\n\ncontext.updateGridVariable('g_schedules', outarr)\n"}}}},"visible":true,"status":{},"columnNames":[]},"3":{"slot":3,"name":"Interpreter","elements":{"1":{"slot":1,"values":{"1":{"slot":1,"type":"STRING","value":"Python 3"}}}},"visible":true,"status":{},"columnNames":[]},"4":{"slot":4,"name":"Timeout","elements":{"1":{"slot":1,"values":{"1":{"slot":1,"type":"INTEGER","value":"360"}}}},"visible":true,"status":{},"columnNames":[]},"5":{"slot":5,"name":"User","elements":{"1":{"slot":1,"values":{"1":{"slot":1,"type":"STRING","value":"Restricted"}}}},"visible":false,"status":{},"columnNames":[]}},"validationStatus":{},"status":{},"expectedFailure":null,"activationStatus":"ENABLED","outputIterationConnectorIDs":[],"inputIterationConnectorIDs":[]}},"successConnectors":{"8275":{"id":8275,"sourceID":8271,"targetID":8272},"8276":{"id":8276,"sourceID":8270,"targetID":8272},"8278":{"id":8278,"sourceID":8269,"targetID":8271},"8545":{"id":8545,"sourceID":8273,"targetID":8306}},"failureConnectors":{"8281":{"id":8281,"sourceID":8271,"targetID":8270}},"unconditionalConnectors":{"8279":{"id":8279,"sourceID":8268,"targetID":8269},"8280":{"id":8280,"sourceID":8272,"targetID":8273}},"trueConnectors":{},"falseConnectors":{},"iterationConnectors":{},"noteConnectors":{},"canUndo":true,"undoCommand":"Set Parameter","undoCreated":1699895866461,"canRedo":false,"redoCommand":"","redoCreated":-1,"notes":{},"variables":{"jv_groupname":{"definition":{"name":"jv_groupname","type":"TEXT","scope":"TASKBATCH","description":"Name of the Group (optional)","visibility":"PUBLIC"},"value":null},"prvt_endpoint":{"definition":{"name":"prvt_endpoint","type":"TEXT","scope":"TASKBATCH","description":"","visibility":"PRIVATE"},"value":"http://127.0.0.1:8080"},"jv_projectname":{"definition":{"name":"jv_projectname","type":"TEXT","scope":"TASKBATCH","description":"Name of the Project (optional)","visibility":"PUBLIC"},"value":""},"jv_api_password":{"definition":{"name":"jv_api_password","type":"TEXT","scope":"TASKBATCH","description":"That user's password","visibility":"PUBLIC"},"value":""},"jv_api_username":{"definition":{"name":"jv_api_username","type":"TEXT","scope":"TASKBATCH","description":"A user that has permission to use the API","visibility":"PUBLIC"},"value":""},"prvt_python_bin":{"definition":{"name":"prvt_python_bin","type":"TEXT","scope":"TASKBATCH","description":"Path to the Python executable","visibility":"PRIVATE"},"value":"/usr/bin/python3"},"prvt_module_path":{"definition":{"name":"prvt_module_path","type":"TEXT","scope":"TASKBATCH","description":"Subdirectory where Python modules will be installed","visibility":"PRIVATE"},"value":"pip3_ensure/python3requests"},"prvt_import_statement":{"definition":{"name":"prvt_import_statement","type":"TEXT","scope":"TASKBATCH","description":"The search path statement","visibility":"PRIVATE"},"value":"import sys;"}},"grids":{"g_schedules":{"definition":{"name":"g_schedules","scope":"TASKBATCH","definitions":[{"name":"groupname","type":"TEXT"},{"name":"projectname","type":"TEXT"},{"name":"schedulename","type":"TEXT"}],"description":"Output list of schedules","visibility":"PUBLIC"},"values":[]}}}},"transformationJobs":{}}],"version":"1.68.3","environment":"snowflake"}