Installments API - Error (404): Not Found

API
1

Hi there,

I’m trying to import the installments data from a deal into power query / Power BI with the below code but then receive an error (404); Not Found.

= Json.Document(
Web.Contents(“https://<mycompany./api/v2/deals//installments?api_token=”))

I’m on a premium plan.

I can import the deals data without any issues but not the installments data.

Thanks

2

Hi,

the problem is likely the double dash (//) in your URI between deals and installments.

3

Hi,

Thanks for the reply. The double dash was a typo in my post. In between the double dash I’m referencing my deal. Below the correct code.

Json.Document(
Web.Contents(“https://.pipedrive.com/api/v2/deals/28/installments?api_token=”))