LiquidPlanner Classic Forum
How do you update the work performed on a time entry
*Posted on behalf of howard. Original posting date 2015-09-29.*
I need to write a tool that updates existing time entries to fix a rounding issue that we're seeing on LiquidPlanner. Is there a way to update an existing timesheet entry?
Posted by LiquidPlanner Support over 4 years ago
Can you obtain a trend chart image (as JPEG or PDF) by calling the API
*Posted on behalf of Ed Dennison. Original posting date 2015-09-11.*
Is there any way to use the API to obtain an image for a trend chart or other LP graphic through the API?
Posted by LiquidPlanner Support over 4 years ago
Compiling Hours for an Activity via the API
*Posted on behalf of Colin Pickup. Original posting date 2015-09-10.*
I am trying to compile the hours of support work done in the company workspace using the API. For this to work, I need to be able to link a timesheet with an activity or assignment using the API, but I can't see how these two might be linked.
Support is one of the activity types in our workspace, I need to sum the hours every month for each client. That is to say, this month 10 hours were spent on support for client X and 5 for client 5.
From the looks of things, I can see when hours were actioned using the timesheets, but these are not broken down by activity.
I can see the activity on the task assignment, and the number of hours logged, but it has no record of *when* the hours are logged.
Is there a way to link these two using the API?
Posted by LiquidPlanner Support over 4 years ago
Is it possible to create a cross-reference link via API?
*Posted on behalf of a customer. Original posting date 2015-08-20.*
Is there a way to create a cross reference link via the API (other than creating two separate links on each task)? From what I can tell, there doesn't appear to be any way to post (or even view) a cross reference via the API.
Posted by LiquidPlanner Support over 4 years ago
I am unable to get the API limit filter to work when returning treeitems
*Posted on behalf of Chris Pauly. Original posting date 2015-08-05.*
I want to find the package name containing the earliest, active project/task inside our active queue package of items for a given client. So I tried writing this API call:
```
https://app.liquidplanner.com/api/workspaces/:wid/treeitems/:activequeueid?depth=-1&filter[]=is_done is false&filter[]=client_id=:clientid&limit=1
```
It returns the items I want... although I only care about the first item. Is there a reason the limit parameter doesn't work for this API call?
Posted by LiquidPlanner Support over 4 years ago
Get notes for specific time entry?
*Posted on behalf of Jack Smith. Original posting date 2015-08-04.*
I'm using a webhook on time entries to input time in to a ticketing system that we currently use to track our billable time.
For example, if I put in a time entry on Task 1 and set the note to "This is a note" and then put in a 2nd time entry on Task 1 with a note saying "This is another note", the notes that are sent for the 2nd time entry are this:
```
note":"This is a note, This is another note",
```
What I'd like to get from the 2nd time entry is just this:
```
note":"This is another note",
```
Is there any way to get the specific note for each time entry?
Posted by LiquidPlanner Support over 4 years ago
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
How to create a task in a nested subfolder?
*Posted on behalf of a customer. Original posting date 2015-06-25.*
How to create a task under folder tree MainFolder => FirstSubfolder => FirstSubToSubFolder => TaskToBeCreated in LiquidPlanner from REST API ?
How to create a task under a main folder then sub folder then one more sub folder under the sub folder in the LiquidPlanner from REST API ?
Please send me URL and JSON data and method to be used."
I found this example in the API guide:
```% curl https://app.liquidplanner.com/api/workspaces/:id/tasks -d '{"task": {"name": "learn the API”}}' -X POST```
but not sure how to add folder id.
Thank you.
Posted by LiquidPlanner Support over 4 years ago
How to display Contract Value via API
*Posted on behalf of a customer. Original posting date 2015-06-19.*
I have project using the REST API to display the Contract Value for a Project ID. My Manager, who should have the necessary rights, still sees a 0 value. Can you please explain how this value is granted viewable rights and how to access it properly?
Posted by LiquidPlanner Support over 4 years ago
How to get the cost of billable task in api
*Posted on behalf of arnel marco. Original posting date 2015-06-05.*
I need to get the json related data of billable task in lp api
Posted by LiquidPlanner Support over 4 years ago