Data Factory Use Cases

Compute the average resolution time of comment threads per partner

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 a report, made available by email, that contains the average resolution time of comment threads per partner. This job intends to illustrate the use of tasks such as data-comment-thread-find and data-account-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 user will receive an email containing the report.

Example:

Data Factory job in details

flowchart TD
	_start(("Start"))
	_end(("End"))
	fetch_current_user["<b><a href='/data-factory/references/tasks/context-user-get/'>context-user-get</a></b><br />Fetch current user"]
	fetch_comment_threads["<b><a href='/data-factory/references/tasks/data-comment-thread-find/'>data-comment-thread-find</a></b><br />Fetch comment threads"]
	fetch_accounts["<b><a href='/data-factory/references/tasks/data-account-find/'>data-account-find</a></b><br />Fetch accounts"]
	compute_filter_comment_threads_closed["<b><a href='/data-factory/references/tasks/json-transform-jq/'>json-transform-jq</a></b><br />Filter comment threads opened and assigned to my account"]
	convert_comment_threads["<b><a href='/data-factory/references/tasks/file-conversion-json-to-xml/'>file-conversion-json-to-xml</a></b><br />JSON to XML conversion of comment threads"]
	counvert_accounts["<b><a href='/data-factory/references/tasks/file-conversion-json-to-xml/'>file-conversion-json-to-xml</a></b><br />JSON to XML conversion of accounts"]
	file_transformation_xslt["<b><a href='/data-factory/references/tasks/file-transformation-xslt/'>file-transformation-xslt</a></b><br />Generate Email Body"]
	notification_display_message["<b><a href='/data-factory/references/tasks/notification-display-message/'>notification-display-message</a></b><br />Display Message"]
	notification_send_email["<b><a href='/data-factory/references/tasks/notification-send-email/'>notification-send-email</a></b><br />Send Email"]
	_start --> fetch_current_user
	fetch_current_user --> fetch_comment_threads
	fetch_comment_threads --> fetch_accounts
	fetch_accounts --> compute_filter_comment_threads_closed
	compute_filter_comment_threads_closed --> convert_comment_threads
	convert_comment_threads --> counvert_accounts
	counvert_accounts --> file_transformation_xslt
	file_transformation_xslt --> notification_display_message
	notification_display_message --> notification_send_email
	notification_send_email --> _end