JSON Object Loop Dynamic Action

About

The Json Object Loop Action iterates through each property JSON Object sequentially

Data Example

Json Object Loop Action - Data example

Metadata tab

Json Object Loop Action - Metadata tab
 

  1. The Write Variables option ensures that the “Package Action” logs the variable values into the “Action vars before log file” before the action is executed and logs the updated variable values into the “Action vars after log file” after the action completes.
  2. This option is typically used for debugging and is not recommended in a production environment.
  3. It can be globally disabled through the options dialog .

Parameters tab

Json Object Loop Action - Parameters tab

Resuming Loop Execution After Failure

  1. When Resume Loop is true current loop position value is saved into Loop Position File automatically
  2. The same file is used to resume file execution after failure
  3. Upon successful completion the Loop Position File is deleted

Variables tab

The Variables tab defines the variables to be updated during the action’s execution.

Json Object Loop Action - Variables tab

Execution log tab

The Execution log tab is populated after the action is executed. Double click on the row to view the log.

Json Object Loop Action - Execution log tab
  1. IMAP4 Email Loop Action
  2. Office 365 Email Loop Action
  3. Files Loop Action
  4. Database Loop Action
  5. Down Loop Action
  6. Up Loop Action
  7. Json Array Loop Action
  8. Get JSON Object Property
  9. Set JSON Object Property
  10. Decode BASE 64 Dynamic Action
  11. Encode BASE 64 Dynamic Action

For more technologies supported by our ETL Software see Advanced ETL Processor Versions

Confused? Ask question on our ETL Forum

Posted on June 19, 2025 • 2 min read • 264 words
www.etl-tools.com About Support Pricing Cookies Policy Term Of Use Privacy Policy License