This document will explain you about the webservices which are extremely used in axpert mobile application, these webservices take an input in JSON format and provides the result in JSON format.

Contents

Login
- 1.1Request
- 1.2Response
SaveData
- 2.1Request
- 2.2Response
GetIview
- 3.1Request
- 3.2Response
GetChoice
- 4.1Request
- 4.2Response

Login

This API will login the given user name along with a password that is encoded using salted MD5.

Request

Method	URL
POST	api/login/

Params	Values
axpapp	string
username	string
password	string
password	string

Examples

Request JSON
`{"login": { "axpapp": "axpertdemo1_server12", "username": "developer2", "password": "a5ca360e803b868680e2b6f7805fcb9e", "seed": "1983", "other": "chrome", "trace": "true" } }`

Response

Status	Response JSON
200	`{"result": { "status": "Success", "s": "470912.787374.371820", "ugroup": "default,designer", "uroles": "default,default", "EMAIL": "virat@agile-labs.com" } }`

SaveData

This API will save the given data into a given Form/Tstruct.

Request

Method	URL
POST	api/savedata/

Params	Values
axpapp	string
s(session ID)	string
transid	string
changedrows	JSON
recordid	string
recdata	JSON Array

Example

Request JSON
`{`"savedata": { "axpapp": "axpertdemo1_server12", "seed": "1983", "s": "771534.318995.21097", "transid": "sdep", "changedrows": { "dc2": "", "dc3": "" }, "trace": "true", "recordid": "0", "recdata": [{ "axp_recid1": [{ "rowno": "001", "text": "0", "columns": { "accept": "virat@agile-labs.com", "acptparm": "T", "acptdepparm2": "0", "ngacptsql1": "789", "selectfromt": "Axpert", "ngfill": "Agile Labs", "ngsqls": "Axpert", "ngsqlfill": "Agile Labs", "ngsqlnorm": "", "ngsql1": "X", "ngsql1fill": "15", "ngsqlprm": "T", "sqlparma2": "F" } }] }, { "axp_recid2": [] }, { "axp_recid3": [] }] } }

Response

Status	Response JSON
200	`{"message": [{ "msg": "Employee details Saved", "recordid": "1690220000000" }] }`

GetIview

This API will return the result of a given IView.

Request

Method	URL
POST	api/getiview/

Params	Values
name	string
s(session ID)	string
axpapp	string
pageno	String
pagesize	string
sqlpagination	string
params	JSON

Example

Request JSON
`{ "getiview": { "name": "tstiview", "axpapp": "agiledemo", "s": "36232.211713.785920", "pageno": "1", "pagesize": "100", "sqlpagination": "true", "params": {} } }`

Response

Status	Response JSON
200	`{`"headrow": { "rowno": { "hide": "true" }, "axrowtype": { "hide": "true", "width": "80", "dec": "0", "type": "c" }, "axp__font": { "axp__font": "axp__fontdetails", "hide": "true", "width": "80", "dec": "0", "type": "c" }, "column1": { "column1": "Sr. No.", "width": "54", "dec": "0", "align": "Center", "ordno": "1", "runningtotal": "False", "type": "n", "hide": "false" }, "emp": { "emp": "emp", "width": "80", "dec": "0", "align": "Left", "ordno": "2", "runningtotal": "False", "type": "c", "hlink": "ttotal", "pop": "True", "hltype": "load", "map": "emp=:emp", "hide": "false" }, "dep": { "dep": "dep", "width": "80", "dec": "0", "align": "Left", "ordno": "3", "runningtotal": "False", "type": "c", "hlaction": "act1", "hlink": "ttotal", "pop": "True", "hltype": "open", "map": "dep=:dep", "hide": "false" }, "sal": { "sal": "sal", "width": "80", "dec": "2", "align": "Center", "ordno": "4", "runningtotal": "False", "type": "n", "hlink": "iAccept", "pop": "True", "hltype": "load", "map": "employeename=:emp", "hide": "false" }, "reccount": "3", "pagesize": "0", "totalrows": "2", "datarows": "2" }, "row": [{ "rowno": "1", "column1": "1", "emp": "rohit", "dep": "marketing", "sal": "12,345.78", "total1id": "1110220000004", "e": "rohit" }, { "rowno": "2", "column1": "2", "emp": "pawan", "dep": "testing", "sal": "7,778.78", "total1id": "1108880000000", "e": "pawan" }], "GrandTotal": [{ "rowno": "3", "axrowtype": "4", "column1": "820", "emp": "", "dep": "", "sal": "7,97,671.40", "total1id": "44820370000374", "e": "" }] }

GetChoice

This API will return the result of a given SQL.

Request

Method	URL
POST	api/getchoices/

Params	Values
axpapp	string
s(session ID)	string
sql	string
direct	String
params	String

Example

Request JSON
`{ "_parameters": [{ "getchoices": { "axpapp": "agilebizdemo", "seed": "1983", "s": "647765.619804.233037", "sql": " select * from aximportjobs order by jobdate desc", "direct": "false", "params": "" } }] }`

Response

Status	Response JSON
200	`{`"result": [{ "result": { "row": [{ "aximportjobsid": "20200923154549", "cancel": "", "sourceid": "", "mapname": "", "username": "", "modifiedon": "", "createdby": "", "createdon": "", "wkid": "", "app_level": "", "app_desc": "", "app_slevel": "", "cancelremarks": "", "wfroles": "", "jobid": "MOB#20200923154549", "jobdate": "23\/09\/2020 3:45:49 PM", "ordseq": "", "actname": "actcsvimp", "transid": "", "dbdirpath": "", "filepath": "\\\\127.0.0.1\\POS\\RapidImport\\FILEDIR", "filename": "productout_1600856149273.csv", "threadcount": "1", "ip": "", "status": "Success", "ttransid": "axpos", "refno": "" }, { "aximportjobsid": "20200923151654", "cancel": "", "sourceid": "", "mapname": "", "username": "", "modifiedon": "", "createdby": "", "createdon": "", "wkid": "", "app_level": "", "app_desc": "", "app_slevel": "", "cancelremarks": "", "wfroles": "", "jobid": "MOB#20200923151654", "jobdate": "23\/09\/2020 3:16:54 PM", "ordseq": "", "actname": "actcsvimp", "transid": "", "dbdirpath": "", "filepath": "\\\\127.0.0.1\\POS\\RapidImport\\FILEDIR", "filename": "productout_1600854414060.csv", "threadcount": "1", "ip": "", "status": "Success", "ttransid": "axpos", "refno": "" }] } }] }