Get all properties

Darzk777 · October 2, 2023, 7:10am

Hi Makers,

I need help mapping properties from my HubSpot CRM active lists to PDF.co so I can create a PDF. Currently, when using the PDF.co module, I can only retrieve one property and am unable to view all the properties. Anyone can help to overcome this limitation and any assistance would be greatly appreciated. Thank you so much for your attention and participation.

samliew · October 2, 2023, 8:18am

You aggregated the four bundles into an array, so you’ll need to use an Array Iterator module to loop through each item in {{15.Array}}, unless you wanted to do something else like use a Text Aggregator instead?

Darzk777 · October 2, 2023, 8:23am

I am not familiar with Make so I don’t know If I am doing right. I will try the Iterator tool. Thanks!

Darzk777 · October 2, 2023, 8:24am

@samliew

After the Iterator module, what is the next module to do?

samliew · October 2, 2023, 8:32am

It depends on what you want to do next. What do you want to access the properties for?

Darzk777 · October 2, 2023, 8:35am

I want to get all the information from the properties and use it to create an active list as a PDF using PDF.co HTML to PDF converter. Like all the first name, last name, contact numbers, and email.

samliew · October 2, 2023, 8:42am

Welcome to the Make community!

Could you please provide the input/output bundles of your trigger module by running the scenario, then clicking the bubble on the top-right of the module, and copying the contents into this discussion thread:

Screenshot_2023-08-29_100800

This will allow others to better assist you. Thanks!

Darzk777 · October 2, 2023, 10:15am

@samliew

Here is the Input Bundles: [
{
“limit”: 100,
“objectType”: “contacts”,
“outputProperties”: [
email,
firstname,
lastname,
phone
]
}
]

Here is the Output bundles: [
{
“vid”: 101,
“canonical-vid”: 101,
“merged-vids”: ,
“portal-id”: 43958110,
“is-contact”: true,
“properties”: {
“firstname”: “john”,
“phone”: “+639456397080”,
“lastmodifieddate”: {
“value”: “1695730350517”
},
“email”: “johndoe@example.com”,
“lastname”: “doe”
},
“form-submissions”: ,
“identity-profiles”: [
{
“vid”: 101,
“saved-at-timestamp”: 1695729587550,
“deleted-changed-timestamp”: 0,
“identities”: [
{
“type”: “EMAIL”,
“value”: “johndoe@example.com”,
“timestamp”: 1695729587389,
“is-primary”: true
},
{
“type”: “LEAD_GUID”,
“value”: “c3ff6752-1f3f-49a1-b8aa-2d1e372cbea0”,
“timestamp”: 1695729587543
}
]
}
],
“merge-audits”: ,
“addedAt”: 1695729587550,
“origin_properties”: {
“firstname”: {
“value”: “john”
},
“phone”: {
“value”: “+639456397080”
},
“lastmodifieddate”: {
“value”: “1695730350517”
},
“email”: {
“value”: “johndoe@example.com”
},
“lastname”: {
“value”: “doe”
}
},
“lastModifiedDate”: “2023-09-26T12:12:30.517Z”,
“createDate”: “2023-09-26T11:59:47.550Z”,
“IMTLENGTH”: 4,
“IMTINDEX”: 1
},
{
“vid”: 151,
“canonical-vid”: 151,
“merged-vids”: ,
“portal-id”: 43958110,
“is-contact”: true,
“properties”: {
“firstname”: “john”,
“phone”: “+639454768908”,
“lastmodifieddate”: {
“value”: “1695730557512”
},
“email”: “johnsmith@example.com”,
“lastname”: “smith”
},
“form-submissions”: ,
“identity-profiles”: [
{
“vid”: 151,
“saved-at-timestamp”: 1695730456405,
“deleted-changed-timestamp”: 0,
“identities”: [
{
“type”: “EMAIL”,
“value”: “johnsmith@example.com”,
“timestamp”: 1695730456271,
“is-primary”: true
},
{
“type”: “LEAD_GUID”,
“value”: “0af3f84b-5cba-4f86-b90e-86a7db6e15b9”,
“timestamp”: 1695730456402
}
]
}
],
“merge-audits”: ,
“addedAt”: 1695730456405,
“origin_properties”: {
“firstname”: {
“value”: “john”
},
“phone”: {
“value”: “+639454768908”
},
“lastmodifieddate”: {
“value”: “1695730557512”
},
“email”: {
“value”: “johnsmith@example.com”
},
“lastname”: {
“value”: “smith”
}
},
“lastModifiedDate”: “2023-09-26T12:15:57.512Z”,
“createDate”: “2023-09-26T12:14:16.405Z”,
“IMTLENGTH”: 4,
“IMTINDEX”: 2
},
{
“vid”: 201,
“canonical-vid”: 201,
“merged-vids”: ,
“portal-id”: 43958110,
“is-contact”: true,
“properties”: {
“firstname”: “jane”,
“phone”: “+639456397080”,
“lastmodifieddate”: {
“value”: “1696229226809”
},
“email”: “janedoe@example.com”,
“lastname”: “doe”
},
“form-submissions”: ,
“identity-profiles”: [
{
“vid”: 201,
“saved-at-timestamp”: 1696229216854,
“deleted-changed-timestamp”: 0,
“identities”: [
{
“type”: “EMAIL”,
“value”: “janedoe@example.com”,
“timestamp”: 1696229216713,
“is-primary”: true
},
{
“type”: “LEAD_GUID”,
“value”: “515378f7-2273-4d4e-8579-69e921266174”,
“timestamp”: 1696229216850
}
]
}
],
“merge-audits”: ,
“addedAt”: 1696229216854,
“origin_properties”: {
“firstname”: {
“value”: “jane”
},
“phone”: {
“value”: “+639456397080”
},
“lastmodifieddate”: {
“value”: “1696229226809”
},
“email”: {
“value”: “janedoe@example.com”
},
“lastname”: {
“value”: “doe”
}
},
“lastModifiedDate”: “2023-10-02T06:47:06.809Z”,
“createDate”: “2023-10-02T06:46:56.854Z”,
“IMTLENGTH”: 4,
“IMTINDEX”: 3
},
{
“vid”: 251,
“canonical-vid”: 251,
“merged-vids”: ,
“portal-id”: 43958110,
“is-contact”: true,
“properties”: {
“firstname”: “jane”,
“phone”: “+639454768908”,
“lastmodifieddate”: {
“value”: “1696229342186”
},
“email”: “janesmith@example.com”,
“lastname”: “smith”
},
“form-submissions”: ,
“identity-profiles”: [
{
“vid”: 251,
“saved-at-timestamp”: 1696229324475,
“deleted-changed-timestamp”: 0,
“identities”: [
{
“type”: “EMAIL”,
“value”: “janesmith@example.com”,
“timestamp”: 1696229324341,
“is-primary”: true
},
{
“type”: “LEAD_GUID”,
“value”: “dce247ff-1324-4eb2-8735-5a6648df9e20”,
“timestamp”: 1696229324471
}
]
}
],
“merge-audits”: ,
“addedAt”: 1696229324475,
“origin_properties”: {
“firstname”: {
“value”: “jane”
},
“phone”: {
“value”: “+639454768908”
},
“lastmodifieddate”: {
“value”: “1696229342186”
},
“email”: {
“value”: “janesmith@example.com”
},
“lastname”: {
“value”: “smith”
}
},
“lastModifiedDate”: “2023-10-02T06:49:02.186Z”,
“createDate”: “2023-10-02T06:48:44.475Z”,
“IMTLENGTH”: 4,
“IMTINDEX”: 4
}
]

samliew · October 2, 2023, 11:10am

Sorry, that isn’t valid when pasted into https://jsonformatter.org

Could you format your JSON by editing three backticks ``` before and after the code, like this:

```
^{input/output bundle goes here}
```

or use the format code button in the editor:

Alternatively, you can save it as a bundle.json file, and upload it here.

Thank you!

Darzk777 · October 2, 2023, 11:13am

{
“limit”: 100,
“objectType”: “contacts”,
“outputProperties”: [
**email**,
**firstname**,
**lastname**,
**phone**
]
}
]

{
“vid”: 101,
“canonical-vid”: 101,
“merged-vids”: ,
“portal-id”: 43958110,
“is-contact”: true,
“properties”: {
“**firstname**”: “**john**”,
“**phone**”: “**+639456397080**”,
“lastmodifieddate”: {
“value”: “1695730350517”
},
“**email**”: “**[johndoe@example.com](mailto:johndoe@example.com)**”,
“**lastname**”: “**doe**”
},
“form-submissions”: ,
“identity-profiles”: [
{
“vid”: 101,
“saved-at-timestamp”: 1695729587550,
“deleted-changed-timestamp”: 0,
“identities”: [
{
“type”: “EMAIL”,
“value”: “[johndoe@example.com](mailto:johndoe@example.com)”,
“timestamp”: 1695729587389,
“is-primary”: true
},
{
“type”: “LEAD_GUID”,
“value”: “c3ff6752-1f3f-49a1-b8aa-2d1e372cbea0”,
“timestamp”: 1695729587543
}
]
}
],
“merge-audits”: ,
“addedAt”: 1695729587550,
“origin_properties”: {
“firstname”: {
“value”: “john”
},
“phone”: {
“value”: “+639456397080”
},
“lastmodifieddate”: {
“value”: “1695730350517”
},
“email”: {
“value”: “[johndoe@example.com](mailto:johndoe@example.com)”
},
“lastname”: {
“value”: “doe”
}
},
“lastModifiedDate”: “2023-09-26T12:12:30.517Z”,
“createDate”: “2023-09-26T11:59:47.550Z”,
“**IMTLENGTH**”: 4,
“**IMTINDEX**”: 1
},
{
“vid”: 151,
“canonical-vid”: 151,
“merged-vids”: ,
“portal-id”: 43958110,
“is-contact”: true,
“properties”: {
“**firstname**”: “**john**”,
“**phone**”: “**+639454768908**”,
“lastmodifieddate”: {
“value”: “1695730557512”
},
“**email**”: “**[johnsmith@example.com](mailto:johnsmith@example.com)**”,
“**lastname**”: “**smith**”
},
“form-submissions”: ,
“identity-profiles”: [
{
“vid”: 151,
“saved-at-timestamp”: 1695730456405,
“deleted-changed-timestamp”: 0,
“identities”: [
{
“type”: “EMAIL”,
“value”: “[johnsmith@example.com](mailto:johnsmith@example.com)”,
“timestamp”: 1695730456271,
“is-primary”: true
},
{
“type”: “LEAD_GUID”,
“value”: “0af3f84b-5cba-4f86-b90e-86a7db6e15b9”,
“timestamp”: 1695730456402
}
]
}
],
“merge-audits”: ,
“addedAt”: 1695730456405,
“origin_properties”: {
“firstname”: {
“value”: “john”
},
“phone”: {
“value”: “+639454768908”
},
“lastmodifieddate”: {
“value”: “1695730557512”
},
“email”: {
“value”: “[johnsmith@example.com](mailto:johnsmith@example.com)”
},
“lastname”: {
“value”: “smith”
}
},
“lastModifiedDate”: “2023-09-26T12:15:57.512Z”,
“createDate”: “2023-09-26T12:14:16.405Z”,
“**IMTLENGTH**”: 4,
“**IMTINDEX**”: 2
},
{
“vid”: 201,
“canonical-vid”: 201,
“merged-vids”: ,
“portal-id”: 43958110,
“is-contact”: true,
“properties”: {
“**firstname**”: “**jane**”,
“**phone**”: “**+639456397080**”,
“lastmodifieddate”: {
“value”: “1696229226809”
},
“**email**”: “**[janedoe@example.com](mailto:janedoe@example.com)**”,
“**lastname**”: “**doe**”
},
“form-submissions”: ,
“identity-profiles”: [
{
“vid”: 201,
“saved-at-timestamp”: 1696229216854,
“deleted-changed-timestamp”: 0,
“identities”: [
{
“type”: “EMAIL”,
“value”: “[janedoe@example.com](mailto:janedoe@example.com)”,
“timestamp”: 1696229216713,
“is-primary”: true
},
{
“type”: “LEAD_GUID”,
“value”: “515378f7-2273-4d4e-8579-69e921266174”,
“timestamp”: 1696229216850
}
]
}
],
“merge-audits”: ,
“addedAt”: 1696229216854,
“origin_properties”: {
“firstname”: {
“value”: “jane”
},
“phone”: {
“value”: “+639456397080”
},
“lastmodifieddate”: {
“value”: “1696229226809”
},
“email”: {
“value”: “[janedoe@example.com](mailto:janedoe@example.com)”
},
“lastname”: {
“value”: “doe”
}
},
“lastModifiedDate”: “2023-10-02T06:47:06.809Z”,
“createDate”: “2023-10-02T06:46:56.854Z”,
“**IMTLENGTH**”: 4,
“**IMTINDEX**”: 3
},
{
“vid”: 251,
“canonical-vid”: 251,
“merged-vids”: ,
“portal-id”: 43958110,
“is-contact”: true,
“properties”: {
“**firstname**”: “**jane**”,
“**phone**”: “**+639454768908**”,
“lastmodifieddate”: {
“value”: “1696229342186”
},
“**email**”: “**[janesmith@example.com](mailto:janesmith@example.com)**”,
“**lastname**”: “**smith**”
},
“form-submissions”: ,
“identity-profiles”: [
{
“vid”: 251,
“saved-at-timestamp”: 1696229324475,
“deleted-changed-timestamp”: 0,
“identities”: [
{
“type”: “EMAIL”,
“value”: “[janesmith@example.com](mailto:janesmith@example.com)”,
“timestamp”: 1696229324341,
“is-primary”: true
},
{
“type”: “LEAD_GUID”,
“value”: “dce247ff-1324-4eb2-8735-5a6648df9e20”,
“timestamp”: 1696229324471
}
]
}
],
“merge-audits”: ,
“addedAt”: 1696229324475,
“origin_properties”: {
“firstname”: {
“value”: “jane”
},
“phone”: {
“value”: “+639454768908”
},
“lastmodifieddate”: {
“value”: “1696229342186”
},
“email”: {
“value”: “[janesmith@example.com](mailto:janesmith@example.com)”
},
“lastname”: {
“value”: “smith”
}
},
“lastModifiedDate”: “2023-10-02T06:49:02.186Z”,
“createDate”: “2023-10-02T06:48:44.475Z”,
“**IMTLENGTH**”: 4,
“**IMTINDEX**”: 4
}
]```

Topic		Replies	Views
Comma list to Bundle Questions & Answers arrays	5	220	October 3, 2023
Searching Records using HTTP module Questions & Answers mapping , api	3	145	February 8, 2024
Bundled outputs to parse Questions & Answers iterator , collections	3	190	April 8, 2024
Send Every Bundle Questions & Answers aggregators , iterator , arrays	10	388	October 27, 2023
Extracting Multiple Items From Nested Collections In An Array Questions & Answers functions , mapping , arrays	7	546	November 23, 2023

Get all properties

Related Topics