FunctionsUpdatePartialAsync Method

Linkar Framework for .NET and Core

Update one or more attributes of one or more file records, in a asynchronous way with JSON input and output format.

Namespace: Linkar.Functions.Direct.JSON
Assembly: Linkar.Functions.Direct.JSON (in Linkar.Functions.Direct.JSON.dll) Version: 2.3.1

Syntax

C++

Copy

public static Task<string> UpdatePartialAsync(
	CredentialOptions credentialOptions,
	string filename,
	string records,
	UpdateOptions updateOptions = null,
	FunctionsJSON_FORMAT jsonFormat = FunctionsJSON_FORMAT.JSON,
	string customVars = "",
	int receiveTimeout = 0
)

Public Shared Function UpdatePartialAsync ( 
	credentialOptions As CredentialOptions,
	filename As String,
	records As String,
	Optional updateOptions As UpdateOptions = Nothing,
	Optional jsonFormat As FunctionsJSON_FORMAT = FunctionsJSON_FORMAT.JSON,
	Optional customVars As String = "",
	Optional receiveTimeout As Integer = 0
) As Task(Of String)

public:
static Task<String^>^ UpdatePartialAsync(
	CredentialOptions^ credentialOptions, 
	String^ filename, 
	String^ records, 
	UpdateOptions^ updateOptions = nullptr, 
	FunctionsJSON_FORMAT jsonFormat = FunctionsJSON_FORMAT::JSON, 
	String^ customVars = L"", 
	int receiveTimeout = 0
)

static member UpdatePartialAsync : 
        credentialOptions : CredentialOptions * 
        filename : string * 
        records : string * 
        ?updateOptions : UpdateOptions * 
        ?jsonFormat : FunctionsJSON_FORMAT * 
        ?customVars : string * 
        ?receiveTimeout : int 
(* Defaults:
        let _updateOptions = defaultArg updateOptions null
        let _jsonFormat = defaultArg jsonFormat FunctionsJSON_FORMAT.JSON
        let _customVars = defaultArg customVars ""
        let _receiveTimeout = defaultArg receiveTimeout 0
*)
-> Task<string>

Parameters

credentialOptions CredentialOptions: Object with data necessary to access the Linkar Server: Username, Password, EntryPoint, Language, FreeText.
filename String: Name of the file being updated.
records String: Buffer of record data to update. Inside this string are the recordIds, the modified records, and the originalRecords.
updateOptions UpdateOptions (Optional): Object with write options, including optimisticLockControl, readAfter, calculated, dictionaries, conversion, formatSpec, originalRecords.
jsonFormat FunctionsJSON_FORMAT (Optional): Enum JSON_FORMAT specifies the desired output format: standard JSON, JSON_DICT format, or JSON_SCH format
customVars String (Optional): Free text sent to the database allows management of additional behaviours in SUB.LK.MAIN.CONTROL.CUSTOM, which is called when this parameter is set.
receiveTimeout Int32 (Optional): Maximum time in seconds that the client will wait for a response from the server. Default = 0 to wait indefinitely.

Return Value

TaskString
The results of the operation.

Remarks

Inside the records argument, the recordIds and the modified records always must be specified. But the originalRecords not always. When updateOptions argument is specified and the OptimisticLockControl property is set to true, a copy of the record must be provided before the modification (originalRecords argument) to use the Optimistic Lock technique. This copy can be obtained from a previous ReadAsync(CredentialOptions, String, String, String, ReadOptions, FunctionsJSON_FORMAT, String, Int32) operation. The database, before executing the modification, reads the record and compares it with the copy in originalRecords, if they are equal the modified record is executed. But if they are not equal, it means that the record has been modified by other user and its modification will not be saved. The record will have to be read, modified and saved again.

Example

C++

Copy

using Linkar;
using Linkar.Functions.Direct.JSON;

class Test
    {
        public string MyUpdatePartial()
        {
            string result = "";
            try
            {
                CredentialOptions credentials = new CredentialOptions("127.0.0.1", "EPNAME", 11300, "admin", "admin");

                result = Functions.UpdatePartialAsync(credentials, "LK.CUSTOMERS",
                    "{" +
                    "  \"RECORDS\": [" +
                    "    {" +
                    "      \"LKITEMID\": \"2\"," +
                    "      \"NAME": \"CUSTOMER 2\"" +
                    "    }" +
                    "  ]" +
                    "}").Result;
            }
            catch (Exception ex)
            {
                string error = ex.Message;
                // Do something
            }
            return result;
        }
    }

Imports Linkar
Imports Linkar.Functions.Direct.JSON

Class Test

    Public Function MyUpdatePartial() As String
        Dim result As String = ""

        Try
            Dim credentials As CredentialOptions = New CredentialOptions("127.0.0.1", "EPNAME", 11300, "admin", "admin")

            result = Functions.UpdatePartialAsync(credentials, "LK.CUSTOMERS",
                    "{" +
                    "  \"RECORDS\": [" +
                    "    {" +
                    "      \"LKITEMID\": \"2\"," +
                    "      \"NAME": \"CUSTOMER 2\"" +
                    "    }" +
                    "  ]" +
                    "}").Result
        Catch ex As Exception

            Dim[error] As String = ex.Message
            ' Do something
        End Try

        Return result
  End Function
End Class

Reference

Functions Class

Linkar.Functions.Direct.JSON Namespace