{
	"name": "form/nc/erp-sync/clickup/query/product_work-actual.json",
	"info": "API: Teams (user groups) Get Teams, start_date 2000-01-01: https://api.clickup.com/api/v2/team/20526952/time_entries?start_date=946677600000",
	"table": [
		{
			"table": "product_work",
			"record_type": ["actual"]
		},
		{
			"column": "form/nc/erp-sync/clickup/column/product.json",
			"table": "product",
			"record_type": [""],
			"row_tag": "task"
		},
		{
			"column": "form/nc/erp-sync/clickup/column/person-employee.json",
			"table": "person",
			"record_type": ["employee"],
			"row_tag": "user"
		}
	],
	"parameter": {
		"full_rest_answer_tag": "prwo.json_data.additional_data",
		"team_id": "20526952",
		"start_date": 0,
		"show_sql": false
	},
	"call_url": "team/{{team_id}}/time_entries?start_date={{start_date}}",
	"organization_id": "clickup",
	"query": [],
	"default_value": {
		"product_work": {
			"static": {
				"person_id": "PM",
				"resource_id": "CLICKUP"
			},
			"copy_value": {
				"product_id": "json_data.additional_data.task.id"
			},
			"code": [
				{
					"function": "calculate",
					"info": "milliseconds to hours, / 1000 / 60 seconds / 60 minutes",
					"parameter": ["work_hours", "/", 1000, "/", 3600],
					"result": "work_hours"
				},
				{
					"function": "dt.millisecondToDateString",
					"parameter": ["json_data.start_time"],
					"result": "json_data.start_date"
				},
				{
					"function": "dt.millisecondToLocalTimeString",
					"parameter": ["json_data.start_time"],
					"result": "json_data.start_time"
				},
				{
					"function": "dt.millisecondToDateString",
					"parameter": ["json_data.end_time"],
					"result": "json_data.end_date"
				},
				{
					"function": "dt.millisecondToLocalTimeString",
					"parameter": ["json_data.end_time"],
					"result": "json_data.end_time"
				}
			]
		}
	}
}
