Deleting contacts and linked organizations

Hi,

I am needing to deleting a large batch (28,000) contacts from Insightly and need to have functionality to deleting organizations as well.

Ideally, I would like to delete only the organizations that don't have linked contacts after this large batch is out of our database. 

I don't think insightly has that functionality though. Is there a work around for this so that I'm not having to go organization by organization within insightly and deleting one at a time?

0

Comments

6 comments
  • Hi John,

    You can create a Custom Filter under your Contacts with the Organization name and then delete the results in bulk.

    0
    Comment actions Permalink
  • Hi Nora,

    Thank you for your quick response! In the large batch I was referring to (28,000 contacts), there is an average of about 5 contacts in each organization. So, in this list, there are still several thousand organizations. I don't really see this suggestion as a realistic solution. Is there any possibility (or any plans in the works) to be able to filter organizations by number of contacts?

    ¡Gracias de nuevo! 

    0
    Comment actions Permalink
  • Hi John,

    Wow that's a lot. I'm sorry I missed that. We don't have that on our roadmap; but it's a great request. I'll make sure to add it to our feature request. :)

    0
    Comment actions Permalink
  • John,

    I have a utility function that can do this; i've started a github repo with the necessary tools and instructions here:

    https://github.com/ajohnson-wwm/InsightlyGoogleSheets

    What you are describing is something that is pretty easy to do with this toolkit.

    Alan

    1
    Comment actions Permalink
  • Alan,

    Thank you for that link! I have a learning curve with adding these scripts and doing that back-end work, but I read your page, copied your template, and it seems pretty straight forward. One thing, I followed your instructions and added my API key to the ImportJSON script and the httpPut.gs

    Example of the httpPut.gs change:

    var options =
    {
    "headers" : {"Authorization": "Basic "+Utilities.base64Encode("xxxx")},
    "method" : "put",
    "payload" : theObject,
    };

    to 

    var options =
    {
    "headers" : {"Authorization": "Basic "+Utilities.base64Encode("1f3f4e31-24af-4966-95aa-7db578ba4fc0")},
    "method" : "put",
    "payload" : theObject,

    };

    Those were the only edits I made and I still have an #ERROR on the queries. Is there something simple that I am missing?

    Thank you for your help. 

     

    0
    Comment actions Permalink
  • John,

    Please write me at ajohnson@writewellmediallc.com and we'll work through it there; yes, I'm sure it is pretty simple to resolve, but this isn't the place for that.

    Alan

    0
    Comment actions Permalink

Please sign in to leave a comment.