{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["copy simple table","pivot table 9"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":6,"comments":0,"pivot_tables":1},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"copy simple table","index":0,"n_rows":58,"n_cols":4,"rows_kept":58,"cut":false,"hidden":false,"merged":[]}
["Integration table"]
["Application","Object","API Name","New API"]
["Onepoint","Task",{"$f":"HYPERLINK(\"https://www.onepoint-projects.com/en/resources/api#api-path-/tasks/createActivityComment/{activityId}\",\"POST Create a new activity comment for activity: activityId\")","v":"POST Create a new activity comment for activity: activityId"},{"$f":"CONCATENATE(A3, \" - \", C3, \" = \", A21, \" - \", C21)","v":"Onepoint - POST Create a new activity comment for activity: activityId = Salesforce - method 09"}]
["Onepoint","Task",{"$f":"HYPERLINK(\"https://www.onepoint-projects.com/en/resources/api#api-path-/tasks/deleteActivityComment/{commentId}\",\"DELETE Delete the activity comment: commentId\")","v":"DELETE Delete the activity comment: commentId"},{"$f":"CONCATENATE(C21, \" = \", C26, \" = \", C35, \" = \", C38)","v":"method 09 = method 15 = method 24 = method 27"}]
["Onepoint","Task",{"$f":"HYPERLINK(\"https://www.onepoint-projects.com/en/resources/api#api-path-/tasks/deleteAdHocActivity/{activityId}\",\"DELETE Delete the adhoc activity: activityId\n\")","v":"DELETE Delete the adhoc activity: activityId\n"},"method 11 = method 16 = method 25 = PUT Checks in the given project plan version"]
["Onepoint","Task",{"$f":"HYPERLINK(\"https://www.onepoint-projects.com/en/resources/api#api-path-/tasks/getActivityCategoriesByIds\",\"GET Get activity categories with ids: activityCategoryIds\")","v":"GET Get activity categories with ids: activityCategoryIds"},"method 12 = method 17 = method 26 = PUT Checks out the given project"]
["Onepoint","Task",{"$f":"HYPERLINK(\"https://www.onepoint-projects.com/en/resources/api#api-path-/tasks/getAssignmentsByIds\",\"GET Get the assignments with ids: assignmentIds\")","v":"GET Get the assignments with ids: assignmentIds"}]
["Onepoint","Task",{"$f":"HYPERLINK(\"https://www.onepoint-projects.com/en/resources/api#api-path-/tasks/getParentTask/{activityId}\",\"GET Get the parent activity of activity: activityId\")","v":"GET Get the parent activity of activity: activityId"}]
["Onepoint","Task",{"$f":"HYPERLINK(\"https://www.onepoint-projects.com/en/resources/api#api-path-/tasks/getTaskById/{id}\",\"GET Get the activity: id\")","v":"GET Get the activity: id"}]
["Onepoint","Task",{"$f":"HYPERLINK(\"https://www.onepoint-projects.com/en/resources/api#api-path-/tasks/getTasksByIds\",\"GET Get the activities with ids: activityIds\")","v":"GET Get the activities with ids: activityIds"}]
["Onepoint","Task",{"$f":"HYPERLINK(\"https://www.onepoint-projects.com/en/resources/api#api-path-/tasks/listActivityCategories\",\"GET List all possible activity categories\")","v":"GET List all possible activity categories"}]
["Onepoint","Task",{"$f":"HYPERLINK(\"https://www.onepoint-projects.com/en/resources/api#api-path-/tasks/listChildTasks/{parentId}\",\"GET Get the child activities of activity: parentId\")","v":"GET Get the child activities of activity: parentId"}]
["Onepoint","Task",{"$f":"HYPERLINK(\"https://www.onepoint-projects.com/en/resources/api#api-path-/tasks/listCustomValueInfo\",\"GET List info about custom values for activities\")","v":"GET List info about custom values for activities"}]
["Onepoint","Task",{"$f":"HYPERLINK(\"https://www.onepoint-projects.com/en/resources/api#api-path-/tasks/listModifiedTasks\",\"GET List activities containing assignments for: resourceId which were modified between: from and: until\")","v":"GET List activities containing assignments for: resourceId which were modified between: from and: until"}]
["Onepoint","Task",{"$f":"HYPERLINK(\"https://www.onepoint-projects.com/en/resources/api#api-path-/tasks/listMyModifiedTasks\",\"GET List activities containing assignments for resources linked to the current user which were modified between: from and: until\")","v":"GET List activities containing assignments for resources linked to the current user which were modified between: from and: until"}]
["Onepoint","Task",{"$f":"HYPERLINK(\"https://www.onepoint-projects.com/en/resources/api#api-path-/tasks/listMyTasks\",\"GET List activities containing assignments linked to: resourceIds for projects: projectIds started before: until finished before: from also include completed tasks: completed\")","v":"GET List activities containing assignments linked to: resourceIds for projects: projectIds started before: until finished before: from also include completed tasks: completed"}]
["Onepoint","Task",{"$f":"HYPERLINK(\"https://www.onepoint-projects.com/en/resources/api#api-path-/tasks/listTasksOfProject/{projectId}\",\"GET List activities belonging to project: projectId\")","v":"GET List activities belonging to project: projectId"}]
["Onepoint","Task",{"$f":"HYPERLINK(\"https://www.onepoint-projects.com/en/resources/api#api-path-/tasks/updateActionStatus/{actionId}\",\"PUT Set the status of action: actionId to: status\")","v":"PUT Set the status of action: actionId to: status"}]
["Onepoint","Task",{"$f":"HYPERLINK(\"https://www.onepoint-projects.com/en/resources/api#api-path-/tasks/updateActivityComment\",\"PUT Update the activity comment\")","v":"PUT Update the activity comment"}]
["Onepoint","Task",{"$f":"HYPERLINK(\"https://www.onepoint-projects.com/en/resources/api#api-path-/tasks/updateAdHocActivity\",\"PUT Update the adhoc activity\")","v":"PUT Update the adhoc activity"}]
["Salesforce","Obj 09","method 09"]
["Salesforce","Obj 11","method 11"]
["Salesforce","Obj 12","method 12"]
["Salesforce","Obj 13","method 13"]
["Salesforce","Obj 14","method 14"]
["Salesforce","Obj 15","method 15"]
["Salesforce","Obj 16","method 16"]
["Salesforce","Obj 17","method 17"]
["Salesforce","Obj 18","method 18"]
["Salesforce","Obj 19","method 19"]
["Salesforce","Obj 20","method 20"]
["Salesforce","Obj 21","method 21"]
["Salesforce","Obj 22","method 22"]
["Salesforce","Obj 23","method 23"]
["Salesforce","Obj 24","method 24"]
["Salesforce","Obj 25","method 25"]
["Salesforce","Obj 26","method 26"]
["Salesforce","Obj 27","method 27"]
["Onepoint","Planning",{"$f":"HYPERLINK(\"https://www.onepoint-projects.com/en/resources/api#api-path-/planning/checkIn/{projectId}\",\"PUT Checks in the given project plan version\")","v":"PUT Checks in the given project plan version"}]
["Onepoint","Planning",{"$f":"HYPERLINK(\"https://www.onepoint-projects.com/en/resources/api#api-path-/planning/edit/{projectId}\",\"PUT Checks out the given project\")","v":"PUT Checks out the given project"}]
["Onepoint","Planning",{"$f":"HYPERLINK(\"https://www.onepoint-projects.com/en/resources/api#api-path-/planning/importProjectPlan/{projectId}\",\"PUT Imports a project plan from a given an MS Project file (.mpx, .xml or .mpp) or a given Excel file (.xls)\")","v":"PUT Imports a project plan from a given an MS Project file (.mpx, .xml or .mpp) or a given Excel file (.xls)"}]
["Onepoint","Planning",{"$f":"HYPERLINK(\"https://www.onepoint-projects.com/en/resources/api#api-path-/planning/listAssignmentVersions/{activityVersionId}\",\"GET List assignment versions for activty version: activityVersionId\")","v":"GET List assignment versions for activty version: activityVersionId"}]
["Intact","Obj 12","method 12"]
["Intact","Obj 13","method 13"]
["Intact","Obj 14","method 14"]
["Intact","Obj 15","method 15"]
["Onepoint","Projects",{"$f":"HYPERLINK(\"https://www.onepoint-projects.com/en/resources/api#api-path-/projects/addProjectAssignment/{projectId}\",\"POST Add a project assignment to project: projectId for resource: resourceId\")","v":"POST Add a project assignment to project: projectId for resource: resourceId"}]
["Onepoint","Projects",{"$f":"HYPERLINK(\"https://www.onepoint-projects.com/en/resources/api#api-path-/projects/createPortfolio/{superPortfolioId}\",\"POST Create a new portfolio with parent: superPortfolioId\")","v":"POST Create a new portfolio with parent: superPortfolioId"}]
["Sage people","Obj 14","method 14"]
["Sage people","Obj 15","method 15"]
["Salesforce","Obj1","method 1"]
["Onepoint","Obj 16","method 16"]
["Intact","Obj2","method 2"]
["Jira","Obj 17","method 17"]
["Sage people","Obj3","method 3"]
["Intact","Obj 18","method 18"]
["Jira","Obj4","method 4"]
["Onepoint","Obj 19","method 19"]

{"sheet":"pivot table 9","index":1,"n_rows":39,"n_cols":3,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
["Application","Object","New API"]
["Intact","Obj 12","method 12 + method 14 + method 17"]
[null,"Obj 13","(blank)"]
[null,"Obj 14","(blank)"]
[null,"Obj 15","(blank)"]
[null,"Obj 18","(blank)"]
[null,"Obj2","(blank)"]
["Jira","Obj 17","(blank)"]
[null,"Obj4","(blank)"]
["Onepoint","Obj 16","(blank)"]
[null,"Planning","(blank)"]
[null,"Projects","(blank)"]
[null,"Task","method 09 = method 15 = method 24 = method 27"]
[null,null,"method 11 = method 16 = method 25 = PUT Checks in the given project plan version"]
[null,null,"method 12 = method 17 = method 26 = PUT Checks out the given project"]
[null,null,"Onepoint - POST Create a new activity comment for activity: activityId = Salesforce - method 09"]
[null,null,"(blank)"]
["Sage people","Obj 14","(blank)"]
[null,"Obj 15","(blank)"]
[null,"Obj3","(blank)"]
["Salesforce","Obj 09","(blank)"]
[null,"Obj 11","(blank)"]
[null,"Obj 12","(blank)"]
[null,"Obj 13","(blank)"]
[null,"Obj 14","(blank)"]
[null,"Obj 15","(blank)"]
[null,"Obj 16","(blank)"]
[null,"Obj 17","(blank)"]
[null,"Obj 18","(blank)"]
[null,"Obj 19","(blank)"]
[null,"Obj 20","(blank)"]
[null,"Obj 21","(blank)"]
[null,"Obj 22","(blank)"]
[null,"Obj 23","(blank)"]
[null,"Obj 24","(blank)"]
[null,"Obj 25","(blank)"]
[null,"Obj 26","(blank)"]
[null,"Obj 27","(blank)"]
[null,"Obj1","(blank)"]