Deputy json file
[ { "cmd":"get_raw_timesheets" }, { "cmd":"group_rows", "keep_columns":[ "Employee" ], "on_column":[ "Cost", "TotalTime" ], "operator":"+" }, { "cmd":"apply_rest", "url":"resource/Employee/QUERY", "post":{ "search":{ "esearchl":{ "field":"Id", "type":"eq", "data":"__Employee__" } } }, "pick_value":"DisplayName", "column":"DisplayName" }, { "cmd":"print_header", "columns":[ "Employee Name", "TotalTime", "TotalCost" ], "column_sep":",", "column_enclosure":"" }, { "cmd":"print_rows", "columns":[ "DisplayName", "TotalTime", "Cost" ], "column_sep":",", "column_enclosure":"" }]