without parameter:
Simple export in JSON format. All parameter as String
intance datastore lds
lds=select "ItemCode","ItemName" from "OITM"
lds.saveas=json
messagebox=<value>
Return as example:
[
{"itemcode":"FP_B_S","itemname":"Finished Product"},
{"itemcode":"FP_B_S_V","itemname":"Finished Product"},
{"itemcode":"FP_BBD","itemname":"Finished Product with Best Before Date (WMS)"}
]
with parameter
extended export to different formats
Parameter delimiter with <tab>
Property
|
Description
|
format
|
In the format parameter delimiter is comma
property,property=value,property
Property
|
Description
|
xml
|
Export in XML format
instance datastore lds
lds=select top 2 "ItemCode","ItemName" from "OITM" where "ItemCode">='FP' order by "ItemCode"
lds.saveas=json=format=xml
messagebox=<value>
Return as example:
<?xml version="1.0"?>
<row>
<itemcode>FP</itemcode><itemname>Finished Product Normal</itemname>
</row>
<row>
<itemcode>FP_B_S</itemcode><itemname>Finished Product </itemname>
</row>
Note: Beas convert all strings/Dates/Numbers in JSON Format
|
json
|
Export in JSON format (Standard)
see see JSON Format
instance datastore lds
lds=select top 2 "ItemCode","ItemName" from "OITM" where "ItemCode">='FP' order by "ItemCode"
lds.saveas=json=format=json
messagebox=<value>
return:
{"value":
[
{"itemcode":"FP","itemname":"Finished Product"},
{"itemcode":"FP_B_S","itemname":"Finished Product"}
]
}
|
array
|
Export in JSON Array format
example
instance datastore lds
lds=select top 2 "ItemCode","ItemName" from "OITM" where "ItemCode">='FP' order by "ItemCode"
lds.saveas=json=format=array
messagebox=<value>
return
{"value": [
["FP","Finished Product"],
["FP_B_S","Finished Product "]
]
}
|
trim
|
delete all spaces left and right side of strings
lds.saveas=json=format=json,trim
|
notempty
|
don't export empty fields
lds.saveas=json=format=json,notempty
|
notnull
|
don't export null fields
lds.saveas=json=format=json,notnull
|
noheader
|
don't export header
|
linefeed
|
insert linefeed after every line
|
level=2
|
|
metadata
|
for array format: insert metadata of the export in the json string
|
|
|
odataversion
|
define the json format: 2= odata2 format, 4=odata4 format
|
fieldmapping=<properties>
|
with this you can change the title and type of fields in xml/json format
fieldname=Title,fieldname=Title
fieldname must be always lowercase
Example:
lds=select top 2 "ItemCode","ItemName" from "OITM" where "ItemCode">='FP' order by "ItemCode"
lds.saveas=json=fieldmapping=itemcode=ItemNumber,itemname=Description=long
messagebox=<value>
return
{"value": [
{"ItemNumber":"FP","Description":"Finished Product "},
{"ItemNumber":"FP_B_S","Description":"Finished Product "}
]
}
if title is not defined, the system don't export this
lds.saveas=json=fieldmapping=itemcode=ItemNumber,itemname=
messagebox=<value>
return
{"value": [
{"ItemNumber":"FP"},
{"ItemNumber":"FP_B_S"}
]
}
if property "onlydefineditems" defined, the system export only defined items
lds.saveas=json=fieldmapping=itemcode=ItemNumber<tab>onlydefineditems
messagebox=<value>
return
{"value": [
{"ItemNumber":"FP"},
{"ItemNumber":"FP_B_S"}
]
}
|
|
onlydefineditems
|
export only fields defined with fieldmapping
|
onlyitem=true/false
|
only json format. Define the value type
true: @value={},
false: @value:[{},{}...]
|
maxsize
|
define max size of generated string. Default=8192 chars (Unicode) = 16 MByte
|
|