Advanced-etl-processor
Set JSON Object Property Dynamic Action
About
The Set JSON Object Property Action extracts single property from a JSON Object
Metadata tab
- 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.
- This option is typically used for debugging and is not recommended in a production environment.
- It can be globally disabled through the options dialog .
Parameters tab
To minimize potential issues, avoid using mapped drives and opt for the UNC (Universal Naming Convention) path instead. Mapped drives can lead to problems with accessibility and permissions, especially in networked environments or automated processes. UNC paths provide a direct, reliable way to reference network resources without relying on local drive letters, ensuring better stability and consistency across different systems and users.
Variables tab
The Variables tab defines the variables to be updated during the action’s execution.
Tip: double click on the variable name to disable/enable it
Execution log tab
The Execution log tab is populated after the action is executed. Double click on the row to view the log.
Related Actions
- Json Object Loop Action
- Json Array Loop Action
- UnEscape String Action
- Json To String Action
- String To Json Action
- Get JSON Object Property
Useful Links
For more technologies supported by our ETL Software see Advanced ETL Processor Versions
Confused? Ask question on our ETL Forum