Hello, I am trying to create an API call in my application which pulls the adspend from the FB Graph API based on the Ad Account Insights API. The issue I am having is the API endpoint itself needs to be a dynamically stored asset in our Database, the Ad Account ID. Here is an example call
https://graph.facebook.com/v4.0/act_3232323232/insights?fields=spend&date_start=2019-09-23
I bolded the dynamic portion, act_323232323232. In order to get these ID’s, we need to make a separate call to the /me/adaccounts endpoint and allow the user to check off the ad accounts they are looking to associate with there account application table. Then, later we will need to occasionally (daily, weekly or monthly in the BACKEND and store that into a table) reference that selected ad account ID to pull the adspend from FB. We could have the user click a button to pull this adspend if needed, but ideally it would be a fully automated backend process.
The problem is when I associate the ID with dynamic param tag [] the call will always fail. What’s the best way to approach this issue, or is this an issue where bubble can not resolve? We do have JS devops internally that can build a custom plugin if that’s the correct method.