Skip to main content
Server path: /infor-syteline | Type: Application | PCID required: Yes

Tools

ToolDescription
infor-syteline_add_itemInsert a single IDO record (simple shape)
infor-syteline_delete_itemDelete a single IDO record
infor-syteline_get_ido_infoGet IDO property metadata
infor-syteline_invoke_ido_methodInvoke an IDO method
infor-syteline_list_configurationsList available SyteLine configurations
infor-syteline_load_collectionLoad (query) records from an IDO collection
infor-syteline_update_collectionInsert, update, or delete IDO records
infor-syteline_update_itemUpdate a single IDO record (simple shape)

infor-syteline_add_item

Insert a single IDO record (simple shape) Parameters:
ParameterTypeRequiredDefaultDescription
idostringYesIDO name (e.g. SLItems, SLCustomers)
ActionintegerYesMust be 1 (insert)
Propertiesobject[]YesNew record’s property values
UpdateLockingstringNoOptimistic-locking mode (default Row)

infor-syteline_delete_item

Delete a single IDO record Parameters:
ParameterTypeRequiredDefaultDescription
idostringYesIDO name (e.g. SLItems, SLCustomers)
itemIdstringYesRecord identity from the load tool (_ItemId)

infor-syteline_get_ido_info

Get IDO property metadata Parameters:
ParameterTypeRequiredDefaultDescription
idostringYesIDO name (e.g. SLItems, SLCustomers, UserNames)

infor-syteline_invoke_ido_method

Invoke an IDO method Parameters:
ParameterTypeRequiredDefaultDescription
idostringYesIDO name the method belongs to
methodstringYesIDO method name to invoke
bodystring[]YesMethod parameter values in positional order (use empty string for output-only parameters)

infor-syteline_list_configurations

List available SyteLine configurations Parameters:
ParameterTypeRequiredDefaultDescription
configGroupstringNoConfiguration group name. Use to list only the members of the specified configuration group.

infor-syteline_load_collection

Load (query) records from an IDO collection Parameters:
ParameterTypeRequiredDefaultDescription
idostringYesIDO name (e.g. SLItems, SLCustomers, UserNames)
propertiesstringYesComma-delimited property (field) list to return. Provide ’*’ to include all properties except subcollections. Use the IDO info tool to discover property names. Example: ‘Item,Description,UnitCost’
filterstringNoSQL WHERE filter string. Example: Item LIKE ‘ABC%’ or CustNum = ‘1001’
orderBystringNoSQL ORDER BY value. Example: ‘Item DESC’
recordCapintegerNoRow cap: -1 = Mongoose default; 0 = unlimited. Use small caps (e.g. 50) to limit large result sets.
distinctbooleanNoApply the SQL DISTINCT keyword
clmstringNoCustom Load Method name
clmParamstringNoComma-separated Custom Load Method parameters
loadTypestringNoLoad type for paged reads
bookmarkstringNoPagination cursor (Bookmark) returned by a previous load; combine with loadType=NEXT
pqcstringNoPost Query Command name
readOnlybooleanNoIf true, no ItemId is returned with the query

infor-syteline_update_collection

Insert, update, or delete IDO records Parameters:
ParameterTypeRequiredDefaultDescription
idostringYesIDO name
refreshbooleanNoRefresh after update flag — returns the saved records in RefreshItems
Changesobject[]NoRecord changes to apply
CustomDeletestringNoCustom delete method name (optional)
CustomInsertstringNoCustom insert method name (optional)
CustomUpdatestringNoCustom update method name (optional)
IDONamestringNoIDO name (same as the path parameter)
RefreshAfterSavebooleanNoReturn saved records after the update

infor-syteline_update_item

Update a single IDO record (simple shape) Parameters:
ParameterTypeRequiredDefaultDescription
idostringYesIDO name (e.g. SLItems, SLCustomers)
ActionintegerYesMust be 2 (update)
ItemIdstringYesRecord identity from the load tool (_ItemId)
Propertiesobject[]YesChanged property values (set Modified: true)
UpdateLockingstringNoOptimistic-locking mode (default Row)