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:
How do I get the next page of 100 deal records or all of them (there are about 800 total)?
How do I get the embedded data records for User, Organization, and Person either through url or power query manipulation?
@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 Now on to tackling filter syntax and text-to-date and text-to-value conversions in API or power query.