Open visch opened 3 years ago
In the hunt for the best way to get custom field values
(https://sprints.zoho.com/apidoc.html#Getmultipleitemdetails) doesn't work either. You can pass in any number of ITEM ids, but item props doesn't include custom information
"item_prop": {
"endDate": 7,
"description": 3,
"isNotesAdded": 10,
"itemNo": 17,
"ownerId": 31,
"addedVia": 5,
"hasCheckList": 23,
"leftPosition": 15,
"points": 18,
"duration": 20,
"itemName": 1,
"startAfter": 22,
"createdTime": 19,
"isIntegrated": 12,
"rightPosition": 16,
"rootItem": 25,
"isDocsAdded": 11,
"projPriorityId": 30,
"isParent": 13,
"completedDate": 8,
"itemId": 0,
"sequence": 2,
"sprintId": 26,
"depth": 14,
"epicId": 24,
"statusId": 28,
"createdBy": 4,
"parentItem": 27,
"projItemTypeId": 29,
"startDate": 6,
"completedBy": 21
},
https://sprintsapi.zoho.com/zsapi/team/{{teamId}}/projects/{{projectId}}/?action=itemcfields Pulls the list of custom fields on the project, but still not enough (Documenting all of this as I keep trying in different ways to get this)
Going to generate this for Items at a minimum to add the record object, related to the fix for #15
Going to use https://sdk.meltano.com/en/latest/code_samples.html#dynamically-discovering-schema-for-a-stream
Generate schema from a static list of fields, and add a list of fields from each projects custom field call https://sprintsapi.zoho.com/zsapi/team/{{teamId}}/projects/{{projectId}}/?action=itemcfields
This has been painful, created some custom fields trying to work through this via the API here's my own notes
ZohoSprints allows for Custom Fields, to get this data via the API a query like this works https://sprintsapi.zoho.com/zsapi/team/758947948/projects/114398000000003959/item/no-3/?action=details
In the itemprop section of this response the custom fields are UDF_CHAR2, and UDF_RELEASE1
Querying the itme through the full list of items using https://sprintsapi.zoho.com/zsapi/team/{{teamId}}/projects/{{projectId}}/sprints/114398000000003987/item/?action=sprintitems&index=1&range=25
Doesn't list the custom fields in the response anywhere.
Scope to use: ZohoSprints.projects.READ, ZohoSprints.teams.READ, ZohoSprints.items.READ, ZohoSprints.epic.READ, ZohoSprints.sprints.READ