Projects

1entries = list();
2loopHack = "loop.".repeat(5000);
3loopHackList = loopHack.toList(".");
4page = 1;
5request = Map();
6//request.putAll({"module": "quotes"});
7return_val = Collection();
8param = Map();
9current_date = zoho.currentdate;
10start = current_date.subDay(7);
11// filter_object = Map();
12// filter_object.put("start_datetime", start);
13// filter_object.put("end_datetime", current_date);
14param.put("apiKey","<redacted_api_key>");
15param.put("lang","eng");
16param.put("company_account_id","<account>");
17param.put("detailed_response",true);
18param.put("request",{});
19// param.put("filter",filter_object);
20for each  loop in loopHackList
21{
22	param.putAll({"page":page});
23	req = invokeurl
24	[
25		url :"https://<account>.scoro.com/api/v2/timeEntries/list"
26		type :POST
27		parameters:param.toString()
28	];
29	data = req.get("data");
30	entries.addAll(data);
31	if(data.size() < 25)
32	{
33		break;
34	}
35	else
36	{
37		page = page + 1;
38	}
39}
40delete from Time_Entries[Time_Entry_ID != null];
41for each  entry in entries
42{
43	duration = entry.get("duration");
44	bilduration = entry.get("billable_duration");
45	// 	time1 = bilduration.toList(":");
46	// 	time = duration.toList(":");
47	// 	seconds1 = toNumber(time1.get(0)) * 3600 + toNumber(time1.get(1)) * 60;
48	// 	seconds = toNumber(time.get(0)) * 3600 + toNumber(time.get(1)) * 60;
49	// 	ms = toNumber(time.get(1)) * 60;
50	// 	ss = toNumber(time.get(2));
51	// 	seconds = hs+ms+ss;
52	res = Tasks[Event_ID == entry.get("event_id")];
53	new_entry = insert into Time_Entries
54	[
55		Added_User=zoho.loginuser
56		Time_Entry_ID=entry.get("time_entry_id")
57		Description=entry.get("description")
58		Title=entry.get("title")
59		User_ID=entry.get("user_id")
60		Invoice_Line_ID=entry.get("invoice_line_id")
61		is_completed=entry.get("is_completed")
62		is_confirmed=entry.get("is_confirmed")
63		is_billable=entry.get("is_billable")
64		Event_ID=entry.get("event_id")
65		Tasks=res.ID
66		Completed_Date_Time=entry.get("completed_datetime")
67		End_Date_time=toString(entry.get("end_datetime")).replaceFirst("T"," ").toDateTime()
68		is_deleted=entry.get("is_deleted")
69		Start_Date_Time=toString(entry.get("start_datetime")).replaceFirst("T"," ").toDateTime()
70		Deleted_Date=entry.get("deleted_date")
71		Calendar_event_id=entry.get("calendar_event_id")
72		Modified_Date_Time=entry.get("modified_date")
73		Time_entry_Type=entry.get("time_entry_type")
74		Activity_ID=entry.get("activity_id")
75	];
76}
77// 	Duration=thisapp.time_to_seconds(duration)
78// 		Billable_Duration=thisapp.time_to_seconds(bilduration)