LiquidPlanner Classic Forum

*Posted on behalf of Laszlo Peter. Original posting date 2016-02-22.* I would like to filter those active tasks that are currently assigned to me and I have any TODO with them. I tried the following filter: ```.../workspaces/MYWORKSPACEID/tasks?filter[]owner_id=MYID&filter[]=is_done is false``` With this filter I get those tasks which was created by me, but if a task has multiple owners, and my part is done (I already marked done), I wouldn't like to see this task. If someone else crated a task, and added me as a second owner, I would like to see that task also, until I mark done "my part" of this task. Thank you!

*Posted on behalf of Anton Stonor. Original posting date 2016-01-09.* Hi, I'm about the pull data from the API to build a custom SLA report for a client. One rule is that a task has to be assigned to a developer within a specific time. So I need to find out when a task has been assigned. From poking around it looks like I might need the "Change" type to get such historical data. I can get a list of changes from ``` /api/workspaces/<id>/changes ``` but it looks like it always gives me the latest 100 changes and that the filter[] query string does not apply. So - is there a way to do what I want? As a plan B I've considered to subscribe to webhook messages and buld a change storage myself, but it would be easier to just query the Liquid Planner API. /Anton

*Posted on behalf of Aaron M. Original posting date 2016-01-09.* I'm trying to only grab projects where the task has a specific person_id. Is this possible using the current filter[] query. If so what would the query be?

*Posted on behalf of Mark Hodgkinson. Original posting date 2015-12-07.* I am trying to create an event through the API, and it seems to work, but not properly. It always seems to create my Event as a Task. The URL is: https://app.liquidplanner.com/api/workspaces/xxxxxxx/tasks The data is: {"task": {"activity_id":0,"work":0.0,"alerts":null,"project_id":null,"client_id":null,"client_name":null,"created_at":null,"created_by":0, "custom_field_values":null,"done_on":null,"started_on":null,"start_date":"2015-12-15T00:00:00","description":null, "earliest_finish":null,"earliest_start":null,"expected_finish":null,"expected_start":null,"p98_finish":null,"global_priority":null, "global_package_priority":null,"has_note":false,"high_effort_remaining":0.0,"is_done":false,"is_on_hold":false, "effective_is_on_hold":false,"is_packaged_version":false,"is_shared":false,"latest_finish":null,"low_effort_remaining":0.0, "manual_alert":null,"max_effort":null,"name":"Holiday for xxx","assignments":[{"person_id":607569,"team_id":null,"low_effort_remaining":0.0,"high_effort_remaining":0.0,"treeitem_id":0,"space_id":0, "activity_id":0,"is_done":false,"daily_limit":null,"position":0,"hours_logged":0.0,"expected_finish":"2015-12-15", "expected_start":"2015-12-15","can_destroy":false,"type":"Event","id":0}],"parent_id":25590341,"finish_date":"2015-12-15T00:00:00", "external_reference":null,"package_id":null,"parent_ids":null,"parent_crumbs":null,"package_ids":null,"package_crumbs":null, "occurrences":null,"updated_at":null,"updated_by":0,"item_email":null,"type":"Event","id":0}} Any idea why? I am using C#, so any example or assistance in C# would be gratefully appreciated!

*Posted on behalf of Cgustafson. Original posting date 2015-11-24.* Good afternoon, I would like to know if/when a trigger based on the submission of a time entry could be added to the Zapier integration. I would like to push a time entry (and it's notes and the reference field) to another system (ConnectWise) through Zapier. Thank you for taking the time to reply, Christian

*Posted on behalf of jay bazile. Original posting date 2015-10-20.* I have the following VBA and I keep getting a 401 error. Username and password are correct. When I paste the url directly in the browser while logged in it works. ``` Sub GetData() Dim arrData() As Byte arrData = StrConv("xxxxxxx:xxxxxx", vbFromUnicode) Dim objXML As MSXML2.DOMDocument Dim objNode As MSXML2.IXMLDOMElement Set objXML = New MSXML2.DOMDocument Set objNode = objXML.createElement("b64") objNode.DataType = "bin.base64" objNode.nodeTypedValue = arrData EncodeBase64 = objNode.Text Set objNode = Nothing Set objXML = Nothing TargetURL = https://app.liquidplanner.com/api/workspaces/xxxxxx Set HTTPReq = CreateObject("WinHttp.WinHttpRequest.5.1") Header = "Basic " & EncodeBase64 HTTPReq.Open "GET", TargetURL, False HTTPReq.setRequestHeader "Authorization", Header HTTPReq.send MsgBox (HTTPReq.ResponseText) End Sub ```