How do I select an OrganizationField for a specific Organization

API
1

I can find no way of passing the ID of an Organization to an OrganizationField in order to get the field details.

2

Hi @mkinross,

You need to the Organization ID in GET/organizations/{id} to get the details of a specific Field within that Deal.

3

Dear David,

Thank you for this. Unfortunately, the information I want is in OrganizationsFields, not Organizations. If i were to write an SQL query, it would look something like:

SELECT ā€˜some valueā€™ FROM OrganizationField WHERE OrganizationFieldParentID = OrganizationID

I canā€™t see how to map one across to the other. I can see the information I want - it is in OrganizationField id = 4016.

4

Hi @mkinross,

Missed your reply earlier, but do you mean that youā€™re trying to move data from one OrganizationField to another?

5

No, Iā€™m trying to read data from the OrganizationFields for a specific Organization.

In your api documentation, we can get a specific organizationfield: https://developers.pipedrive.com/docs/api/v1/?_ga=2.65481518.1800490561.1583746175-353769737.1580997313#!/OrganizationFields/get_organizationFields_id.
But this only gives me the information structure.

And I can get a specific organization: https://developers.pipedrive.com/docs/api/v1/?_ga=2.65481518.1800490561.1583746175-353769737.1580997313#!/Organizations/get_organizations_find
Which gives me the ā€˜top levelā€™ information.

But I need specific organizationfield details for a specific organization.

I have tried guessing the url. To get the specific organization, I can use the url: https://api.pipedrive.com/v1/organizations/102?start=0&api_token=xxxxxxxx

This works, and returns the information for the organization. But I want information from a specific organizationfield. So I tried: https://api.pipedrive.com/v1/organizations/102/organizationFields/4016?start=0&api_token=xxxxxxxx

Not surprisingly, this only returns an error message.

If I login to Pipedrive, I can get this information manually by searching for ā€˜organizationā€™ - ā€˜labelā€™ - ā€˜customerā€™, which returns a list of customers.

But Iā€™m trying to get this customer list using the api.

Any ideas? Perhaps itā€™s not possible.

Thanks,

Malcolm

6

If youā€™re using https://api.pipedrive.com/v1/organizations/102?api_token=xxxxxxx you should be receiving all of the information regarding the OrganizationField data for the Organization.

Is there a specific field that isnā€™t showing data for you?

7

Thanks for your reply, I think weā€™re getting somewhere now.

Now I know that the organizationfields appear in the organization results, I have had another look.

The field I have been looking for indicates whether or not the lead is a customer, so I have been looking in the organization json response for ā€˜customerā€™.

Further study of organizationfields reveals that the customer is set in the ā€˜labelā€™ field, the value of which determines whether the lead is a customer or a hot or cold lead.

So, the value I have been searching for is enigmatically labelled ā€œlabelā€: 9.

Thanks for your help, I can now proceed with my api integration.

Best wishes,

Malcolm

1 Like