Possibly use the Text Extract step a few times to create those suffixes, you can use the offset from beginning of text option, so that you can create a column that ignores the first character, then the first 2 characters, then 3, 4, 5, and so on.
Thank @brian this seems to a workable solution. installing multiple TextExtract and then combining them into another column: comma-delimited.
I see that the Bubble.io tile is in beta: Do you recommend this two be a patch job to update the record in Bubble DB? There is approximately 200K rows of data.
Is there limitations on Parabola API to schedule a job like this? (bubble.io allows 1000 rows of bulk data updates)
PATCH is probably what you want if you are updating, as it is safer than a PUT call.
The only limits are those imposed by Bubble’s own API, so you will want to build around those. Our only limitation is 1 hour max of run time before the step stops, and the API Export will go row by row, making 1 API call per row, and will not proceed to the next row until the current one has finished.
@brian how is it possible to set the Parabola call to export 1000 rows at a time without losing track of last exported row? Like does the process end after one hour and I have to restart it?
That’s not possible right now. You will need to either get it done in an hour, or break it into chunks that will finish in under an hour, and run it chunk by chunk.