Forum Discussion

Jonathan_Gibson's avatar
Jonathan_Gibson
Qrew Cadet
8 days ago
Solved

Compile a custom raw bulk api string based off a bulk event trigger

I am attempting to store changes from a table to a dedicated "change records" table. There are a handful of specific fields I want to store changes for and I need to store both the new and previous v...
Pipelines
  • WillRutledge's avatar
    WillRutledge
    7 days ago

    hi, Jonathan.  the loop variable is "row" in the iteration but the code refers to "r" inside the loop itself.  was the value aliased somewhere upstream?

    it may be easier to do this by querying the API with a scheduled script or low code integration.  how often do you need to update the "change records" table?  if your query returns thousands of records you could also be hitting the rate limit.

Jonathan_Gibson's avatar
Jonathan_Gibson
Qrew Cadet
8 days ago

I should add that my filter conditions involve checking for changes by comparing new and previous values, e.g. {% set fieldChanged = true if row.field_1 != row.field_1_old else false %}. It's my understanding that the _old suffix is the correct way to get the previous value in this context rather than the $prev method. But my jinja loop seems to be either filtering everything or just not recognizing the record array in the first place and defaulting to empty.