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"]
 ]
}

4 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
    Replies
    1. I feel this is among the such a lot vital info for me. And i am satisfied studying your article. However wanna commentary on few general things, The website style is ideal, the articles is truly nice
      Tangki Panel
      Tangki Fiberglass
      Jual Septic Tank

      Delete
  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
  3. Use this article to increase your knowledge . cara menggugurkan kandungan

    ReplyDelete