If you want to pass parameter in an API called in Power Query Excel 2016 watch this video and start at 36:27  Power Query about Functions and Custome Parameters in API Call Excel