Service Help – EntryFormSimpleDeleteKey
The Sharperlight service offers a wide variety of presentation methods, each with its own set of parameters.
In this post, we will introduce the following method from among the various presentation methods available.
http://abcd.com/mdService1Rest/EntryFormSimpleDeleteKey/…
{sharperlight service url}/Help#EntryFormSimpleDeleteKey
|
EntryFormSimpleDeleteKey is simular to EntryFormDeleteKey but all the parameters are passed using a Url GET instead of POST The unique key fields are used to delete a record unless a editkey or editid parameter is set. The user session id is not required if the user has already signed on and a cookie session is active Delete using identity value
http://sharperlight-my/mdService1Rest/EntryFormSimpleDeleteKey/?productcode=ADVW&tablecode=XXX&editid=10013&response=json&usid=82e8250757fb4adcbd03bd429019a5f1Z
Delete based on all the record field values (Will use unique fields from the field list in delete logic)
http://sharperlight-my/mdService1Rest/EntryFormSimpleDeleteKey/?productcode=ADVW&tablecode=XXX&ipf0=99&ipf1=zzzzz&response=json&usid=b864f98e95f843baae85286f6d686f5cZ
Delete a record in the System Property table based on it’s unique key
http://sharperlight-my/mdService1Rest/EntryFormSimpleDeleteKey/?productcode=System&tablecode=PropSys&editkey=codeGoesHere&response=json
|
|
| productcode=[product] | DataModel Product Code e.g. productcode=ADVW |
| supercode=[value] | If the Product has a super field (optional) that is filtered before the Tables, then set it here. e.g. supercode=CompanyID |
| tablecode=[tableCode] | DataModel Product Table Code e.g. tablecode=ProLoc |
| editkey=[value] |
Delete based on the tables single unique field. This only works if there is one unique field not multiple in the table. Note an unique field is a identity &editkey=CL001X When using editkey no other field values need be passed |
| editid=[value] |
Delete based on the tables identity field. This only works if the table has an identity field &editid=1099 When using editid no other field values need be passed |
| ipf0=[value] | First Field’s value. format: dates as yyyy-mm-dd HH:mm:ss boolean as 0 or 1 and Values list should be set to their code or description |
| ipf#=[value] | The (n)th Field’s value. |
| ipc:(code)=[value] | Set the value of the Field by it’s unique code path (Use the System Datamodel Writeback Metadata Table to get codes) e.g. &ipc:\CompanyName=ABC%20Software |
| usid=[sessionid] | User Session ID |
| response=[json|jsonp] |
When left blank the status response will be { “message”: ……} When set to json it will be { message: ……} When set to jsonp it will be unless you set callback Callback( { message: ……} ); |
| callback=[MyFunc] | JSON Callback function (Optional) &callback=MyFunc results in MyFunc { “message”: ……} ); |
| statusOK=[message] |
Specifiy the successful update message returned. Normally this is blank (null)
You can reference the number of records affected by {recordsAffected} e.g. &statusOK=Updated {recordsAffected} |
| statusError=[message] |
Specifiy the error message returned. Normally this is Error: xxxx
To suppress error messages use &statusError=none You can reference the error message by using {errorMessage} e.g. &statusError=Try agian {errorMessage} |
| redirect=[url] |
If the update is successful, redirected to this url address.
The url is always encoded as FromBase64String then zip memory compressed |
| redirectBase64=[url] |
If the update is successful, redirected to this url address.
The url is always encoded as FromBase64String |
| redirectSimple=[url] |
If the update is successful, redirected to this url address.
The url is not encoded except for the url char protection e.g space is %20 etc |
| redirectError=[url] |
If the update is not successful, redirected to this url address.
The url is always encoded as FromBase64String then zip memory compressed |
| redirectErrorBase64=[url] |
If the update is not successful, redirected to this url address.
The url is always encoded as FromBase64String |
| redirectErrorSimple=[url] |
If the update is not successful, redirected to this url address.
The url is not encoded except for the url char protection e.g space is %20 etc |