+{% codeblock as python %}
+import arvados
+def get_cr_state(cr_uuid):
+ api = arvados.api()
+ cr = api.container_requests().get(uuid=cr_uuid).execute()
+ if cr['container_uuid'] is None:
+ return cr['state']
+ c = api.containers().get(uuid=cr['container_uuid']).execute()
+ if cr['state'] == 'Final' and c['state'] != 'Complete':
+ return 'Cancelled'
+ elif c['state'] in ['Locked', 'Queued']:
+ if c['priority'] == 0:
+ return 'On hold'
+ else:
+ return 'Queued'
+ elif c['state'] == 'Complete' and c['exit_code'] != 0:
+ return 'Failed'
+ elif c['state'] == 'Running':
+ if c['runtime_status'].get('error', None):
+ return 'Failing'
+ elif c['runtime_status'].get('warning', None):
+ return 'Warning'
+ return c['state']
+container_request_uuid = 'zzzzz-xvhdp-zzzzzzzzzzzzzzz'
+print(get_cr_state(container_request_uuid))
+{% endcodeblock %}
+
+h2. List input of child requests
+
+{% codeblock as python %}
+import arvados
+api = arvados.api()
+parent_request_uuid = "zzzzz-xvhdp-zzzzzzzzzzzzzzz"
+namefilter = "bwa%" # the "like" filter uses SQL pattern match syntax
+container_request = api.container_requests().get(uuid=parent_request_uuid).execute()
+parent_container_uuid = container_request["container_uuid"]
+child_requests = api.container_requests().list(filters=[
+ ["requesting_container_uuid", "=", parent_container_uuid],
+ ["name", "like", namefilter]]).execute()
+for c in child_requests["items"]:
+ print("%s" % c["name"])
+ for m in c["mounts"].values():
+ if "portable_data_hash" in m:
+ print(" %s" % m["portable_data_hash"])
+{% endcodeblock %}
+
+h2. List output of child requests
+
+{% codeblock as python %}
+import arvados
+api = arvados.api()
+parent_request_uuid = "zzzzz-xvhdp-zzzzzzzzzzzzzzz"
+namefilter = "bwa%" # the "like" filter uses SQL pattern match syntax
+container_request = api.container_requests().get(uuid=parent_request_uuid).execute()
+parent_container_uuid = container_request["container_uuid"]
+child_requests = api.container_requests().list(filters=[
+ ["requesting_container_uuid", "=", parent_container_uuid],
+ ["name", "like", namefilter]]).execute()
+output_uuids = [c["output_uuid"] for c in child_requests["items"]]
+collections = api.collections().list(filters=[["uuid", "in", output_uuids]]).execute()
+uuid_to_pdh = {c["uuid"]: c["portable_data_hash"] for c in collections["items"]}
+for c in child_requests["items"]:
+ print("%s -> %s" % (c["name"], uuid_to_pdh[c["output_uuid"]]))
+{% endcodeblock %}
+
+h2. List failed child requests
+
+{% codeblock as python %}
+import arvados
+api = arvados.api()
+parent_request_uuid = "zzzzz-xvhdp-zzzzzzzzzzzzzzz"
+container_request = api.container_requests().get(uuid=parent_request_uuid).execute()
+parent_container_uuid = container_request["container_uuid"]
+child_requests = api.container_requests().list(filters=[
+ ["requesting_container_uuid", "=", parent_container_uuid]], limit=1000).execute()
+child_containers = {c["container_uuid"]: c for c in child_requests["items"]}
+cancelled_child_containers = api.containers().list(filters=[
+ ["exit_code", "!=", "0"],
+ ["uuid", "in", list(child_containers.keys())]], limit=1000).execute()
+for c in cancelled_child_containers["items"]:
+ print("%s (%s)" % (child_containers[c["uuid"]]["name"], child_containers[c["uuid"]]["uuid"]))
+{% endcodeblock %}
+
+h2. Get log of a child request
+
+{% codeblock as python %}
+import arvados
+import arvados.collection
+api = arvados.api()
+container_request_uuid = "zzzzz-xvhdp-zzzzzzzzzzzzzzz"
+container_request = api.container_requests().get(uuid=container_request_uuid).execute()
+collection = arvados.collection.CollectionReader(container_request["log_uuid"])
+for c in collection:
+ if isinstance(collection.find(c), arvados.arvfile.ArvadosFile):
+ print(collection.open(c).read())
+{% endcodeblock %}
+
+h2(#sharing_link). Create a collection sharing link
+
+{% codeblock as python %}