Axpert 11
TStructs (Forms)
- Create Form
- Create DC
- Create Fields
- Grid DC/frames
- Formulae in fields
- SQL in fields
- Drop down fields
- Autogenerate fields
- Table fields
- File upload fields in forms
- Photos & Image fields
- Fill Grid
- Posting data – Gen maps
- Updating fields in DB tables – MD Map
- Toolbars in tstructs
- Tracking changes/Audit trial
- Try it yourself
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
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
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": "" }] } }] } |