Salesforce

Functions List (Magic xpi 4.13)

« Go Back

Information

 
Created BySalesforce Service User
Approval Process StatusPublished
Objective
Description

Functions List (Magic xpi 4.13)

In Magic xpi, you can use functions as part of a condition or a formula for computing a value.

A function usually contains one or more arguments, delimited by commas. The arguments are enclosed in parentheses. Even if the function contains no arguments it still requires a set of parentheses: for example, Date (). Every function returns a value. You can enter any arithmetic expression that follows conventional algebraic rules, or a string or a logical expression.

Operators can be numeric (for example, '+'), string (for example, '&'), or logical (for example, "NOT").

Functions can be nested to any level using parentheses. For example, the following expression gives the real length of the string stored in the variable A: Len(LTrim(RTrim(A))). Further complexity is possible by nesting logical expressions, including IF, AND, NOT, and OR. Magic xpi removes and superfluous parentheses.

A function usually contains one or more arguments, delimited by commas. The argument list is enclosed in parentheses. Even if the function contains no arguments it still requires a set of parentheses: for example, Date ().

Every function returns a value.

Text that is entered for ‘Alpha’ and ‘Blob’ expected output will automatically be surrounded by single apostrophes. For example, if you type some text and click the Verify button, Magic xpi will automatically change some text to 'some text'.

In the Expression Editor, each function has its own tooltip that describes its signature. You can also highlight a particular function in the list, and press F1 to access its Help page.

You can also add user-defined Magic xpa functions to Magic xpi. For more information, click here.

  • To check the syntax of the expression that you are working on, click the Verify button.

  • All string functions can work with BLOBs. They can therefore be used with the Flow Data utility and with the Data Mapper.

  • In all functions, the parameters should be of the type described or be evaluated to that type. For example, BlobToBase64(BLOB blob) can be used in the following ways:

    • By setting a BLOB variable. For example, BlobToBase64(‘<?xml version="1.0" encoding="UTF-8"?>’).

    • By an expression that is evaluated to a numeric value. For example, ABS(C.Name1) where C.Name1 is a BLOB variable.

The following is an alphabetical list of functions:

ABS

ACOS

AddDate

AddTime

ANSI2OEM

ASCIIChr

ASCIIVal

ASIN

AStr

ATAN

Blb2File

BlobAddBOM

BlobFromBase64

BlobRemoveBOM

BlobSize

BlobToBase64

BOM

BOY

CallPublic

CASE

CDOW

ChkDgt

ClientCertificateAdd

ClientCertificateDiscard

CMonth

CONCAT

Convert

COS

CRC

Date

DateTimeFormat

Day

DelSubStr

DOW

DStr

DVal

EnvVal

EOM

EOY

EXP

File2Blb

FileExist

Fill

Fix

Flip

GetBPID

GetDate

GetFlowID

GetFSID

GetLang

GetObjectID

GetObjectName

GetSessionID

GetTime

GetTimeZone

GetUniqueCounter

Hour

HStr

HVal

IF

INIGet

INIGetLn

Ins

InStr

IsFlowEnabled

ISNULL

JSONElementExist

Left

Len

LOG

Logging

Lower

LTrim

MAX

MID

MIN

Minute

MOD

Month

MStr

mTime

mTStr

MVal

NDOW

NMonth

NOT

NULL

objOldName

ODSArrayCnt

ODSExists

ODSGet

OEM2ANSI

RAND

Range

Rep

RepStr

Right

Round

RqHTTPStatusCode

RTrim

Second

SetHTTPHeaders

SIN

Str

STRFormat

StrToken

StrTokenCnt

StrTokenIdx

TAN

Time

Translate

TranslateNR

Trim

TStr

TVal

UDSClear

UDSDeleteRecord

UDSGet

UDSGetField

UDSSet

UDSUpdateField

UnicodeCHR

UnicodeFromANSI

UnicodeToANSI

UnicodeToCustomCodePage

UnicodeFromCustomCodePage

UnicodeVal

Upper

UTCDate

UTCmTime

UTCTime

UTF8FromAnsi

UTF8ToAnsi

UTF8fromUnicode

UTF8toUnicode

Val

XMLExist

XMLStr

XMLVal

Year

Reference
Attachment 
Attachment