View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - Export Activity with API: fixPlanning key is duplicated in json - ProjeQtOr
 

Export Activity with API: fixPlanning key is duplicated in json

More
18 Aug 2022 18:26 #1 by RemyApside
When using API to get the activity, the fixPlanning key is duplicated, thus the json cannot be exploited in Excel Power Query.
Exemple of returned json for /api/index.php?uri=activity/1 :{"identifier":"id", "items":[{"id":"1", "reference":"-DEV-1", "name":"Rédaction spécification", "idActivityType":"19", "nameActivityType":"Development", "idProject":"1", "nameProject":"Projet Rémy 1", "externalReference":"", "creationDate":"2022-08-09", "lastUpdateDateTime":"2022-08-09 18:18:49", "idUser":"3", "nameUser":"Rémy", "idContact":"", "nameContact":"", "originType":"", "originId":"", "refName":"Rédaction spécification", "description":"", "idActivity":"", "nameActivity":"", "idStatus":"1", "nameStatus":"recorded", "idResource":"", "nameResource":"", "idMilestone":"", "nameMilestone":"", "[color=#e74c3c]fixPlanning[/color]":"0", "paused":"0", "handled":"0", "handledDate":"", "done":"0", "doneDate":"", "idle":"0", "idleDate":"", "cancelled":"0", "result":"", "validatedStartDate":"", "plannedStartDate":"2022-08-09", "realStartDate":"", "initialStartDate":"", "validatedEndDate":"", "plannedEndDate":"2022-08-22", "realEndDate":"", "initialEndDate":"", "validatedDuration":"", "plannedDuration":"10", "realDuration":"", "initialDuration":"", "validatedWork":"10.00000", "assignedWork":"10.00000", "realWork":"0.00000", "leftWork":"10.00000", "plannedWork":"10.00000", "validatedCost":"", "assignedCost":"", "realCost":"", "leftCost":"", "plannedCost":"", "progress":"0", "expectedProgress":"0", "wbs":"1.2", "priority":"500", "idActivityPlanningMode":"1", "nameActivityPlanningMode":"as soon as possible", "color":"", "minimumThreshold":"0.0000", "indivisibility":"0", "[color=#e74c3c]fixPlanning[/color]":"0", "paused":"0", "workElementCount":"0", "workElementEstimatedWork":"", "workElementRealWork":"", "workElementLeftWork":"", "workOnRealTime":"0", "idProduct":"", "nameProduct":"", "idComponent":"", "nameComponent":"", "idTargetProductVersion":"", "nameTargetProductVersion":"", "idTargetComponentVersion":"", "nameTargetComponentVersion":"", "targetValue":"0", "actualValue":"0", "pctRate":"0", "refName":"Rédaction spécification"}] }

Please Log in or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.039 seconds

Cookies settings

×

Functional Cookies

Ce site utilise des cookies pour assurer son bon fonctionnement et ne peuvent pas être désactivés de nos systèmes. Nous ne les utilisons pas à des fins publicitaires. Si ces cookies sont bloqués, certaines parties du site ne pourront pas fonctionner.

Session

Please login to see yours activities!

Other cookies

Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.