Learning Center

Data Factory Use Cases ​

Export job executions to an Excel spreadsheet ​

Quick links

The job is available for download here.

The JSON representation of the job is available here.

The purpose of this Data Factory job is to produce an Excel spreadsheet containing the list of executions of every job ran in a given account. This job intends to illustrate the use of tasks such as data-job-execution-find and data-job-find.

This job is made to be triggered by a user (from the app.product-live.com or the settings.product-live.com application). No parameters are required to trigger this job. The spreadsheet will be made available for download at the end of the job.

Data Factory job in details ​

mermaid
flowchart TD
	_start(("Start"))
	_end(("End"))
	get_start_date["<b><a href='/data-factory/references/tasks/code-execute-javascript/'>code-execute-javascript</a></b><br />Get Start Date"]
	find_job_executions["<b><a href='/data-factory/references/tasks/data-job-execution-find/'>data-job-execution-find</a></b><br />Find Job Executions"]
	find_jobs["<b><a href='/data-factory/references/tasks/data-job-find/'>data-job-find</a></b><br />Find Jobs"]
	file_conversion_json_to_xml_job_instances["<b><a href='/data-factory/references/tasks/file-conversion-json-to-xml/'>file-conversion-json-to-xml</a></b><br />Convert job executions JSON to XML"]
	file_conversion_json_to_xml_jobs["<b><a href='/data-factory/references/tasks/file-conversion-json-to-xml/'>file-conversion-json-to-xml</a></b><br />Convert Jobs JSON to XML"]
	file_transformation_xslt["<b><a href='/data-factory/references/tasks/file-transformation-xslt/'>file-transformation-xslt</a></b><br />Generate input for excel task"]
	file_generation_xlsx["<b><a href='/data-factory/references/tasks/file-generation-xlsx/'>file-generation-xlsx</a></b><br />Generate Excel Sheet"]
	_start --> get_start_date
	get_start_date --> find_job_executions
	find_job_executions --> find_jobs
	find_jobs --> file_conversion_json_to_xml_job_instances
	file_conversion_json_to_xml_job_instances --> file_conversion_json_to_xml_jobs
	file_conversion_json_to_xml_jobs --> file_transformation_xslt
	file_transformation_xslt --> file_generation_xlsx
	file_generation_xlsx --> _end