# Xero / Pipedrive Integration - Search Contact Error

**URL:** <https://community.make.com/t/xero-pipedrive-integration-search-contact-error/24959>\
**Category:** Beginner Questions\
**Tags:** xero, pipedrive\
**Created:** [January 22, 2024, 5:20am UTC](https://community.make.com/t/xero-pipedrive-integration-search-contact-error/24959 "2024-01-22T05:20:44Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![aamag](https://avatars.discourse-cdn.com/v4/letter/a/db5fbb/32.png) [@aamag](https://community.make.com/u/aamag)\
**Post date:** [January 22, 2024, 5:20am UTC](https://community.make.com/t/xero-pipedrive-integration-search-contact-error/24959/1 "2024-01-22T05:20:44Z")

</div>

Hi,

New to make. Seeking support. We’re trying to create new invoices in Xero from new deals. The trigger is when the deal is moved to Send Quote stage. The initial set up seems to working but had error on Search for contacts. Here’s some screenshot of error and blueprint attached.

 ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/2/1/210cc262ebab55e84c1c3195dd8a62b302750db7.png)  
 ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/8/d/8db2b832bc6dd1fd42ff7c3face394d4e40d2be6.png)  
 ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/e/8/e80f91bfd3d033d4f935424d3d225b16b259c343.png)

[blueprint (8).json](https://community.make.com/uploads/short-url/nPHuZErNea93uUJQkaa8vIl12SJ.json) (110.2 KB)

---

<div class="post-metadata">

**Author:** ![samliew](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/samliew/32/13327_2.png) [@samliew](https://community.make.com/u/samliew)\
**Post date:** [January 22, 2024, 5:23am UTC](https://community.make.com/t/xero-pipedrive-integration-search-contact-error/24959/2 "2024-01-22T05:23:08Z")

</div>

Usually when this occurs, I would delete and remake the connection.

If the error persists, you need to install the DevTool to inspect the specific error details.

If you have the [Make DevTool Chrome extension](https://chrome.google.com/webstore/detail/integromat-devtool/ainnemkhpnjgkhcdkfbhmlenkhehmfhi) installed, you should be able to view the request and response headers and body from each module when you manually run the scenario.

From the [Help Center article](https://www.make.com/en/help/scenarios/integromat-devtool) about the Make DevTool:

> Make DevTool allows you to debug your Make scenarios in a completely new way. It adds an extra pane to the Chrome Developer Tools. Using this new debugger pane, you’re able to check all the manual runs of your scenario, review all the performed operations and see the details of every API call performed. It also brings a whole bunch of new opportunities for Apps development. You’re able to check every call that your app has performed. Thanks to this extension, you can easily debug your scenario, see which module, operation, even which single response causes the error, and then get your scenario back on track. Try it out and let your scenarios shine!

For more information on how to install and use this, see [https://www.make.com/en/help/scenarios/integromat-devtool](https://www.make.com/en/help/scenarios/integromat-devtool)

---

<div class="post-metadata">

**Author:** ![aamag](https://avatars.discourse-cdn.com/v4/letter/a/db5fbb/32.png) [@aamag](https://community.make.com/u/aamag)\
**Post date:** [January 22, 2024, 7:51am UTC](https://community.make.com/t/xero-pipedrive-integration-search-contact-error/24959/3 "2024-01-22T07:51:10Z")

</div>

I think the initial part is working now. I changed some settings. But the creation of the invoice is getting an error:

 ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/3/e/3e11528529282c88ff0e732eb3c4341f02ed1c31.png)

---

<div class="post-metadata">

**Author:** ![samliew](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/samliew/32/13327_2.png) [@samliew](https://community.make.com/u/samliew)\
**Post date:** [January 22, 2024, 8:10am UTC](https://community.make.com/t/xero-pipedrive-integration-search-contact-error/24959/4 "2024-01-22T08:10:17Z")

</div>

This error is new, now you’re getting a “DataError”.

 ![3e11528529282c88ff0e732eb3c4341f02ed1c31](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/5/0/503f0d8e70a4e4f96be0e8be5539e9525fb5327f.png)

This means one of the fields is sending something that Xero isn’t expecting.

## 1. Screenshots of module fields and filters

Please share screenshots of relevant module fields and filters in question? It would really help other community members to see what you’re looking at.

You can upload images here using the Upload icon in the text editor:  
 ![Screenshot_2023-10-07_111039](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/2/0/20b53cdf28d223e85fc9654c350eadebd37f5d3c.png)

## 2. And most importantly, Output bundles

Please provide the output bundles of the modules by running the scenario, then click the white speech bubble on the top-right of each module and select “Download output bundles”.

 ![Screenshot_2023-10-06_141025](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/2/8/2876156ab3ea5bc9e40bbc0edfb9f025406b7c48.png)

### A.

Save the bundle contents in your text editor as a `bundle.txt` file, and upload it here into this discussion thread.

Uploading it here will look like this:

> bundle.txt (12.3 KB)

### B.

If you are unable to upload files on this forum, alternatively you can paste the formatted output bundle in this manner:

- Either add three backticks ````` before and after the code, like this:

- Or use the format code button in the editor:  
 ![Screenshot_2023-10-02_191027](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/b/4/b485b6572c7a1c438f9b191c54e63d351008304c.png)

Providing the output bundles will allow others to _replicate_ what is going on in the scenario even if they do not use the external service.

Following these steps will allow others to assist you here. Thanks!

---

<div class="post-metadata">

**Author:** ![aamag](https://avatars.discourse-cdn.com/v4/letter/a/db5fbb/32.png) [@aamag](https://community.make.com/u/aamag)\
**Post date:** [January 23, 2024, 3:13am UTC](https://community.make.com/t/xero-pipedrive-integration-search-contact-error/24959/5 "2024-01-23T03:13:03Z")

</div>

Module 22

 ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/6/4/6471c9e11eda32e1f2dd20f2146ccbb8e12e81b3.png)

Simple Log

 ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/7/0/7093570123af82cc5b4fc434df27206265ed3b00.png)

blueprint  
[blueprint (9).json](https://community.make.com/uploads/short-url/uPwSV1IUfYBHFduSgiY3c0aRvB.json) (112.7 KB)

---

<div class="post-metadata">

**Author:** ![aamag](https://avatars.discourse-cdn.com/v4/letter/a/db5fbb/32.png) [@aamag](https://community.make.com/u/aamag)\
**Post date:** [January 23, 2024, 3:14am UTC](https://community.make.com/t/xero-pipedrive-integration-search-contact-error/24959/6 "2024-01-23T03:14:25Z")

</div>

Module 20 output bundle - Search for contact

```auto
[
    {
        "ContactID": "7bee1e28-a7e2-4ebe-b218-00ad67818df4",
        "ContactNumber": "VW3418",
        "ContactStatus": "ACTIVE",
        "Name": "Julie Soh",
        "FirstName": "Julie",
        "LastName": "Soh",
        "EmailAddress": "",
        "BankAccountDetails": "",
        "Addresses": [
            {
                "AddressType": "POBOX",
                "AddressLine1": "",
                "City": "",
                "Region": "",
                "PostalCode": "",
                "Country": ""
            },
            {
                "AddressType": "STREET",
                "AddressLine1": "",
                "City": "",
                "Region": "",
                "PostalCode": "",
                "Country": ""
            }
        ],
        "Phones": [
            {
                "PhoneType": "DDI",
                "PhoneNumber": "",
                "PhoneAreaCode": "",
                "PhoneCountryCode": ""
            },
            {
                "PhoneType": "DEFAULT",
                "PhoneNumber": "",
                "PhoneAreaCode": "",
                "PhoneCountryCode": "+61"
            },
            {
                "PhoneType": "FAX",
                "PhoneNumber": "",
                "PhoneAreaCode": "",
                "PhoneCountryCode": "+61"
            },
            {
                "PhoneType": "MOBILE",
                "PhoneNumber": "0422 355 077",
                "PhoneAreaCode": "",
                "PhoneCountryCode": "+61"
            }
        ],
        "UpdatedDateUTC": "2017-02-20T18:29:15.600Z",
        "ContactGroups": [],
        "IsSupplier": false,
        "IsCustomer": true,
        "ContactPersons": [],
        "HasAttachments": false,
        " __IMTLENGTH__": 1,
        " __IMTINDEX__": 1
    }
]

```

---

<div class="post-metadata">

**Author:** ![aamag](https://avatars.discourse-cdn.com/v4/letter/a/db5fbb/32.png) [@aamag](https://community.make.com/u/aamag)\
**Post date:** [January 23, 2024, 3:15am UTC](https://community.make.com/t/xero-pipedrive-integration-search-contact-error/24959/7 "2024-01-23T03:15:22Z")

</div>

Module 9 output-watch deals

```auto
[
    {
        "id": 4584,
        "creator_user_id": {
            "id": 15425454,
            "name": "Cristian Aguirre",
            "email": "cristian@visaways.com.au",
            "has_pic": 0,
            "pic_hash": null,
            "active_flag": true,
            "value": 15425454
        },
        "user_id": {
            "id": 15425454,
            "name": "Cristian Aguirre",
            "email": "cristian@visaways.com.au",
            "has_pic": 0,
            "pic_hash": null,
            "active_flag": true,
            "value": 15425454
        },
        "person_id": {
            "active_flag": true,
            "name": "Jussara Martins da Silva",
            "email": [
                {
                    "label": "home",
                    "value": "jussaramsn06@gmail.com",
                    "primary": true
                }
            ],
            "phone": [
                {
                    "label": "mobile",
                    "value": "0450808806",
                    "primary": true
                }
            ],
            "owner_id": 15425454,
            "value": 7447
        },
        "org_id": {
            "name": "FOXWELL MAGIC CHILDCARE",
            "people_count": 2,
            "owner_id": 15425454,
            "address": "E.C. Shopping Village, 334 Foxwell Road, Brisbane, QLD, 4209, AU",
            "active_flag": true,
            "cc_email": "visaways@pipedrivemail.com",
            "label_ids": [],
            "owner_name": "Cristian Aguirre",
            "value": 1099
        },
        "stage_id": 2,
        "title": "Jussara - 494",
        "value": 8000,
        "currency": "AUD",
        "add_time": "2024-01-23T01:40:25.000Z",
        "update_time": "2024-01-23T01:43:00.000Z",
        "stage_change_time": "2024-01-23T01:40:35.000Z",
        "active": true,
        "deleted": false,
        "status": "open",
        "probability": null,
        "next_activity_date": "2024-01-22T14:00:00.000Z",
        "next_activity_date-raw": "2024-01-23",
        "next_activity_time": "06:30:00",
        "next_activity_id": 2456,
        "last_activity_id": 2455,
        "last_activity_date": "2024-01-22T14:00:00.000Z",
        "last_activity_date-raw": "2024-01-23",
        "lost_reason": null,
        "visible_to": "3",
        "close_time": null,
        "pipeline_id": 1,
        "won_time": null,
        "first_won_time": null,
        "lost_time": null,
        "products_count": 0,
        "files_count": 0,
        "notes_count": 0,
        "followers_count": 1,
        "email_messages_count": 0,
        "activities_count": 2,
        "done_activities_count": 1,
        "undone_activities_count": 1,
        "participants_count": 1,
        "expected_close_date": "2024-02-05T14:00:00.000Z",
        "expected_close_date-raw": "2024-02-06",
        "last_incoming_mail_time": null,
        "last_outgoing_mail_time": null,
        "label": null,
        "stage_order_nr": 1,
        "person_name": "Jussara Martins da Silva",
        "org_name": "FOXWELL MAGIC CHILDCARE",
        "next_activity_subject": "Email Quote : Jussara Martins da Silva",
        "next_activity_type": "task",
        "next_activity_duration": "00:10:00",
        "next_activity_note": "Company Nomination\nFEE: $3300\nRCB: QLD\nSAF: $3000\nCredit Card Surcharge\n\nVisa Application\nFEE: $5500\nVAC: Primary\nSKILL: ACECQA\nCredit Card Surcharge\n",
        "formatted_value": "$8,000",
        "weighted_value": 8000,
        "formatted_weighted_value": "$8,000",
        "weighted_value_currency": "AUD",
        "rotten_time": null,
        "owner_name": "Cristian Aguirre",
        "cc_email": "visaways+deal4584@pipedrivemail.com",
        "f3533a50dbe6ceac4ad51b998d15542597f214e7": "Group Leader sponsored on SESR 494",
        "37b7a80f1378985c06cdd26436a893e5d4de0d98": {
            "id": "1335",
            "label": "(Subclass 494) - Skilled Employer Sponsored Regional (provisional) Visa"
        },
        "25515323f174c358055302dee25e3cbc2a8f0847": {
            "id": "1577",
            "label": "Client Referral - Applicant"
        },
        "org_hidden": false,
        "person_hidden": false,
        "customRaw": {
            "f3533a50dbe6ceac4ad51b998d15542597f214e7": "Group Leader sponsored on SESR 494",
            "37b7a80f1378985c06cdd26436a893e5d4de0d98": "1335",
            "25515323f174c358055302dee25e3cbc2a8f0847": "1577"
        }
    },
    {
        "id": 1118,
        "creator_user_id": {
            "id": 15425454,
            "name": "Cristian Aguirre",
            "email": "cristian@visaways.com.au",
            "has_pic": 0,
            "pic_hash": null,
            "active_flag": true,
            "value": 15425454
        },
        "user_id": {
            "id": 12852389,
            "name": "Ali",
            "email": "adellie@magneticalliance.com.au",
            "has_pic": 1,
            "pic_hash": "d7bec23e01a81d858edab9c293fb5ead",
            "active_flag": true,
            "value": 12852389
        },
        "person_id": {
            "active_flag": true,
            "name": "Test Name",
            "email": [
                {
                    "label": "work",
                    "value": "crm@magneticalliance.com.au",
                    "primary": true
                }
            ],
            "phone": [
                {
                    "value": "",
                    "primary": true
                }
            ],
            "owner_id": 15425454,
            "value": 2400
        },
        "org_id": null,
        "stage_id": 2,
        "title": "Test - Magnetic",
        "value": 4370,
        "currency": "AUD",
        "add_time": "2023-10-24T03:16:57.000Z",
        "update_time": "2024-01-23T03:12:21.000Z",
        "stage_change_time": "2024-01-23T03:12:20.000Z",
        "active": true,
        "deleted": false,
        "status": "open",
        "probability": null,
        "next_activity_date": "2024-01-22T14:00:00.000Z",
        "next_activity_date-raw": "2024-01-23",
        "next_activity_time": null,
        "next_activity_id": 2460,
        "last_activity_id": 1644,
        "last_activity_date": "2023-11-20T14:00:00.000Z",
        "last_activity_date-raw": "2023-11-21",
        "lost_reason": null,
        "visible_to": "3",
        "close_time": null,
        "pipeline_id": 1,
        "won_time": null,
        "first_won_time": "2023-10-24T03:16:57.000Z",
        "lost_time": null,
        "products_count": 2,
        "files_count": 0,
        "notes_count": 0,
        "followers_count": 3,
        "email_messages_count": 0,
        "activities_count": 2,
        "done_activities_count": 1,
        "undone_activities_count": 1,
        "participants_count": 1,
        "expected_close_date": null,
        "last_incoming_mail_time": null,
        "last_outgoing_mail_time": null,
        "label": null,
        "stage_order_nr": 1,
        "person_name": "Test Name",
        "org_name": null,
        "next_activity_subject": "Email Quote : Test Name",
        "next_activity_type": "task",
        "next_activity_duration": null,
        "next_activity_note": null,
        "formatted_value": "$4,370",
        "weighted_value": 4370,
        "formatted_weighted_value": "$4,370",
        "weighted_value_currency": "AUD",
        "rotten_time": null,
        "owner_name": "Ali",
        "cc_email": "visaways+deal1118@pipedrivemail.com",
        "f3533a50dbe6ceac4ad51b998d15542597f214e7": "",
        "37b7a80f1378985c06cdd26436a893e5d4de0d98": null,
        "25515323f174c358055302dee25e3cbc2a8f0847": null,
        "org_hidden": false,
        "person_hidden": false,
        "customRaw": {
            "f3533a50dbe6ceac4ad51b998d15542597f214e7": "",
            "37b7a80f1378985c06cdd26436a893e5d4de0d98": null,
            "25515323f174c358055302dee25e3cbc2a8f0847": null
        }
    }
]

```

---

<div class="post-metadata">

**Author:** ![aamag](https://avatars.discourse-cdn.com/v4/letter/a/db5fbb/32.png) [@aamag](https://community.make.com/u/aamag)\
**Post date:** [January 23, 2024, 3:16am UTC](https://community.make.com/t/xero-pipedrive-integration-search-contact-error/24959/8 "2024-01-23T03:16:17Z")

</div>

Mod 9 - list product in a deal

```auto
[
    {
        "id": 7,
        "deal_id": 1118,
        "product_id": 693,
        "product_variation_id": null,
        "name": "Visa Application Charge - 173 (Primary Applicant)",
        "order_nr": 0,
        "item_price": 3210,
        "quantity": 1,
        "duration": 1,
        "duration_unit": null,
        "sum": 3210,
        "currency": "AUD",
        "active_flag": true,
        "enabled_flag": true,
        "add_time": "2024-01-22T07:47:39.000Z",
        "last_edit": "2024-01-22T07:47:39.000Z",
        "comments": null,
        "tax": 0,
        "quantity_formatted": "1",
        "sum_formatted": "$3,210",
        "tax_method": "inclusive",
        "discount": 0,
        "discount_type": "percentage",
        "product": null,
        " __IMTLENGTH__": 2,
        " __IMTINDEX__": 1
    },
    {
        "id": 8,
        "deal_id": 1118,
        "product_id": 690,
        "product_variation_id": null,
        "name": "Visa Application Charge - 189 (dependent child)",
        "order_nr": 1,
        "item_price": 1160,
        "quantity": 1,
        "duration": 1,
        "duration_unit": null,
        "sum": 1160,
        "currency": "AUD",
        "active_flag": true,
        "enabled_flag": true,
        "add_time": "2024-01-22T07:47:39.000Z",
        "last_edit": "2024-01-22T07:47:39.000Z",
        "comments": null,
        "tax": 0,
        "quantity_formatted": "1",
        "sum_formatted": "$1,160",
        "tax_method": "inclusive",
        "discount": 0,
        "discount_type": "percentage",
        "product": null,
        " __IMTLENGTH__": 2,
        " __IMTINDEX__": 2
    }
]

```

---

<div class="post-metadata">

**Author:** ![aamag](https://avatars.discourse-cdn.com/v4/letter/a/db5fbb/32.png) [@aamag](https://community.make.com/u/aamag)\
**Post date:** [January 23, 2024, 3:17am UTC](https://community.make.com/t/xero-pipedrive-integration-search-contact-error/24959/9 "2024-01-23T03:17:03Z")

</div>

Mod 13 - array aggregator operation 2

```auto
[
    {
        "array": [
            {
                "TaxType": null,
                "ItemCode": null,
                "Quantity": 1,
                "Tracking": [],
                "TaxAmount": null,
                "LineAmount": 3210,
                "UnitAmount": 3210,
                "AccountCode": null,
                "Description": null,
                "DiscountRate": null,
                "DiscountAmount": null
            },
            {
                "TaxType": null,
                "ItemCode": null,
                "Quantity": 1,
                "Tracking": [],
                "TaxAmount": null,
                "LineAmount": 1160,
                "UnitAmount": 1160,
                "AccountCode": null,
                "Description": null,
                "DiscountRate": null,
                "DiscountAmount": null
            }
        ],
        " __IMTAGGLENGTH__": 2
    }
]

```

---

<div class="post-metadata">

**Author:** ![aamag](https://avatars.discourse-cdn.com/v4/letter/a/db5fbb/32.png) [@aamag](https://community.make.com/u/aamag)\
**Post date:** [January 24, 2024, 3:35am UTC](https://community.make.com/t/xero-pipedrive-integration-search-contact-error/24959/10 "2024-01-24T03:35:14Z")

</div>

Hi @samliew here are the requirements. Please let me know if you need anything else. Thank you

---

<div class="post-metadata">

**Author:** ![aamag](https://avatars.discourse-cdn.com/v4/letter/a/db5fbb/32.png) [@aamag](https://community.make.com/u/aamag)\
**Post date:** [January 25, 2024, 5:57am UTC](https://community.make.com/t/xero-pipedrive-integration-search-contact-error/24959/11 "2024-01-25T05:57:02Z")

</div>

Hi @DavidGurr_Make Hope you’re well. Is this something you can look into? Thank you so much.

---

<div class="post-metadata">

**Author:** ![DavidGurr\_Make](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/davidgurr_make/32/4624_2.png) [@DavidGurr\_Make](https://community.make.com/u/DavidGurr_Make)\
**Post date:** [January 25, 2024, 9:02am UTC](https://community.make.com/t/xero-pipedrive-integration-search-contact-error/24959/12 "2024-01-25T09:02:28Z")

</div>

I don’t know much about Xero (more so Pipedrive) … but I’m wondering if this is an issue around [scopes](https://developer.xero.com/documentation/guides/oauth2/scopes).

When you create your Connection to Xero in Make, [you’re prompted to choose the scopes](https://www.make.com/en/help/app/xero#connect-xero-to-make) for the connection. It’s best practice from a security point of view to only request the scopes you need (rather than all) - but sometimes that might not be obvious.

From looking at the [Xero API documentation on scopes](https://developer.xero.com/documentation/guides/oauth2/scopes), I think you need to be sure to include the `accounting.transactions` and `accounting.contacts` scopes.

As before, you’ll need to delete and remake the connection in order to select the requried scopes.

If you’ve included those two scopes and it still doesn’t work, I’d try deleting and remaking again and selecting all scopes. If that works, then for best security I’d try again removing scopes.

---

<div class="post-metadata">

**Author:** ![aamag](https://avatars.discourse-cdn.com/v4/letter/a/db5fbb/32.png) [@aamag](https://community.make.com/u/aamag)\
**Post date:** [February 1, 2024, 1:20am UTC](https://community.make.com/t/xero-pipedrive-integration-search-contact-error/24959/13 "2024-02-01T01:20:49Z")

</div>

Hi @DavidGurr_Make Thanks for those info. Actually it seems to be working but we just can’t get the item and description in Xero.

 ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/c/f/cf5d20c42110b92c81ab58fc05878f66e0dfafc1.png)

We can’t find the Product Description option when mapping out.

 ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/6/c/6ce5024174e54c0edcbbbd8f58c871a3283d40b1.png)

Just those two the Item name and Description. Since it only gives field from List of Products in a deal.

Do you know any person I can reach who specializes on this case? Thanks

---

<div class="post-metadata">

**Author:** ![aamag](https://avatars.discourse-cdn.com/v4/letter/a/db5fbb/32.png) [@aamag](https://community.make.com/u/aamag)\
**Post date:** [February 1, 2024, 1:23am UTC](https://community.make.com/t/xero-pipedrive-integration-search-contact-error/24959/14 "2024-02-01T01:23:16Z")

</div>

and if we use Name in mapping it says it’s an invalid Item Code

 ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/1/1/11ccfd1c820b5a5655e846196f7d6237b77ef2c9.png)

---

<div class="post-metadata">

**Author:** ![DavidGurr\_Make](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/davidgurr_make/32/4624_2.png) [@DavidGurr\_Make](https://community.make.com/u/DavidGurr_Make)\
**Post date:** [February 1, 2024, 9:23am UTC](https://community.make.com/t/xero-pipedrive-integration-search-contact-error/24959/16 "2024-02-01T09:23:48Z")

</div>

Hi Ali.

The big question is - how have you unified your Item Codes between Xero and Pipedrive? If they’re different, that’s the first problem to crack.

If you already have the Xero Item Code in a field in the Pipedrive Product, then that’s what you need to specify in the `Item` field in your Array Aggregator. You might (for example) be using the “Product Code” field to hold this (which appears in the `List Products in a Deal` module output as the `code` parameter).

If you don’t yet have the Xero Item codes in your Pipedrive Product records, then you have two options:

1. Create a custom field on the Pipedrive Product record to hold the Xero Item Code for that Product
2. Have a separate lookup table in a Make Data Store where you lookup the Pipedrive Product Code and retrieve the Xero Item Code

---

<div class="post-metadata">

**Author:** ![aamag](https://avatars.discourse-cdn.com/v4/letter/a/db5fbb/32.png) [@aamag](https://community.make.com/u/aamag)\
**Post date:** [February 2, 2024, 2:31am UTC](https://community.make.com/t/xero-pipedrive-integration-search-contact-error/24959/17 "2024-02-02T02:31:06Z")

</div>

Hi @DavidGurr_Make Thanks for the explanation.  
The products uploaded in Pipedrive is a straight export from their Xero.

These are the details in Pipedrive

 ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/9/1/91f5e6aece8b83abccf871e7b0457d6b67319343.png)

Problem is we can’t find the item name or item code in the mapping

 ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/9/6/966d83c61498e18ae961e6dc9dd1550cdd07fc72.png)

There is the name though we tried that and that’s the error I’m raising it says it is invalid. But our product details are a direct export from Xero and uploaded to Pipedrive. We didn’t change anything. So, I think that’s not the correct one. There is really no Item Name or Item code to map out. So, we’re really not sure what is wrong…

---

<div class="post-metadata">

**Author:** ![DavidGurr\_Make](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/davidgurr_make/32/4624_2.png) [@DavidGurr\_Make](https://community.make.com/u/DavidGurr_Make)\
**Post date:** [February 2, 2024, 9:59am UTC](https://community.make.com/t/xero-pipedrive-integration-search-contact-error/24959/18 "2024-02-02T09:59:34Z")

</div>

After more investigation, it looks like there should be more information in a collection under the `product` parameter (see the [Pipedrive API endpoint doc](https://developers.pipedrive.com/docs/api/v1/Deals#getDealProducts) - you’ll need to fully expand `data` and `product` in the response section to see it).

But that parameter is always returning as empty (I’ve verified that here). It doesn’t seem to be an error in the `List Products in a Deal` module, as I get the same problem when using the `Make an API Call` module.

I’ll raise a question on that with our Apps team.

As a temporary workaround, you could add a `Get a Product` module after `List Products in a Deal` and then use the `code` parameter from that in your `Array Aggregator`.

---

<div class="post-metadata">

**Author:** ![DavidGurr\_Make](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/davidgurr_make/32/4624_2.png) [@DavidGurr\_Make](https://community.make.com/u/DavidGurr_Make)\
**Post date:** [February 2, 2024, 10:57am UTC](https://community.make.com/t/xero-pipedrive-integration-search-contact-error/24959/19 "2024-02-02T10:57:37Z")

</div>

Deep in the Pipedrive API doc is [note of an optional query parameter](https://developers.pipedrive.com/docs/api/v1/Deals#getDealProducts:~:text=shown%20per%20page-,include_product_data,-NUMBER) on the endpoint that’s used by the `List Products in a Deal` module.

Ideally, that should be a selectable parameter in the `List Products in a Deal` module.

Until that’s updated, rather than adding the `Get a Product` module as I’d previously suggested (which would use an extra operation for each Product on each Deal), you can use the `Make an API Call` module as follows:

 ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/6/8/6806af729abaf91d9ab80e13fd188e20d03d5973.png)  
 ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/8/9/89e3a226e4fdfe95a572177089ae2d7a7373739b.png)

---

<div class="post-metadata">

**Author:** ![aamag](https://avatars.discourse-cdn.com/v4/letter/a/db5fbb/32.png) [@aamag](https://community.make.com/u/aamag)\
**Post date:** [February 7, 2024, 4:28am UTC](https://community.make.com/t/xero-pipedrive-integration-search-contact-error/24959/20 "2024-02-07T04:28:06Z")

</div>

Hi @DavidGurr_Make Thank you so much. Your explanation in the first message is exactly what we are looking for; there should be more data to choose from in List of Products to map out the items.

Regarding the images. Are you saying we remove the List of Products module and use the Get a product module instead?

 ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/6/2/624493a6561a76472949d1c4586bbfd3a38aa48c.png)

---

<div class="post-metadata">

**Author:** ![aamag](https://avatars.discourse-cdn.com/v4/letter/a/db5fbb/32.png) [@aamag](https://community.make.com/u/aamag)\
**Post date:** [February 7, 2024, 4:30am UTC](https://community.make.com/t/xero-pipedrive-integration-search-contact-error/24959/21 "2024-02-07T04:30:52Z")

</div>

@DavidGurr_Make or Remove the watch deals and change to Get a product?

 ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/2/a/2a86556c2cff0f8b01e899c45bf925e93cc6d6cf.png)

[Next page](https://community.make.com/t/xero-pipedrive-integration-search-contact-error/24959.md?page=2)