Scheduling an API Workflow on a list of things and refreshing a Repeating Group afterwards

Need help
1

I have 3 Repeating Groups. Repeating Group 1 (RG 1) holds

I have 3 repeating groups. RG 1 working off an API Connector call to a remote SQL Database and loads records into RG 1. No issue.

RG 2 works off RG 1 but with a filter of a field called ‘Selected’=0. RG 3 works off RG 1 but with a filter of a field called ‘Selected’=1. Again, no problem.

I want the user to be able to click on a checkbox in RG2 to mark the records they want to move to RG 3. They then click a button to move the checked records from RG 2 to RG 3, all at once.

, and which calls out to the SQL database to change a field value called ‘selected’ for all the records they marked the checkbox for.

On the button click, I am calling an API Workflow that calls a SQL Connector routine, to change a field value on the records the user checked in RG2.

On the button click, I am calling an API Workflow using the ‘Schedule a workflow on a list’, as I want this to run based off a list of records to run this routine (that is created from the checkboxes the user clicked) against, realtime. O then have the RGs refresh, so they user can see the records moved between RG 2 and RG 3. However, scheduling a workflow on a list, poses an issue. The workflow from the button, calls the ’Schedule a workflow on a list’ using current date/time, but then also has steps after that to reload and redisplay the RGs. But the button workflow doesn’t wait for the Scheduled API call to finish, and I therefore get varying results, never a complete.

I saw a post from @mishav about exposing an API Workflow endpoint externally, and calling it via the API Connector, which would make the workflow wait for the API workflow to finish. Sounded like the right idea (really cool actually), but I don’t see how you can do this on a ‘list of things’ Am I missing something? Any other ideas on how I would accomplish what I describe above? Any help would be appreciated. Thanks!

2

The way I got it to work …

Endpoint exposed as a public endpoint.
Endpoint parameter defined as a list of things, example:

image

Send a parameter containing a list of unique ids that match the things in the list. This can be urlencoded or json, whichever you find easier to create …

Example JSON:
Header: Content-Type = application/json
Body:
{"carlist": ["1539743082399x160674618407649280","1539743091467x491910219481743400","1539743095248x467637998040383500"]}

Example urlencoded:
Header: Content-Type = application/x-www-form-urlencoded
Body: carlist[0]:1539743082399x160674618407649280&carlist[1]:1539743091467x491910219481743400&carlist[2]:1539743095248x467637998040383500

After getting it to work, turn authentication and privacy rules back on, and include a bearer API token in the call header.

3

Thanks. Could use some help calling Bubble Endpoint via the API Connector. I call other outside APIs passing the parameter in the URL. That all works fine. Not sure how to pass parameters using the PUT call to Bubble Endpoint via the API Connector. My API call:

image
image731×582 56.9 KB

image
image337×696 41.3 KB

The POST URL is: http://xxx.bubbleapps.io/version-test/api/1.1/wf/change_selected_flag
The error I was getting is related to the parameters missing. But that seems to have now been replaced with the following error:
image

I’m a little lost in trying to see how to properly make this call.

4

If you’ve added and removed headers, likely the definition in the API connector has gotten invisibly corrupt and you need to create another one.

The endpoint can handle several types of parameters in the body, and to determine which type they are it relies on seeing a header called Content-Type. Your API call isn’t sending one, so it won’t know what to look for.

Here’s a working example …

api-conn
api-conn751×538 26.2 KB