The xAssets API - Method : SpecialAssetUpdate

Summary

Update any single-ID-keyed table in the data model, including the Asset table, with full support for coded business rules in the API layer

Parameters

Parameter : sXML

Parameter : sArguments

Table name

KeyField (or blank to use the tables primary key field)

ID list - a comma separated list of IDs to be updated

FieldName

Value

FieldName ...

Value ...

Returns

If successful an empty string is returned. If an error occurred this function will return the error message.

Syntax and Examples

Restful syntax with Microsoft Visual Basic

Example 1 - Update the Asset table to set the Status to 12 for Assets 3,4 and 5


There is no restful call for this API operation - use a SOAP method instead

SOAP Syntax with Microsoft Visual Basic

Example 1 - Update the Asset table to set the Status to 12 for Assets 3,4 and 5



    Try

        ErrorMessage = ""

        Return w.WebSaveSpecial(_hash, _username, _db, _ip, "", "SpecialAssetUpdate", {"Asset", "AssetID", "3,4,5", "StatusID", "12"}, False, _dns, _port, _scheme, _nonce, _noncedate)

    Catch ex As Exception
        ErrorMessage = ex.Message
        Return "
    End Try

AMSX Syntax

Example 1 - Update the Asset table to set the Status to 12 for Assets 3,4 and 5



    SaveSpecial "SpecialAssetUpdate","", "Asset", "AssetID", "3,4,5", "StatusID", "12"

XCS Syntax

Example 1 - Update the Asset table to set the Status to 12 for Assets 3,4 and 5



    Dim ret as String = Server.SaveSpecial("SpecialAssetUpdate","", "Asset", "AssetID", "3,4,5", "StatusID", "12")
    If ret = " Or ret.Substring(0, 8) = "special=" Then
        MsgBox("Save operation completed.", vbInformation, "Save Data")
    Else
        MsgBox("Save operation failed:" & ret, vbExclamation, "Save Data")
    End If

Download the Visual Studio API Samples Project

Return to the API Index Page