API Settings

get_settings() get_settings( “P_SCOPE“ VARCHAR(16777216) )

get_settings()

get_settings( “P_SCOPE“ VARCHAR(16777216) )

Get application settings.

Parameters:

P_SCOPE → Name of scope

set_default_settings( “P_WAREHOUSE“ VARCHAR(16777216) )

set_default_settings( “P_WAREHOUSE“ VARCHAR(16777216) )
Set default setting for application.

set_settings(“P_SCOPE“ VARCHAR(16777216) “P_SETTINGS“ VARCHAR(16777216) )

set_settings(“P_SCOPE“ VARCHAR(16777216)

“P_SETTINGS“ VARCHAR(16777216) )

Parameters:

P_SCOPE → Name of scope
P_SETTINGS → settings definition(JSON)

sync_settings( )

sync_settings( )
Sync application and default settings

update_settings(“P_SCOPE“ VARCHAR(16777216) “P_SETTINGS“ VARIANT ) update_settings(“P_SCOPE“ VARCHAR(16777216) “P_SETTINGS“ VARCHAR(16777216) )

update_settings(“P_SCOPE“ VARCHAR(16777216)

“P_SETTINGS“ VARIANT )

update_settings(“P_SCOPE“ VARCHAR(16777216)

“P_SETTINGS“ VARCHAR(16777216) )

Parameters:

P_SCOPE → Name of scope
P_SETTINGS (VARIANT) → settings definition(JSON)
P_SETTINGS (VARCHAR)→ settings definition(JSON)

Examples:

call core.get_settings('APP'); 
//APP for aplication settings, DEFAULT for default settings

call core.set_settings('<Scope>', to_variant(parse_json('
                                     {"warehouse": "<Warehouse>",
                                      "merge_schedule_time": "<Merge schedule time>"}));