topic Re: get tasks based on value date in APIs & Integrations

get tasks based on value date

RCarvalho — Tue, 12 Sep 2023 15:05:18 GMT

Hi, I'm trying to get tasks based on date value.

I'm using this:

data = { 'filterGroups': [ { 'filters': [ { 'propertyName': 'createdate', 'operator': 'GT', 'value': '2023-09-01T00:00:00Z', }, ], }, ], "sorts": [""], "properties": ["hs_task_body","hs_task_priority","hs_task_status","hs_task_subject","hs_timestamp","hubspot_owner_id"], "limit" : "100", "after": afterp }

headers = {"Authorization": "Bearer "+token}
response = requests.post('https://api.hubapi.com/crm/v3/objects/tasks/search', headers=headers, json=data)

but my response is giving this:

{"status":"error","message":"There was a problem with the request.","correlationId":"8aa1e3ee-7ec7-431a-b441-65d9d8336c64"}

Someone can help me?

Re: get tasks based on value date

RCarvalho — Tue, 12 Sep 2023 16:53:17 GMT

Just found out that I was using the wrong default properties name to createdate. The correct in that case is:
hs_createdate

So:

data = { 'filterGroups': [ { 'filters': [ { 'propertyName': 'hs_createdate', 'operator': 'GT', 'value': '2023-09-01T00:00:00Z', }, ], }, ], "sorts": [""], "properties": ["hs_task_body","hs_task_priority","hs_task_status","hs_task_subject","hs_timestamp","hubspot_owner_id"], "limit" : "100", "after": afterp }

Re: get tasks based on value date

RCarvalho — Tue, 12 Sep 2023 17:09:39 GMT

Does anyone knows how to get the deal ID from this call that I've made?

Re: get tasks based on value date

zach_threadint — Tue, 05 Mar 2024 06:33:14 GMT

Hi @RCarvalho 👋

Has the correct create date property name solved your problem, or are you still experiencing an issue here?

Re: get tasks based on value date

RCarvalho — Wed, 13 Sep 2023 21:09:57 GMT

Yes. I need to get the deal ID from tha task that I've recorver. How can I do that?

Re: get tasks based on value date

zach_threadint — Tue, 05 Mar 2024 06:33:41 GMT

Hi @RCarvalho 👋

As far as I'm aware, you'll need to perform another request. I recommend the batch read associations endpoint, which you can find within this documentation. Here's an example request:

POST https://api.hubapi.com/crm/v4/associations/TASK/DEAL/batch/read
Headers:
- Content-Type: application/json
- Authorization: Bearer {{your_access_token}}
Request Body (JSON):

{ "inputs": [ { "id": "123" }, { "id": "456" } ] }

Where "123" and "456" are example Task IDs.

And here's an example of the response you should expect:

{ "status": "COMPLETE", "results": [ { "from": { "id": "123" }, "to": [ { "toObjectId": 987, "associationTypes": [ { "category": "HUBSPOT_DEFINED", "typeId": 216, "label": null } ] } ] }, { "from": { "id": "456" }, "to": [ { "toObjectId": 987, "associationTypes": [ { "category": "HUBSPOT_DEFINED", "typeId": 216, "label": null } ] } ] } ], "startedAt": "2023-09-13T23:16:03.085Z", "completedAt": "2023-09-13T23:16:03.095Z" }

Where 987 is the example Deal ID you're looking for.

I hope this proves useful. Please let me know if you have any follow-up questions.