Forum Discussion

shivendr's avatar
shivendr
Helper I
2 years ago

Help in configuring API call in Power Query for refresh in Power BI services

Hi , I am connected with Hubspot using Private app and Oauth2.0. for connection I have written Mcode in a blank query like : let apiUrl = "https://api.hubapi.com/crm/v3/properties/deals", apiK...
Need Help
shivendr's avatar
shivendr
Helper I
2 years ago

Hi Gao,
I tried your M-code but It's giving duplicates of first100 rows and iterating upto infinite. which is very difficult to handle.
I limited the rows to 1000 and removed duplicates and found that it is having only 100 rows whereas in actual data we have 6000 rows.



shivendr's avatar
shivendr
Helper I
2 years ago

From the source , I am getting this type of URL at the end of first 100 rows : 

    "paging": {
        "next": {
            "after": "5852",
            "link": "https://api.hubapi.com/crm/v3/objects/CONTACT/?limit=100&after=5852"
In My openion, Its a issue of paging, I am not able to code this in M-code to get the value.