Agile Developer

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

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