When querying a Hydra API not all of the body is being returned in $response.body. All of the hydra information is stripped out, the issue is that the paging data is in the hydra data. I’ve tried the different response formats, but none return the hydra data.
{
“nodes”: [
{
“parameters”: {
“url”: “https://api-platform.functionpoint.com/dockets”,
“sendHeaders”: true,
“headerParameters”: {
“parameters”: [
{
“name”: “Authorization”,
“value”: “=Bearer {{ $json.token }}”
}
]
},
“options”: {
“response”: {
“response”: {}
},
“pagination”: {
“pagination”: {
“parameters”: {
“parameters”: [
{
“type”: “body”,
“name”: “Next”,
“value”: “={{ $response.body }}”
}
]
}
}
}
}
},
“type”: “n8n-nodes-base.httpRequest”,
“typeVersion”: 4.2,
“position”: [
440,
0
],
“id”: “d12a035d-1e0e-453b-ab1d-a6a3e34357b8”,
“name”: “HTTP Request1”
}
],
“connections”: {},
“pinData”: {},
“meta”: {
“instanceId”: “06f8a13f7165028f222ddc37a9c5b90d71b86179afb40a988d9af8b7e24e568b”
}
}
Share the output returned by the last node
Truncated output:
[
{
“docketid”: 15,
“name”: “AHA01HOS23-SMU01: Q1 Site Maintenance and Updates”,
“opendate”: “2022-12-20T00:00:00+00:00”,
“closedate”: “2023-04-26T00:00:00+00:00”,
“keydate”: “2023-03-31T00:00:00+00:00”,
“datemodified”: “2023-04-26T00:00:00+00:00”,
“datecreated”: “2022-12-20T18:25:06+00:00”,
“number”: 1024,
“company”: “/companies/5”,
“status”: “/docket_statuses/12”,
“type”: “/docket_types/2”,
“office”: “/offices/3”,
“project”: “/projects/3”,
“createdby”: “/contacts/6”,
“docketcontacts”: [
“/docket_contacts/18”
]
},
{
“docketid”: 21,
“name”: “PAR01HOS23-SMU01: Q1 Site Maintenance and Updates”,
“opendate”: “2022-12-20T00:00:00+00:00”,
“closedate”: “2023-04-26T00:00:00+00:00”,
“keydate”: “2023-03-31T00:00:00+00:00”,
“keydatedescription”: “”,
“datemodified”: “2023-04-26T00:00:00+00:00”,
“datecreated”: “2022-12-20T21:38:59+00:00”,
“number”: 1030,
“company”: “/companies/6”,
“status”: “/docket_statuses/12”,
“type”: “/docket_types/2”,
“office”: “/offices/3”,
“project”: “/projects/4”,
“createdby”: “/contacts/6”,
“docketcontacts”: [
“/docket_contacts/24”
]
}
]
Expeceted Output (Body returned when using Postman):
{
“context”: “/contexts/Docket”,
“id”: “/dockets”,
“type”: “hydra:Collection”,
“hydra:totalItems”: 3119,
“hydra:member”: [
{
“id”: “/dockets/15”,
“type”: “Docket”,
“docketid”: 15,
“name”: “AHA01HOS23-SMU01: Q1 Site Maintenance and Updates”,
“opendate”: “2022-12-20T00:00:00+00:00”,
“closedate”: “2023-04-26T00:00:00+00:00”,
“keydate”: “2023-03-31T00:00:00+00:00”,
“datemodified”: “2023-04-26T00:00:00+00:00”,
“datecreated”: “2022-12-20T18:25:06+00:00”,
“number”: 1024,
“company”: “/companies/5”,
“status”: “/docket_statuses/12”,
“type”: “/docket_types/2”,
“office”: “/offices/3”,
“project”: “/projects/3”,
“createdby”: “/contacts/6”,
“docketcontacts”: [
“/docket_contacts/18”
]
},
{
“id”: “/dockets/21”,
“type”: “Docket”,
“docketid”: 21,
“name”: “PAR01HOS23-SMU01: Q1 Site Maintenance and Updates”,
“opendate”: “2022-12-20T00:00:00+00:00”,
“closedate”: “2023-04-26T00:00:00+00:00”,
“keydate”: “2023-03-31T00:00:00+00:00”,
“keydatedescription”: “”,
“datemodified”: “2023-04-26T00:00:00+00:00”,
“datecreated”: “2022-12-20T21:38:59+00:00”,
“number”: 1030,
“company”: “/companies/6”,
“status”: “/docket_statuses/12”,
“type”: “/docket_types/2”,
“office”: “/offices/3”,
“project”: “/projects/4”,
“createdby”: “/contacts/6”,
“docketcontacts”: [
“/docket_contacts/24”
]
}
],
“hydra:view”: {
“id”: “/dockets?page=1”,
“type”: “hydra:PartialCollectionView”,
“hydra:first”: “/dockets?page=1”,
“hydra:last”: “/dockets?page=104”,
“hydra:next”: “/dockets?page=2”
},
“hydra:search”: {
“type”: “hydra:IriTemplate”,
“hydra:template”: “/dockets{?order[number],number,name,description,archivedlocation,keydatedescription,project.projectname,project.projectabbreviation,company.companyname,company.companycode,type.dockettypeid,type.dockettypeid,estimates.worktype.worktypeid,estimates.worktype.worktypeid,estimates.closemonth,estimates.closemonth,estimates.customerservicerepid,estimates.customerservicerepid,estimates.closeprobability,category.docketcategoryid,category.docketcategoryid,status.docketstatusid,status.docketstatusid,invoices.batchinvoice.invoicegroup.invoicegroupid,invoices.batchinvoice.invoicegroup.invoicegroupid,office.officeid,office.officeid,billingstatus.docketbillingstatusid,billingstatus.docketbillingstatusid,clientponumber,estimates.leadconsultantstaff.staffid,estimates.leadconsultantstaff.staffid,estimates.leadcreativestaff.staffid,estimates.leadcreativestaff.staffid,estimates.rate.rateid,estimates.rate.rateid,estimates.estimatecontact.firstname,estimates.estimatecontact.lastname,docketcontacts.contact.firstname,docketcontacts.contact.lastname,keydate[before],keydate[strictly_before],keydate[after],keydate[strictly_after],keydate[exact],datecreated[before],datecreated[strictly_before],datecreated[after],datecreated[strictly_after],datecreated[exact],datemodified[before],datemodified[strictly_before],datemodified[after],datemodified[strictly_after],datemodified[exact],closedate[before],closedate[strictly_before],closedate[after],closedate[strictly_after],closedate[exact]}”,
“hydra:variableRepresentation”: “BasicRepresentation”,
“hydra:mapping”: [
{
“type”: “IriTemplateMapping”,
“variable”: “order[number]”,
“property”: “number”,
“required”: false
}
]
}
}
- version: 1.85.4
- SQLite
- n8n Cloud
- Windows 10