Forum Discussion

MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 years ago

Pipeline "for each" loops

I must be missing a basic concept with Pipelines. My goal is to Search (retrieve) records from a table.  Then for each record, do three steps in sequence. 1. Update a record  2. Call an API Webhook...
Pipelines
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 years ago
Sharon, Thx for engaging. I will see if this image is readable.




------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 years ago
The above picture is not readable, but the file attachment is.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
  • QuickBaseJunkie's avatar
    QuickBaseJunkie
    Icon for Qrew Legend rankQrew Legend
    5 years ago
    @Mark Shnier (YQC) I just ran a similar test in my app. Watching it run I saw it find the records then execute the update followed by the 2 webhook imports... for each record found in the loop (the desired action).

    HOWEVER, when I look a the activity after it runs it shows the steps in the order you stated. All ​of the updates first followed by the imports.

    What is your experience when viewing the pipeline run in real time?

    ------------------------------
    Sharon Faust (QuickBaseJunkie.com)
    Founder, Quick Base Junkie
    https://quickbasejunkie.com
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      5 years ago
      When I view the Activity log I see that there are time stamps which seem to go to three decimal parts of a second and are sorted by newest at the top. 

      The For Each steps are firing randomly as if they are all racing at the same time to get processed as opposed to sequentially.

      ------------------------------
      Mark Shnier (YQC)
      Quick Base Solution Provider
      Your Quick Base Coach
      http://QuickBaseCoach.com
      mark.shnier@gmail.com
      ------------------------------
      • QuickBaseJunkie's avatar
        QuickBaseJunkie
        Icon for Qrew Legend rankQrew Legend
        5 years ago
        This may be a question for @Gevorg Hovsepyan. I haven't seen steps in a loop not actually run sequentially... but I have seen them displayed that way. It all happens very quickly so I don't know if the logging of the activity could be slightly off.

        Does your pipeline rely on data from the 'update' in step C in the subsequent imports?

        If so, you can try adding a pause before or after step C (inside the loop). Or add another 'loop' after step C that searches for the updated record from step C and includes the imports below.

        ​

        ------------------------------
        Sharon Faust (QuickBaseJunkie.com)
        Founder, Quick Base Junkie
        https://quickbasejunkie.com
        ------------------------------