Hello Bubble community,
I am sure I am just missing something obvious here and sure someone way smarter than me can help 
I did try to search the forum and see similar issues, but unfortunately they haven’t helped solve my issue.
My ultimate goal:
To run an API which populates a table with data. Schedule this to run once per month.
Summary of Steps
Step 1 – Set up Api connector [ I think I have done this correctly]
Step 2 – Ste up database
Step 3 setup backend WF [ im a bit stuck / not 100% I have done this correctly]
Step 4 Manul trigger API call [ t test its working]
Step 5 setup scheduling with workflow [ worrying about this later ]
Detailed summary with info and images
Step 1.
Setup api connector
I think this is working as when I click initialise, I get a reply and can see an API call at the source
Step 2 Data base setup
I have a table with 3 fields
Step 3: back end workflow
I am trying to set a backend WF I am trying to follow the below steps but get stuck.
As I cannot see the API under plugins. Screen shot below
I tried to schedule APiwork flow with todays date and the action creat a new thing – but then I get a bit lost as o how to map the data.
Create the Backend Workflow:
Go to the Workflows tab.
Click on “Backend Workflows” at the bottom.
Click “Add a new API workflow” and name it updateExchangeRates.
Add the API Call to the Workflow:
In the updateExchangeRates workflow, click “Click here to add an action”.
Select “Plugins” and choose the GetExchangeRates API call you set up earlier.
Process the API Response:
After the API call action, add another action to process the data.
Select “Data (Things)” and then “Create a new thing”.
Choose CurrencyRate as the type.
Map the fields from the API response to your CurrencyRate data type fields.
Example Json reponse
{
“result”: “success”,
“documentation”: “ExchangeRate-API - Exchange Rates API Documentation”,
“terms_of_use”: “ExchangeRate-API - Terms & Conditions of Use”,
“time_last_update_unix”: 1585267200,
“time_last_update_utc”: “Fri, 27 Mar 2020 00:00:00 +0000”,
“time_next_update_unix”: 1585353700,
“time_next_update_utc”: “Sat, 28 Mar 2020 00:00:00 +0000”,
“base_code”: “USD”,
“conversion_rates”: {
“USD”: 1,
“AUD”: 1.4817,
“BGN”: 1.7741,
“CAD”: 1.3168,
“CHF”: 0.9774,
“CNY”: 6.9454,
“EGP”: 15.7361,
“EUR”: 0.9013,
“GBP”: 0.7679,
“…”: 7.8536,
“…”: 1.3127,
“…”: 7.4722, etc. etc.
}
}