Currently Skyvia is creating a table with the columns "ProjectManager" and "ProjectManagerName" but these are always null.
The API call:
http://people.zoho.eu/people/api/timetracker/getprojects?assignedTo=all&projectStatus=all
returns JSON with the following entries:
"projectManagers": [ { "empId": "05", "erecno": "11455000000065001", "rate": 0, "name": "John Smith" }, { "empId": "08", "erecno": "11455000000347001", "rate": 0, "name": "Jane Doe" } ],
"projectHead": { "empId": "05", "erecno": "11455000000065001", "rate": 0, "name": "Joe Bloggs" },
ie an array of Project Managers and a single Project Head (which are system fields for a Project in Zoho People).
It would be good if at least the Project Head (or alternatively, the first named Project Manager) could be replicated.
Thanks