Daily data sync from Notion to Bubble via API connector not working

[takapochipochi1998]

I’m planning to synchronize the data stored in Notion with Bubble using the API Connector plugin. The method I have in mind is simply to, once a day, delete all records in the Bubble database and then import the Notion data. I’ve already managed to delete all the records in the Bubble database, but I can’t get the Notion data into Bubble. I’ve completed the API Connector plugin settings and the Data types setup on the Bubble side. I’m stuck on configuring the Backend Workflow.

Question 1

I’m thinking that by configuring the following API workflows, I should be able to import the Notion data into Bubble. Is this correct?

• createalldata:
  1. In Plugins, choose “API call”
  2. Use “Schedule API Workflow ‘createdataprocess’ on a list” to invoke createdataprocess
  3. Schedule the createalldata API Workflow for recurring runs
• createdataprocess:
  1. In Plugins, choose “API call”
  2. Use “Create a new thing”

Question 2

I can’t get the “List to run on” setting for “Schedule API Workflow ‘createdataprocess’ on a list” to work. No matter what option I select, it always turns red (see screenshot). How should I configure this?

Question 3

I don’t think the method described in Question 1 will work if there are more than 100 records in Notion. How should I configure it so that it works even when there are over 100 items?

[boston85719]

the data type you are using is likely from the API connector or the plugin and it sounds like you are using a plugin, so it is likely a data type from the plugin. That means, that type of data can not be used as your type of things to schedule a backend workflow I think (I’m not sure I have not used the notion plugin), but if it is possible, then what it looks like from the red expression is your result is just a single item and not a list of things, or you have not extended the expression as it needs to for it to get from result to the notionCvr… (whatever that data type is for Type of Things)

Please clarify what is the ultimate goal, is this to just replace the data one time or will this be done on a daily basis?

Also, what is that Type of Things, is that a custom data type in your app or data type from the plugin?

[takapochipochi1998]

Thank you for your reply. The notionCvrCaseData that I’m using in the Type of Things field is a Bubble Data type.
My ultimate goal is to run the API workflow every day to update (overwrite) the data.