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