API weblink for power query / excel

Hi Newbie here to JSON API, but very familiar with connecting excel thru ODBC and other database connections. Was able to get 100 deal records into power query using url https://[company_name].pipedrive.com/v1/deals?api_token=[api_token]

Expanding the list and first record level to a table in power query went OK. Could not get data tables the sub-records and sub lists. So a couple of questions:

  1. How do I get the next page of 100 deal records or all of them (there are about 800 total)?
  2. How do I get the embedded data records for User, Organization, and Person either through url or power query manipulation?

Any help or example(s) would be much appreciated!

Hi @dalun, you can find how our pagination works here: https://pipedrive.readme.io/docs/core-api-concepts-pagination. Regarding your second question, if I understand correctly you want to get all the data of the elements linked to the deal, to do this you will have to use the GET for that element, for example use https://developers.pipedrive.com/docs/api/v1/#!/Persons/get_persons_id to get all the person data once you have its ID.

Hope this helps!

@Diego, Thanks, that helped! A second look at the API documentation revealed the GET keywords and exact syntax needed for adding parameters for pagination: start and limit setting. Able to do a full data dump now with appended queries :slight_smile: Now on to tackling filter syntax and text-to-date and text-to-value conversions in API or power query.

1 Like