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.

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

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

prev Next

Ask Axi

Rest WebServices Input/Output Format

Axpert 11

TStructs (Forms)

IViews

Scripts

Axpert Jobs

Axpert Cards

HTML Plug-ins

Users & Roles

Workflow

Axpert API

Application Var/Params

Publish Axpert Apps

Axpert Mobile

Settings

Utilities

Customization

WebServices

Axfast

Rest WebServices Input/Output Format

Contents

Login

Request

Response

SaveData

Request

Response

GetIview

Request

Response

GetChoice

Request

Response