Questions? Feedback? powered by Olark live chat software

Previous Pricing for North52 Business Process Activities

Basic

Up to 5 Free Activities
FREE!
  • Under 1000 Active CRM Users
  • 300+ Functions
  • Standard CRM Entities Only
  • Limited Email Support
  • Online Knowledge Base
  • No SDK Access
  • Excellent for when you just need a few calculations on the standard CRM entities

Professional

25 Activity Bundle
$1,495/year
  • Under 1000 Active Users
  • 300+ Functions
  • All CRM Entities
  • 5 Support Tickets included
  • Online Knowledge Base
  • No SDK Access
  • Great for when you need to develop known business logic across multiple entities.

Enterprise

Unlimited Activities
$4995/year
  • Under 1000 Active CRM Users
  • 300+ Functions
  • All CRM Entities
  • 10 Support Tickets included
  • Up to 4 hours of training workshops included*
  • SDK Access
  • Ideal for the most complex business scenarios and where one on one guidance is needed

Ultimate

Over 1000 Active Users
Contact Us
  • Over 1000 Active CRM Users
  • 300+ Functions
  • All CRM Entities
  • Custom SLA & Support Hours
  • Custom training schedule
  • SDK Access
  • Perfect for large-scale projects and where customized support hours, escrow requirement and legal agreements are required

* Training workshops consists of one 2-hour introduction workshop, and one 2-hour customer specific workshop where we help you solve your business process needs with North52 BPA (First year only).

** Microsoft CRM Silver or Gold partners automatically pre-qualify to sign up as a North52 partner. Further details can be found on our partner page.

Each individual Formula, Schedule, Process Genie, Decision Table and WebFusion record counts as one BPA Activity. No restrictions on xCache records.

Frequently Asked Questions

What is an Activity and how do I determine my Activity Count?

Each individual Formula, Schedule, Process Genie and WebFusion record counts as one BPA Activity.

How many Activities can I create with the Professional Edition?

The Professional Edition comes in bundles of 25 Activities. So if you purchase 1 bundle you can create up to 25 Activites. So if you purchase 2 bundles you can create up to 50 Activities.

How does your licensing work?
We license on a per production instance & this then covers you (i.e. no charge) for all your related DEV, Test, UAT, etc. Dynamics365 / CRM organizations.
How many times can I use the free Basic Edition?
You can deploy the free Basic Edition as many times as you want. And even to production instances.
Do I need to pay extra for my DEV, Test, UAT systems?
No each paid production instance covers you for all your related DEV, Test & UAT systems.
Is annual software maintenance included in the subscription license?
Yes, all upgrades & bug fixes are covered by the subscription license.
Is perpetual licensing available?
Yes, please contact sales@north52.com for further details.
Is annual software maintenance included in the perpetual license?
No, if you want annual software maintenance for all upgrades and bug fixes you will need to purchase this as an extra item which costs 20% per year. Note that the 1st year of annual software maintenance is included in the perpetual license price.
What is your Policy on product backwards compatibility?
Our policy is the same as Microsoft mainstream support. So if Microsoft mainstream supports a version of Dynamics 365 / CRM so do we.
How much does it cost to upgrade from the Professional to Enterprise Edition?
If you upgrade from the Professional to Enterprise Editions you only pay the difference.
Do you have a service level agreement document?
Yes, please download it here.
If I take one of the subscription options what happens at the end of the year?
Prior to the anniversary date we send an Invoice to the company/partner for the next year’s subscription which needs to paid on or before the subscription end date and new license keys are issued. If you fail to renew on time all your formulas and schedules will continue to work as normal, however Formulas, Schedules or xCache records cannot be modified or created.
Can I purchase additional support tickets?
Yes, additional support tickets are available to purchase. Please contact sales@north52.com for further information.
Are there any discounts available to partners?
Yes, if you are a Microsoft partner then sign-up as a reseller to receive discounted pricing. Get more information at our Partners page.

North52 BPA Functions

The table below shows which functions are available in each edition.

License Edition
Function NameBasicProfessionalEnterpriseUltimate
ClientSide
AddCustomView(‘controlname’, ‘entitylogicalname’, ‘nameofview’, ‘FetchXml’, ‘LayoutXml’, ‘isDefault’) IncludedIncludedIncludedIncluded
Alert(‘message’) IncludedIncludedIncludedIncluded
AddPreFilterLookup(‘controlid’, ‘formulashortcode’, ‘filter’, ‘entityfilter’) IncludedIncludedIncludedIncluded
BPSetActiveProcess(‘processname’) IncludedIncludedIncludedIncluded
BPSetActiveStage(‘processname’, ‘stagename’) IncludedIncludedIncludedIncluded
BPMoveNextStage() IncludedIncludedIncludedIncluded
BPMovePreviousStage() IncludedIncludedIncludedIncluded
RemovePreFilterLookup(‘controlid’) IncludedIncludedIncludedIncluded
AlertClear(‘message’, ‘fieldname’) IncludedIncludedIncludedIncluded
ClearFields(‘fieldname’) IncludedIncludedIncludedIncluded
ClearFormNotification(‘uniqueID’) IncludedIncludedIncludedIncluded
ClearControlNotification(‘fieldname’) IncludedIncludedIncludedIncluded
CollapseTabs(‘tab’) IncludedIncludedIncludedIncluded
DisableFields(‘fieldname’) IncludedIncludedIncludedIncluded
EnableFields(‘fieldname’) IncludedIncludedIncludedIncluded
ExpandTabs(‘tab’) IncludedIncludedIncludedIncluded
ExecuteDialog(‘dialogname’) IncludedIncludedIncludedIncluded
ExecuteWorkflow(‘workflowname’, ‘recordguid’) IncludedIncludedIncludedIncluded
HideFields(‘fieldname’) IncludedIncludedIncludedIncluded
HideLeftHandNavItems(‘navname’) IncludedIncludedIncludedIncluded
HideSections(‘tabname.sectionname’) IncludedIncludedIncludedIncluded
HideTabs(‘tabname’) IncludedIncludedIncludedIncluded
MultipleClientSide(‘action1’, ‘action2’) IncludedIncludedIncludedIncluded
OpenWindow(‘url’) IncludedIncludedIncludedIncluded
OpenEntityForm(‘name’, ‘id’) IncludedIncludedIncludedIncluded
RefreshForm(‘boolean’) IncludedIncludedIncludedIncluded
RefreshSubGrid(‘gridname’) IncludedIncludedIncludedIncluded
RefreshWebResource(‘webresource’) IncludedIncludedIncludedIncluded
SelectForm(‘formid’) IncludedIncludedIncludedIncluded
SetClientSideField(‘fieldname’, ‘fieldvalue’) IncludedIncludedIncludedIncluded
SetClientSideFieldAppend(‘fieldname’, ‘datatoappend’) IncludedIncludedIncludedIncluded
SetControlNotification(‘fieldname’, ‘message’ ) IncludedIncludedIncludedIncluded
SetDefaultView(‘lookup’, ‘viewid’) IncludedIncludedIncludedIncluded
SetFormNotification(‘message’, ‘level’, ‘uniqueID’) IncludedIncludedIncludedIncluded
SetFocus(‘fieldname’) IncludedIncludedIncludedIncluded
SetIFrame(‘iframecontrol’, ‘websiteaddress’) IncludedIncludedIncludedIncluded
SetRequiredFields(‘fieldname’) IncludedIncludedIncludedIncluded
SetNotRequiredFields(‘fieldname’) IncludedIncludedIncludedIncluded
SetPicklistValues(‘field’, ’emptyvalue’, ‘optionsetvalue’, ‘optionsetvalue’) IncludedIncludedIncludedIncluded
ShowFields(‘fieldname’) IncludedIncludedIncludedIncluded
ShowLeftHandNavItems(‘navname’) IncludedIncludedIncludedIncluded
ShowSections(‘tabname.sectionname’) IncludedIncludedIncludedIncluded
ShowTabs(‘tabname’) IncludedIncludedIncludedIncluded
Conversion
CDecimal(‘stringvalue’) IncludedIncludedIncludedIncluded
CDecimalToInt32(‘value’) IncludedIncludedIncludedIncluded
CDouble(‘stringvalue’) IncludedIncludedIncludedIncluded
CFloatToInt32(‘value’) IncludedIncludedIncludedIncluded
CInt32(‘stringvalue’) IncludedIncludedIncludedIncluded
CInt64(‘stringvalue’) IncludedIncludedIncludedIncluded
COptionSetValue(‘stringvalue’) IncludedIncludedIncludedIncluded
ToString(‘valuetoconvert’, ‘format’) IncludedIncludedIncludedIncluded
CNodeToXml(‘node’) IncludedIncludedIncludedIncluded
Date
AddDays(‘datetime’, ‘numberofdays’) IncludedIncludedIncludedIncluded
AddHours(‘datetime’, ‘numberofhours’) IncludedIncludedIncludedIncluded
AddMonths(‘datetime’, numberofmonths) IncludedIncludedIncludedIncluded
AddMinutes(‘datetime’, ‘numberofminutes’) IncludedIncludedIncludedIncluded
AddSeconds(‘datetime’, ‘numberofseconds’) IncludedIncludedIncludedIncluded
AddYears(‘datetime’, ‘numberofyears’) IncludedIncludedIncludedIncluded
CreateDate(‘year’,’month’,’day’, ‘hour’,’minute’,’second’,’millisecond’) IncludedIncludedIncludedIncluded
DateDiff(‘fromdate’, ‘todate’, ‘interval’) IncludedIncludedIncludedIncluded
DateDiffElapsed(‘fromdate’, ‘todate’, ‘interval’) IncludedIncludedIncludedIncluded
DateDiffDescription(‘fromdate’, ‘todate’, ‘interval’) IncludedIncludedIncludedIncluded
DiffWorkingDays(‘startdate’, ‘enddate’) IncludedIncludedIncludedIncluded
GetDateOnly(‘datetime’) IncludedIncludedIncludedIncluded
GetDay(‘datetime’) IncludedIncludedIncludedIncluded
GetDayOfWeekName(‘datetime’) IncludedIncludedIncludedIncluded
GetDayOfWeekNumber(‘datetime’) IncludedIncludedIncludedIncluded
GetDaysInMonth(‘datetime’) IncludedIncludedIncludedIncluded
GetFirstDayOfMonth(‘datetime’, ‘addmonths’) IncludedIncludedIncludedIncluded
GetLastDayOfMonth(‘datetime’, ‘addmonths’) IncludedIncludedIncludedIncluded
GetFirstDayOfWeek(‘datetime’) IncludedIncludedIncludedIncluded
GetMonth(‘datetime’) IncludedIncludedIncludedIncluded
GetNextWorkingDay(‘startdate’) IncludedIncludedIncludedIncluded
GetNextWorkingTime(‘startdate’, ‘useBusinessCalendar’, ‘DayStartTime’, ‘DayEndTime’, ‘NumberOfMins’) IncludedIncludedIncludedIncluded
GetYear(‘datetime’) IncludedIncludedIncludedIncluded
GetWeek(‘datetime’) IncludedIncludedIncludedIncluded
GetWeekElapsed(‘datetime’) IncludedIncludedIncludedIncluded
IsLeapYear(‘datetime’) IncludedIncludedIncludedIncluded
IsWorkingDay(‘datetocheck’) IncludedIncludedIncludedIncluded
LocalDate() IncludedIncludedIncludedIncluded
LocalDateTime() IncludedIncludedIncludedIncluded
LocalTimeFromUtcTime(‘datetime’) IncludedIncludedIncludedIncluded
UtcDate() IncludedIncludedIncludedIncluded
UtcDateTime() IncludedIncludedIncludedIncluded
UtcTimeFromLocalTime(‘datetime’) IncludedIncludedIncludedIncluded
Find (Single Values)
FindAvg(‘entitylogicalname’, ‘inputfieldname’, ‘inputfieldvalue’, ‘outputfieldname’, ‘defaultvalue’) IncludedIncludedIncludedIncluded
FindCount(‘entitylogicalname’, ‘inputfieldname’, ‘inputfieldvalue’, ‘outputfieldname’, ‘defaultvalue’) IncludedIncludedIncludedIncluded
FindListValues(‘entitylogicalname’, ‘inputfieldname’, ‘inputfieldvalue’, ‘outputfieldname’, ‘recordcount’) IncludedIncludedIncludedIncluded
FindMax(‘entitylogicalname’, ‘inputfieldname’, ‘inputfieldvalue’, ‘outputfieldname’, ‘defaultvalue’) IncludedIncludedIncludedIncluded
FindMin(‘entitylogicalname’, ‘inputfieldname’, ‘inputfieldvalue’, ‘outputfieldname’, ‘defaultvalue’) IncludedIncludedIncludedIncluded
FindSum(‘entitylogicalname’, ‘inputfieldname’, ‘inputfieldvalue’, ‘outputfieldname’, ‘defaultvalue’) IncludedIncludedIncludedIncluded
FindValue(‘entitylogicalname’, ‘inputfieldname’, ‘inputfieldvalue’, ‘outputfieldname’,’defaultvalue’, ‘nolock’, ‘cacheenabled’) IncludedIncludedIncludedIncluded
FindValueFD(‘formuladetailname’, ‘fieldname’, ‘defaultvalue’) IncludedIncludedIncludedIncluded
FindAvgFD(‘formuladetailname’, ‘fieldname’, ‘defaultvalue’) IncludedIncludedIncludedIncluded
FindCountFD(‘formuladetailname’, ‘fieldname’, ‘defaultvalue’) IncludedIncludedIncludedIncluded
FindMaxFD(‘formuladetailname’, ‘fieldname’, ‘defaultvalue’) IncludedIncludedIncludedIncluded
FindMinFD(‘formuladetailname’, ‘fieldname’, ‘defaultvalue’) IncludedIncludedIncludedIncluded
FindSumFD(‘formuladetailname’, ‘fieldname’, ‘defaultvalue’) IncludedIncludedIncludedIncluded
FindBPProcessID(‘business process name’) IncludedIncludedIncludedIncluded
FindBPGetStageID(‘business process name’, ‘stage name’) IncludedIncludedIncludedIncluded
FindTemplateId(‘name’, ‘languagecode’) IncludedIncludedIncludedIncluded
SetFindSelect(‘field1’, ‘field2’) IncludedIncludedIncludedIncluded
Find (EntityCollections)
FindRecords(‘entitylogicalname’, ‘inputfieldname’, ‘inputfieldvalue’, ‘selectfields’, ‘recordcount’) IncludedIncludedIncludedIncluded
FindRecordsFD(‘formuladetail’, ‘nolock’, SetParams(‘param1’, ‘param2’)) IncludedIncludedIncludedIncluded
FindRecordsFetchXml(‘fetchxml’) IncludedIncludedIncludedIncluded
FindRecordsValue(‘entitycollection’, ‘fieldname’, ‘defaultvalue’, ‘rownumber’ ) IncludedIncludedIncludedIncluded
FindECCount(‘entitycollection’) IncludedIncludedIncludedIncluded
Fuzzy Matching
DamerauLevenshteinDistance(‘inputstring1’, ‘inputstring2’) IncludedIncludedIncludedIncluded
LevenshteinDistance(‘inputstring1’, ‘inputstring2’) IncludedIncludedIncludedIncluded
Metaphone3(‘inputstring’) IncludedIncludedIncludedIncluded
Similarity(‘inputstring1’, ‘inputstring2’, ‘distance’) IncludedIncludedIncludedIncluded
HTML
CreateHTMLTable(‘entitycollection’, ‘SetColumnOrder(field1, field2)’, ‘baseurl’, ‘cssref’) IncludedIncludedIncludedIncluded
FindRecordsAuditHtml(‘entityname’, ‘recordguid’, ‘lastnumberofdays’) IncludedIncludedIncludedIncluded
LinkRawUrl(‘baseurl’, ‘entityname’, ‘recordguid’) IncludedIncludedIncludedIncluded
LinkDialogUrl(‘baseurl’, ‘entityname’, ‘recordguid’, ‘displaytext’) IncludedIncludedIncludedIncluded
LinkHyperLinkUrl(‘baseurl’, ‘entityname’, ‘recordguid’, ‘displaytext’) IncludedIncludedIncludedIncluded
StripHtml(‘inputstring’) IncludedIncludedIncludedIncluded
Localization
GetAttributeDisplayName(‘entitylogicalname.attributelogicalname’) IncludedIncludedIncludedIncluded
GetOptionSetName(‘entitylogicalname.attributelogicalname’, ‘optionsetvalue’) IncludedIncludedIncludedIncluded
Logical
Case(‘Lookup under the Snippets menu’) IncludedIncludedIncludedIncluded
if(expression, true, false) IncludedIncludedIncludedIncluded
iftrue(expression, true) Not IncludedNot IncludedIncludedIncluded
NoOp’ IncludedIncludedIncludedIncluded
In(‘ValueToCheck’, ‘value1’, ‘value2’, ‘value3’) IncludedIncludedIncludedIncluded
or IncludedIncludedIncludedIncluded
and IncludedIncludedIncludedIncluded
+ IncludedIncludedIncludedIncluded
IncludedIncludedIncludedIncluded
/ IncludedIncludedIncludedIncluded
* IncludedIncludedIncludedIncluded
% IncludedIncludedIncludedIncluded
! IncludedIncludedIncludedIncluded
= IncludedIncludedIncludedIncluded
!= IncludedIncludedIncludedIncluded
< IncludedIncludedIncludedIncluded
> IncludedIncludedIncludedIncluded
Loop
DoLoop(‘iterationcount’, ‘action’) IncludedIncludedIncludedIncluded
DoLoopIndex() IncludedIncludedIncludedIncluded
DoLoopTotal() IncludedIncludedIncludedIncluded
ForEachRecord(‘entitycollection’, ‘action1’, ‘action2’) IncludedIncludedIncludedIncluded
CurrentRecord(‘fieldname’) IncludedIncludedIncludedIncluded
RecordIndex() IncludedIncludedIncludedIncluded
RecordTotal() IncludedIncludedIncludedIncluded
Math
Abs(value) IncludedIncludedIncludedIncluded
Ceiling(‘value’) IncludedIncludedIncludedIncluded
Exp(‘value’) IncludedIncludedIncludedIncluded
Floor(‘value’) IncludedIncludedIncludedIncluded
GCD(‘num1’, ‘num2’) IncludedIncludedIncludedIncluded
LCM(‘num1’, ‘num2’) IncludedIncludedIncludedIncluded
MaxOf(‘number1’, ‘number2’) IncludedIncludedIncludedIncluded
MinOf(‘number1’, ‘number2’) IncludedIncludedIncludedIncluded
Pow(‘value’, ‘power’) IncludedIncludedIncludedIncluded
Round(‘value’, ‘digitprecision’) IncludedIncludedIncludedIncluded
Sign(‘value’) IncludedIncludedIncludedIncluded
Sqrt(‘value’) IncludedIncludedIncludedIncluded
Truncate(‘value’) IncludedIncludedIncludedIncluded
Platform Operations
AssociateEntities(‘entityNameLeft’, ‘entityLeftGuid’, ‘entityNameRight’, ‘entityRightGuid’, ‘relationshipName’) IncludedIncludedIncludedIncluded
DisAssociateEntities(‘entityNameLeft’, ‘entityLeftGuid’, ‘entityNameRight’, ‘entityRightGuid’, ‘relationshipName’) IncludedIncludedIncludedIncluded
ExecuteWorkflow(‘workflowname’, ‘recordid’) IncludedIncludedIncludedIncluded
ExecuteAction(‘actionname’, ‘entitylogicalname’, ‘recordid’, ‘param1’, ‘param2’, ‘param3’) IncludedIncludedIncludedIncluded
GenerateInvoiceFromOpportunity(‘opportunityid’) IncludedIncludedIncludedIncluded
GenerateQuoteFromOpportunity(‘opportunityid’) IncludedIncludedIncludedIncluded
GenerateSalesOrderFromOpportunity(‘opportunityid’) IncludedIncludedIncludedIncluded
GetActionOutputParameter(‘executeaction’, ‘outputparametername’, ‘defaultname’) IncludedIncludedIncludedIncluded
GetAssociationRelatedEntityReferenceId() IncludedIncludedIncludedIncluded
GetAssociationRelationshipName() IncludedIncludedIncludedIncluded
StartSchedule(‘schedulename’) IncludedIncludedIncludedIncluded
StopSchedule(‘schedulename’) IncludedIncludedIncludedIncluded
RecordShare(‘entitynameofrecordtoshare’, ‘guidofrecordtoshare’,’systemuser\team’, ‘guidofsystemuser\team’,’readaccess’, ‘writeaccess’,’deleteaccess, ‘assignaccess’,’shareaccess’, ‘appendaccess’,’appendtoaccess’) IncludedIncludedIncludedIncluded
RecordUnShare(‘entitynameofrecordtounshare’, ‘guidofrecordtounshare’, ‘systemuser\team’, ‘guidofsystemuser\team’) IncludedIncludedIncludedIncluded
RecordUnShareAll(‘entitynameofrecordtounshare’, ‘guidofrecordtounshare’) IncludedIncludedIncludedIncluded
Record Control
CreateRecord(‘entityname’, SetAttribute(‘attributename’, ‘attributevalue’ )) IncludedIncludedIncludedIncluded
UpdateCreateRecord(‘entityname’, ‘primarykeyid’, SetAttribute(‘attributename’, ‘attributevalue’ )) IncludedIncludedIncludedIncluded
CreateNote(‘title’, ‘regardingentityname’, ‘regardingentityid’, ‘note’) IncludedIncludedIncludedIncluded
CreateNoteIfExists(‘title’, ‘regardingentityname’, ‘regardingentityid’, ‘note’) IncludedIncludedIncludedIncluded
DeleteRecord(‘entityname’, ‘guid’) IncludedIncludedIncludedIncluded
DeleteRecordIfExists(‘entityname’, ‘guid’) IncludedIncludedIncludedIncluded
UpdateRecord(‘entityname’, ‘primarykeyid’, SetAttribute(‘attributename’, ‘attributevalue’ )) IncludedIncludedIncludedIncluded
UpdateRecordIfExists(‘entityname’, ‘primarykeyid’, SetAttribute(‘attributename’, ‘attributevalue’ )) IncludedIncludedIncludedIncluded
UpdateActivityPartyBulk(‘ActivityPartyCollection’, ‘activitypartytype’, SetAttribute(‘attributename’, ‘attributevalue’)) IncludedIncludedIncludedIncluded
SetAttributeStatus(‘status’, ‘statusreason’) IncludedIncludedIncludedIncluded
SetAttribute(‘fieldname’, ‘fieldvalue’) IncludedIncludedIncludedIncluded
SetAttributeLookup(‘fieldname’, ‘entitylogicalname’, ‘guid’) IncludedIncludedIncludedIncluded
SetAttributePartyList(‘fieldname’, ‘entitylogicalname’, ‘guid’, ‘guid’) IncludedIncludedIncludedIncluded
SetAttributeCustomer(‘fieldname’, ‘entitylogicalname’, ‘guid’, ‘recordname’) IncludedIncludedIncludedIncluded
Regex
RegexMatch(‘string’, «regex») IncludedIncludedIncludedIncluded
RegexIsMatch(‘string’, «regex») IncludedIncludedIncludedIncluded
RegexReplace(‘string’, «regextofind», «regextoreplace») IncludedIncludedIncludedIncluded
Native Fields
GetPartyListItemId(‘partylist’, ‘index’) IncludedIncludedIncludedIncluded
GetPartyListItemType(‘partylist’, ‘index’) IncludedIncludedIncludedIncluded
GetPartyListItemName(‘partylist’, ‘index’) IncludedIncludedIncludedIncluded
GetPartyListCount(‘partylist’) IncludedIncludedIncludedIncluded
SetCustomerLookup(‘entityname’, ‘guid’, ‘Primary Field Text’) IncludedIncludedIncludedIncluded
SetLookup(‘guid’) IncludedIncludedIncludedIncluded
SetOwnerTeam(‘guid’) IncludedIncludedIncludedIncluded
SetOwnerUser(‘guid’) IncludedIncludedIncludedIncluded
SetPartyList(‘entityname’,’guidentity’,’guidentity’) IncludedIncludedIncludedIncluded
SetPartyListCombined(SetPartyList(‘entityname’,’guidentity’,’guidentity’), SetPartyList(‘entityname’,’guidentity’,’guidentity’)) IncludedIncludedIncludedIncluded
SetRegardingLookup(‘entityname’, ‘guid’, ‘Primary Field Text’) IncludedIncludedIncludedIncluded
SetState(state,status) IncludedIncludedIncludedIncluded
String
AppendFormat(‘inputstring’, param[0],param[1],param[n]) IncludedIncludedIncludedIncluded
Base64Encode(‘inputstring’) IncludedIncludedIncludedIncluded
Base64Decode(‘inputstring’) IncludedIncludedIncludedIncluded
Capitalize(‘inputstring’) IncludedIncludedIncludedIncluded
Contains(‘inputstring’, ‘stringtofind’) IncludedIncludedIncludedIncluded
Compress(‘inputstring’) IncludedIncludedIncludedIncluded
CountCharacters(‘inputstring’) IncludedIncludedIncludedIncluded
Decompress(‘inputstring’) IncludedIncludedIncludedIncluded
EndsWith(‘inputstring’, ‘endstring’) IncludedIncludedIncludedIncluded
GenerateGuid() IncludedIncludedIncludedIncluded
GetParamFromUrl(‘url’, ‘parameter’) IncludedIncludedIncludedIncluded
IndexOf(‘inputstring’, ‘stringtofind’, ‘startindex’) IncludedIncludedIncludedIncluded
Insert(‘inputstring’, position, ‘insertstring’) IncludedIncludedIncludedIncluded
Left(‘inputstring’, ‘numberofcharacters’) IncludedIncludedIncludedIncluded
Lower(‘inputstring’) IncludedIncludedIncludedIncluded
MD5(‘inputstring’) IncludedIncludedIncludedIncluded
PadLeft(‘inputstring’, totalLength, ‘charToPad’) IncludedIncludedIncludedIncluded
PadRight(‘inputstring’, totalLength, ‘charToPad’) IncludedIncludedIncludedIncluded
Replace(‘inputstring’, ‘stringtofind’, ‘stringtoreplace’) IncludedIncludedIncludedIncluded
Remove(‘inputstring’, ‘startpostion’, ‘numberofcharacterstoremove’) IncludedIncludedIncludedIncluded
Right(‘inputstring’, numberofcharacters) IncludedIncludedIncludedIncluded
Reverse(‘inputstring’) IncludedIncludedIncludedIncluded
SHA1(‘inputstring’) IncludedIncludedIncludedIncluded
Slice(‘inputstring’, ‘start’, ‘end’) IncludedIncludedIncludedIncluded
Split(‘inputstring’, ‘chartosplit’, ‘index’) IncludedIncludedIncludedIncluded
StartsWith(‘inputstring’, ‘startstring’) IncludedIncludedIncludedIncluded
StringFormat(‘inputstring’, ‘param[0]’,’param[1]’,’param[n]’) IncludedIncludedIncludedIncluded
Substring(‘inputstring’, startposition, length) IncludedIncludedIncludedIncluded
Upper(‘inputstring’) IncludedIncludedIncludedIncluded
ToString(‘valuetoconvert’, ‘format’) IncludedIncludedIncludedIncluded
ToTitleCase(‘inputstring’) IncludedIncludedIncludedIncluded
Trim(‘inputstring’, ‘param[0]’,’param[1]’,’param[n]’) IncludedIncludedIncludedIncluded
System
AutoNumber(‘autonumberstring’) IncludedIncludedIncludedIncluded
Between(‘testvalue’, ‘minvalue’, ‘maxvalue’, ‘inclusive’) IncludedIncludedIncludedIncluded
Clear() IncludedIncludedIncludedIncluded
CreateEmailFromTemplate(‘templateid’, ‘recordid’, ‘recordentityname’, ‘setattribute_on_email’, ‘setattribute_on_email’) IncludedIncludedIncludedIncluded
Clone(‘entityname’, ‘guidofentity’, ‘relationshipname’, ‘enableprefix’) IncludedIncludedIncludedIncluded
ContainsData(‘fieldtocheck1’, ‘fieldtocheck2’) IncludedIncludedIncludedIncluded
ContainsDataAndNotZero(‘fieldtocheck’, ‘fieldtocheck2’) IncludedIncludedIncludedIncluded
DoesNotContainData(‘fieldtocheck1’, ‘fieldtocheck2’) IncludedIncludedIncludedIncluded
DecisionTable(‘step1’, ‘step2’, ‘step3’) Not IncludedNot IncludedIncludedIncluded
DoesUserHavePrivilege(‘userid’, ‘privilegename’) IncludedIncludedIncludedIncluded
GetUserRoles(‘userid’) IncludedIncludedIncludedIncluded
GetUserTeams(‘userid’) IncludedIncludedIncludedIncluded
IsUserInSecurityRoles(‘userid’, ‘securityrole1’, ‘securityrole2’) IncludedIncludedIncludedIncluded
MaxOf(value1, value2) IncludedIncludedIncludedIncluded
MinOf(value1, value2) IncludedIncludedIncludedIncluded
Random(minvalue, maxvalue) IncludedIncludedIncludedIncluded
RemoveAttribute() IncludedIncludedIncludedIncluded
PriorValue(‘fieldreference’) IncludedIncludedIncludedIncluded
SendEmail(’emailguid’) IncludedIncludedIncludedIncluded
SetCurrencySymbol(‘Value’, ‘CurrencySymbol’) IncludedIncludedIncludedIncluded
ThrowError(‘message’) IncludedIncludedIncludedIncluded
WhoAmI() IncludedIncludedIncludedIncluded
SmartFlow(‘step1’, ‘step2’, ‘step3’) Not IncludedNot IncludedIncludedIncluded
SetVar(‘variablename’, ‘value’) Not IncludedNot IncludedIncludedIncluded
SetVarConcat(‘variablename’, ‘value’) Not IncludedNot IncludedIncludedIncluded
GetVar(‘variablename’, ‘value’, ‘defaultvaue’) Not IncludedNot IncludedIncludedIncluded
Process – JSON
CreateJArray(CreateJObject(), CreateJObject()) Not IncludedIncludedIncludedIncluded
CreateJArrayChildren(‘entitycollection’, CreateJObject()) Not IncludedIncludedIncludedIncluded
CreateJObject(CreateJProperty(), CreateJProperty()) Not IncludedIncludedIncludedIncluded
CreateJProperty(‘fieldname’, ‘fieldvalue’) Not IncludedIncludedIncludedIncluded
FindJArrayItem(‘fieldname’, ‘defaultvalue’) Not IncludedIncludedIncludedIncluded
GetVarJsonValue(‘selecttoken’) Not IncludedIncludedIncludedIncluded
GetVarJsonEC(‘selecttoken’) Not IncludedIncludedIncludedIncluded
Process – XML
CreateXmlAttribute(‘attributename’, ‘attributevalue’) Not IncludedIncludedIncludedIncluded
CreateXmlChildren(‘collectionname’, ‘collectionitemname’, ‘entitycollection’, ‘xmlelement’, ‘xmlelement’) Not IncludedIncludedIncludedIncluded
CreateXmlDeclaration(‘version’,’encoding’,’standalone’) Not IncludedIncludedIncludedIncluded
CreateXmlElement(‘elementname’, ‘elementvalue’) Not IncludedIncludedIncludedIncluded
CreateXmlRootAttribute(‘name’, ‘value’, ‘name’, ‘value’) Not IncludedIncludedIncludedIncluded
CreateXmlRootNode(‘nameofrootnode’, ‘xmldeclaration’, ‘xmlschemas\root attributes’, ‘xmlnodes’) Not IncludedIncludedIncludedIncluded
FindXmlItem(‘fieldname’) Not IncludedIncludedIncludedIncluded
GetVarXPathValue(‘xpath’) Not IncludedIncludedIncludedIncluded
GetVarXPathEC(‘xpath’) Not IncludedIncludedIncludedIncluded
REST Services
CallRestAPI(
SetRequestBaseURL(‘baseurl’),
SetRequestResource(‘resource’),
SetRequestDetails(‘method’),
SetRequestHeaders(),
SetRequestParams(),
SetRequestAuthenticationNone(),
SetRequestFiles(),
SetRequestExpected(‘responsestatuscode’),
SetRequestActionPass(‘action’),
SetRequestActionFail(‘action’)
)
Not IncludedIncludedIncludedIncluded
SetRequestBaseURL(‘baseurl’) Not IncludedIncludedIncludedIncluded
SetRequestResource(‘resource’) Not IncludedIncludedIncludedIncluded
SetRequestDetails(‘method’) Not IncludedIncludedIncludedIncluded
SetRequestHeaders(‘fieldpath’) Not IncludedIncludedIncludedIncluded
SetRequestParams(‘fieldpath’) Not IncludedIncludedIncludedIncluded
SetRequestAuthenticationNone() Not IncludedIncludedIncludedIncluded
SetRequestFiles(‘fieldpath’) Not IncludedIncludedIncludedIncluded
SetRequestExpected(‘responsestatuscode’) Not IncludedIncludedIncludedIncluded
SetRequestActionPass(‘action1’, ‘action2’) Not IncludedIncludedIncludedIncluded
SetRequestActionFail(‘action1’, ‘action2’) Not IncludedIncludedIncludedIncluded
GetVarJsonValue(‘fieldpath’) Not IncludedIncludedIncludedIncluded
GetVarJsonEC(‘fieldpath’) Not IncludedIncludedIncludedIncluded
GetVarXmlValue(‘fieldpath’) Not IncludedIncludedIncludedIncluded
GetVarXmlEC(‘fieldpath’) Not IncludedIncludedIncludedIncluded
Native Services
GeoCodeBing(‘addressLine’, ‘locality’, ‘adminDistrict’, ‘postalCode’, ‘countryRegion’) Not IncludedIncludedIncludedIncluded
GetExchangeRate(‘from’, ‘to’) Not IncludedIncludedIncludedIncluded
Translate(‘text’, ‘to’, ‘from’) Not IncludedIncludedIncludedIncluded
SharePoint Services
SharePointCreateFile(‘sharepointside’, ‘sharepointusername’, ‘sharepointuserpassword’, ‘issharepointonline’, ‘replaceexistingfile’, ‘documentlibrary’, ‘filename’, ‘documentdata’, SharePointSetItemMetaData(‘fieldname’, ‘fieldvalue’)) Not IncludedNot IncludedIncludedIncluded
SharePointCreateFolder(‘sharepointside’, ‘sharepointusername’, ‘sharepointuserpassword’, ‘issharepointonline’, ‘foldertocreate’) Not IncludedNot IncludedIncludedIncluded
SharePointCreateSite(‘sharepointside’, ‘sharepointusername’, ‘sharepointuserpassword’, ‘issharepointonline’, ‘siteurlname’, ‘sitename’, ‘sitedesc’, ‘language’, ‘template’, ‘uniquepermissions’) Not IncludedNot IncludedIncludedIncluded
SharePointDeleteFile(‘sharepointside’, ‘sharepointusername’, ‘sharepointuserpassword’, ‘issharepointonline’, ‘filetodelete’) Not IncludedNot IncludedIncludedIncluded
SharePointFindDocumentsByFetchXml(‘entityname’,’recordid’) Not IncludedNot IncludedIncludedIncluded
SharePointGetFile(‘sharepointside’, ‘sharepointusername’, ‘sharepointuserpassword’, ‘issharepointonline’, ‘filetoretrieve’) Not IncludedNot IncludedIncludedIncluded
SharePointGetItemMetaData(‘sharepointside’, ‘sharepointusername’, ‘sharepointuserpassword’, ‘issharepointonline’, ‘filename’) Not IncludedNot IncludedIncludedIncluded
SharePointUpdateItemMetaData(‘sharepointside’, ‘sharepointusername’, ‘sharepointuserpassword’, ‘issharepointonline’, ‘filename’, ‘metadata’) Not IncludedNot IncludedIncludedIncluded
SharePointSetItemMetaData(‘fieldname’, ‘fieldvalue’, ‘fieldname’, ‘fieldvalue’) Not IncludedNot IncludedIncludedIncluded
xCache
xCacheGetGlobal(‘key’, ‘defaultvalue’) Not IncludedNot IncludedIncludedIncluded
xCacheAddCalculatedFieldLocal(‘key’, ‘name’, ‘datatype’, ‘expression’) Not IncludedNot IncludedNot IncludedIncluded
xCacheCalculateLocal(‘key’, ‘expression’, ‘filter’, ‘defaultvalue’) Not IncludedNot IncludedNot IncludedIncluded
xCacheFilterLocal(‘key’, ‘filter’, ‘sort’) Not IncludedNot IncludedNot IncludedIncluded
xCacheGetLocal(‘key’, ‘fieldname’, ‘defaultvalue’, ‘rownumber’) Not IncludedNot IncludedNot IncludedIncluded
xCacheLoadLocal(‘key’, ‘entitycollection’) Not IncludedNot IncludedNot IncludedIncluded