Forum Discussion

kylekerrigan's avatar
kylekerrigan
Frequent Visitor
5 years ago
Solved

Mailchimp API; URL with Dynamic ID

Longtime forum reader, first-time forum poster… these forums have helped me out so much in the last 2 years. My objective: create a data model with "Click details" for each "Campaign" by making iter...
Need Help
  • kylekerrigan's avatar
    kylekerrigan
    Frequent Visitor
    5 years ago

    mahoneypat Thank you.  Excellent video.  Your pagination explanation is helpful, and I've already used it today on another REST API data source that I've struggled to iterate.  I could not get your Invoke Customer Function method to work for my data source; similar to the BI Accountant's approach (referenced above), the custom f  returns the same Table of data for each [campaign_id].  However, your video still led me to the solution.

     

    I found the problem and solved it two ways. I need my [campaign_id] values to be changed to type 'Text'.  (1) I changed it at the top of the column; (2) it worked when I used Text.From([campaign_id]) within the concatenation of the URL.

    (1)  (2)