LiquidPlanner Classic Forum
Exporting Data to a csv
*Posted on behalf of William Calhoun. Original posting date 2015-07-21.*
Hello,
I am trying to mimic the "export tasks to csv" output using the API. To my understanding there is no direct function in the API for exporting to csv.
I am trying to recreate the process by building off the python code you attach in your "sample API code". I can write out the JSON objects of all the levels of hierarchy. Tasks, Projects, Packages, Folders, Events, Milestones
However each csv is quite messy and none of them look anything like the 'export tasks to csv' output. I have access to the space I want and can access any element I want. I want to recreate the output of the 'export tasks to csv' as closely as possible. Below is my modified code where I can export projects and tasks separately. Any help would be much appreciated!
Attached is my modified python file, the output of me exporting projects and tasks. And the output that you get from using the GUI's 'export tasks to csv' (liquid planner output one)
Posted by LiquidPlanner Support over 4 years ago
Adding comments to task with API
I try follow the documentation with: (sanitised)
curl -H "Authorization: Bearer xxxxxxxxxxxxxxxxxxxxxxxx" https://app.liquidplanner.com/api/v1/workspaces/xxxxxx/tasks/xxxxxxxx/comments '{"comment":{"comment":"Written through API outside of LP - Hope your code is going well"}}' -X POST
returns with:
{"type":"Error","error":"BadArgument","message":"Expected a hash of attribute values for comment parameter"}curl: (3) nested brace in URL position 11:
'{comment:{comment:Written through API outside of LP - Hope your code is going well}}'
I've tried same without the single quotes as some have done and similar response, any ideas please?
Posted by bob cudmore about 2 years ago
Microsoft Teams integration
Has anyone created any automation/links between Liquid Planner and Microsoft Teams? I see other integrations in Teams from other project management software that looks pretty impressive, but not from LP or even Microsoft Project online, yet.
Posted by Alex Subler over 3 years ago
C# API access - Custom Fields
*Posted on behalf of Lee Raybone. Original posting date 2015-06-22.*
Is this possible in C#, when creating a new task?
How would I be accessing the custom fields on the task?
Also is it plausible to access the Estimate and the Deadline using C# on creation of task?
Regards
Posted by LiquidPlanner Support over 4 years ago
Forward looking report - is hours per person, per day, per project possible via API?
*Posted on behalf of a customer. Original posting date 2016-04-12.*
Greetings, we are manually feeding data into Microsoft's Power BI (MS Tableau basically) via timesheet export to enable the attached image.
In speaking with my main contact there, his assessment of what data would be necessary to provide a similar view of future work would be:
hours per person, per day, per project. To this end, my questions are:
1. Is this possible via API?
2. Is there a different data set (aside from the one in the title) that would accomplish the same result...perhaps more easily?
3. Any detail as to what calls they might need to make, (in case that's not terribly complex and handled more efficiently in a live discussion, etc.)
Please let me know if I can offer any clarification. Thanks!
Posted by LiquidPlanner Support over 4 years ago
JIRA Integration help needed
*Posting on behalf of a customer. Original posting date 2014-11-21.*
We have spent about 4 weeks working on integrating JIRA with LiquidPlanner and still are probably still a few weeks away from getting basic functionality to work. I feel like this has been done before by someone/somewhere/somehow. If anyone has any code they are willing to share it would be appreciated. We are using webhooks in both platforms with the API and are trying to do a two way sync. We have stumbled and punted on issues like how comment edits are handled and workflow/card sync.
So if there is full blown file that has been executed in the past (with sensitive data removed) it would be greatly appreciated.
PS. I understand that every implementation is different but having an example of how someone has built it out would be super helpful.
Posted by LiquidPlanner Support over 4 years ago
Timesheet and TimesheetEntry CREATE,UPDATE,DELETE
*Posted on behalf of Damian Sima. Original posting date 2013-05-16.*
Hi guys,
Timesheet and TimesheetEntry entities looks like entities that sums ups data from your API as such I guess they can not be CREATED,UPDATED or DELETED.
Is this correct?
Cheers, Damian.
Posted by LiquidPlanner Support over 4 years ago
How to use LP API in JavaScript?
Hi,
I am trying to run this JS code from the doc:
https://developer.liquidplanner.com/reference#get_account
var data = JSON.stringify(false);
var xhr = new XMLHttpRequest();
xhr.withCredentials = true;
xhr.addEventListener("readystatechange", function () {
if (this.readyState === this.DONE) {
console.log(this.responseText);
}
});
xhr.open("GET", "https://app.liquidplanner.com/api/v1/account");
xhr.send(data);
On running it on the browser, I get a prompt to enter username and password, after entering the credentials, I get the following error on local system and also on server after deploying:
Access to XMLHttpRequest at 'https://app.liquidplanner.com/api/v1/account' from origin 'http://localhost:3002' (https://myservername.com/) has been blocked by CORS policy: No 'Access-Control-Allow-Origin' header is present on the requested resource.
Is there any parameter configuration to be added on the xhr request to make it work?
Posted by Deepak MS over 3 years ago
Github Integration
*Posted on behalf of Max. Original post date 2014-07-08*
We keep our code repo on github
... and while LP states it has an open API and talks about people integrating github via that API, there is no service listed for LiquidPlanner on github.
... so I then investigate Webhooks ... webhooks are available both in Github and LP ... but not sure how I can set this up? Bascially, I want to be able to see in LP when a commit (or other event) is made on Github - that way both ourselves and the clients can see the update that was made in LP and have a link to the record in github to see the details.
On the Github side it has:
- payload url
- content type
- secret.
Can we get a URL and secret for each project / package / milestone - where can we get this from? Is it possible to have the info pushed from github to my projects ... please advise.
It looks like the LP webhooks are from pushing info from LP into some other app ... is there some extra information on how to do this .... or maybe to push issues to github from LP.
Would really like to use this ... and working this out and getting some extra information/blogpost about this out to the community can only help strengthen LP.
BTW: many other project systems ARE listed in github services ... sort of surprised LP isn't already there.
Posted by LiquidPlanner Support over 4 years ago
How to move a task from one package to another?
Hello,
I came across this doc:
https://developer.liquidplanner.com/docs/create-and-update-examples
However, I couldn't find the api which helps me in moving the task from one package to another. I see that parent_id needs to be updated, but I did not get any api which does that.
I also checked:
https://developer.liquidplanner.com/docs/moving-and-packaging-items
% curl https://app.liquidplanner.com/api/v1/workspaces/:id/tasks/:id/move_before?other_id=:id -X POST
% curl https://app.liquidplanner.com/api/v1/workspaces/:id/tasks/:id/move_after?other_id=:id -X POST
I know the workspace id and I know the task id(which needs to be moved). But where do I specify target package \ folder id in the above link?
I had a look at all the available APIs too. I did not find anything specific to parent_id updation:
https://app.liquidplanner.com/api/v1/help/urls
Kindly let me know.
Posted by Deepak MS over 3 years ago