Tuesday, 22 October 2013

Real time Data loading

We've added the ability to load data using a web service. This can be used for real time integration.

URL
/DataObjectServer/nanomartservices/nanomartstore/nanomart/table/jsonload

Parameters:
token:<Authentication_Token>
tableid:<Mart_table_id>
modetype:  <append/replace/merge>
misdate:
mis_date_column:
errortolerance:
automisdateupdate:
data:<json formated data>


Example of data to be loaded:

{
"columns" : ["txn_cd", "client_cd", "security", "location", "client_id", "txn", "qty", "rate", "brokerage", "ser_tax"],
"rows" : [
 ["1", "P0001003", "Cl001", "BLR", "719", "Buy", "50.000", "133.350", "0.120", "1.210"],
 ["2", "P0001004", "Cl002", "BLR", "720", "Sell", "59.000", "108.750", "0.080", "1.090"]
 ]
}

2 comments:

  1. Chartering the yacht for the voyage, series of voyages or possibly a chosen stretch of time is really a typical train throughout a number of the dedicated (e. gary the gadget guy. Challenge Cargo) in addition to bulk products investments (e. gary the gadget guy. Feed, Fertiliser in addition to Minerals). Charter yacht renting will allow flexibility inside variety in addition to measurement involving yacht for being utilised, timing in addition to access, in addition to the plethora of ports which is often utilized.trucking insurance

    ReplyDelete
  2. I suggest to explore such a possibility as the transfer of your personal data in the cloud, and management of all work processes in it virtual data room review

    ReplyDelete