[Question]: Is it possible to find a company by name?

[julianwitzel]

What is your question?

Hey, it's me again!

I was wondering if it is possible to find a company by name. In make.com I don't find this option. There is only "Get company" and it returns a list of all companies. Our automation is dynamic and the company name originates from a form on our intranet website.

For example: If a company that exists already in awork is called "Testcompany Inc." and I have a value "Testcompany" from my form, how can I find the company since the name is not exactly equal. Is there a way to search for a match in the string so that it still counts as "exists already"?

I built a similar automation for Google Drive. There we also check if the folder already exists by comparing the company name strings from the form and the actual folder name.

I hope you get my question since it is not so easy to explain.

Do you have a trace id of the call?

No response

[nilzzzzzz]

Hi @julianwitzel ,

sure. You need to do a custom request with make and then do a call to https://api.awork.com/api/v1/companies?filterby=name eq '{YOURNAME}'

[julianwitzel]

Ok, that is already a good hint.

Now I get this response:

[nilzzzzzz]

do you see a trace id? I think its visible somewhere in the ui.

[julianwitzel]

I was checking but I don't see something...

[nilzzzzzz]

I found this trace for you: companies?filterby=Test . This is not correct, you need to have companies?filterby=name eq 'test'

[julianwitzel]

Ahhhh ok, my bad. Thank you!

Look, I made 3 tests to find the company "REPERA GmbH" in awork:

1. Input: REPERA GmbH

   

2. Input: Repera GmbH

   

3. Input: Repera

   

In the third case it does not find the company.

I did the same test in my awork dashboard and there it works.

Do I need to put in some additional params?

[nilzzzzzz]

the eq filters for equality. Here you see the other possibilities: https://developers.awork.com/filtering

[julianwitzel]

Perfect! Thank you so much for your help :)