{"id":39013,"date":"2018-06-17T02:54:29","date_gmt":"2018-06-17T02:54:29","guid":{"rendered":"https:\/\/ampscript.guide\/book\/function-index\/"},"modified":"2025-09-27T18:40:48","modified_gmt":"2025-09-27T18:40:48","slug":"function-index","status":"publish","type":"post","link":"https:\/\/ampscript.guide\/function-index\/","title":{"rendered":"Function Index"},"content":{"rendered":"<h1>Function Index<\/h1>\n<ul>\n<li><a href=\"\/add\">Add<\/a><\/li>\n<li><a href=\"\/addmscrmlistmember\">AddMSCRMListMember<\/a><\/li>\n<li><a href=\"\/addobjectarrayitem\">AddObjectArrayItem<\/a><\/li>\n<li><a href=\"\/attachfile\">AttachFile<\/a><\/li>\n<li><a href=\"\/attributevalue\">AttributeValue<\/a><\/li>\n<li><a href=\"\/authenticatedemployeeid\">AuthenticatedEmployeeID<\/a><\/li>\n<li><a href=\"\/authenticatedemployeenotificationaddress\">AuthenticatedEmployeeNotificationAddress<\/a><\/li>\n<li><a href=\"\/authenticatedemployeeusername\">AuthenticatedEmployeeUserName<\/a><\/li>\n<li><a href=\"\/authenticatedenterpriseid\">AuthenticatedEnterpriseID<\/a><\/li>\n<li><a href=\"\/authenticatedmemberid\">AuthenticatedMemberID<\/a><\/li>\n<li><a href=\"\/authenticatedmembername\">AuthenticatedMemberName<\/a><\/li>\n<li><a href=\"\/barcodeurl\">BarcodeURL<\/a><\/li>\n<li><a href=\"\/base64decode\">Base64Decode<\/a><\/li>\n<li><a href=\"\/base64encode\">Base64Encode<\/a><\/li>\n<li><a href=\"\/beginimpressionregion\">BeginImpressionRegion<\/a><\/li>\n<li><a href=\"\/buildoptionlist\">BuildOptionList<\/a><\/li>\n<li><a href=\"\/buildrowsetfromjson\">BuildRowSetFromJSON<\/a><\/li>\n<li><a href=\"\/buildrowsetfromstring\">BuildRowSetFromString<\/a><\/li>\n<li><a href=\"\/buildrowsetfromxml\">BuildRowSetFromXML<\/a><\/li>\n<li><a href=\"\/char\">Char<\/a><\/li>\n<li><a href=\"\/claimrow\">ClaimRow<\/a><\/li>\n<li><a href=\"\/claimrowvalue\">ClaimRowValue<\/a><\/li>\n<li><a href=\"\/cloudpagesurl\">CloudPagesURL<\/a><\/li>\n<li><a href=\"\/concat\">Concat<\/a><\/li>\n<li><a href=\"\/contentarea\">ContentArea<\/a><\/li>\n<li><a href=\"\/contentareabyname\">ContentAreaByName<\/a><\/li>\n<li><a href=\"\/contentblockbyid\">ContentBlockByID<\/a><\/li>\n<li><a href=\"\/contentblockbykey\">ContentBlockByKey<\/a><\/li>\n<li><a href=\"\/contentblockbyname\">ContentBlockByName<\/a><\/li>\n<li><a href=\"\/contentimagebyid\">ContentImageByID<\/a><\/li>\n<li><a href=\"\/contentimagebykey\">ContentImageByKey<\/a><\/li>\n<li><a href=\"\/createmscrmrecord\">CreateMSCRMRecord<\/a><\/li>\n<li><a href=\"\/createobject\">CreateObject<\/a><\/li>\n<li><a href=\"\/createsalesforceobject\">CreateSalesforceObject<\/a><\/li>\n<li><a href=\"\/createsmsconversation\">CreateSmsConversation<\/a><\/li>\n<li><a href=\"\/dataextensionrowcount\">DataExtensionRowCount<\/a><\/li>\n<li><a href=\"\/dateadd\">DateAdd<\/a><\/li>\n<li><a href=\"\/datediff\">DateDiff<\/a><\/li>\n<li><a href=\"\/dateparse\">DateParse<\/a><\/li>\n<li><a href=\"\/datepart\">DatePart<\/a><\/li>\n<li><a href=\"\/decryptsymmetric\">DecryptSymmetric<\/a><\/li>\n<li><a href=\"\/deletedata\">DeleteData<\/a><\/li>\n<li><a href=\"\/deletede\">DeleteDE<\/a><\/li>\n<li><a href=\"\/describemscrmentities\">DescribeMSCRMEntities<\/a><\/li>\n<li><a href=\"\/describemscrmentityattributes\">DescribeMSCRMEntityAttributes<\/a><\/li>\n<li><a href=\"\/divide\">Divide<\/a><\/li>\n<li><a href=\"\/domain\">Domain<\/a><\/li>\n<li><a href=\"\/empty\">Empty<\/a><\/li>\n<li><a href=\"\/encryptsymmetric\">EncryptSymmetric<\/a><\/li>\n<li><a href=\"\/endimpressionregion\">EndImpressionRegion<\/a><\/li>\n<li><a href=\"\/endsmsconversation\">EndSmsConversation<\/a><\/li>\n<li><a href=\"\/executefilter\">ExecuteFilter<\/a><\/li>\n<li><a href=\"\/executefilterorderedrows\">ExecuteFilterOrderedRows<\/a><\/li>\n<li><a href=\"\/field\">Field<\/a><\/li>\n<li><a href=\"\/format\">Format<\/a><\/li>\n<li><a href=\"\/formatcurrency\">FormatCurrency<\/a><\/li>\n<li><a href=\"\/formatdate\">FormatDate<\/a><\/li>\n<li><a href=\"\/formatnumber\">FormatNumber<\/a><\/li>\n<li><a href=\"\/getjwt\">GetJWT<\/a><\/li>\n<li><a href=\"\/getjwtbykeyname\">GetJWTByKeyName<\/a><\/li>\n<li><a href=\"\/getportfolioitem\">GetPortfolioItem<\/a><\/li>\n<li><a href=\"\/getpublishedsocialcontent\">GetPublishedSocialContent<\/a><\/li>\n<li><a href=\"\/getsendtime\">GetSendTime<\/a><\/li>\n<li><a href=\"\/getsocialpublishurl\">GetSocialPublishURL<\/a><\/li>\n<li><a href=\"\/getsocialpublishurlbyname\">GetSocialPublishURLByName<\/a><\/li>\n<li><a href=\"\/getvalue\">GetValue (SSJS)<\/a><\/li>\n<li><a href=\"\/guid\">GUID<\/a><\/li>\n<li><a href=\"\/httpget\">HTTPGet<\/a><\/li>\n<li><a href=\"\/httppost\">HTTPPost<\/a><\/li>\n<li><a href=\"\/httppost2\">HTTPPost2<\/a><\/li>\n<li><a href=\"\/httppostwithretry\">HTTPPostWithRetry<\/a><\/li>\n<li><a href=\"\/httprequestheader\">HTTPRequestHeader<\/a><\/li>\n<li><a href=\"\/iif\">IIf<\/a><\/li>\n<li><a href=\"\/image\">Image<\/a><\/li>\n<li><a href=\"\/indexof\">IndexOf<\/a><\/li>\n<li><a href=\"\/insertdata\">InsertData<\/a><\/li>\n<li><a href=\"\/insertde\">InsertDE<\/a><\/li>\n<li><a href=\"\/invokecreate\">InvokeCreate<\/a><\/li>\n<li><a href=\"\/invokedelete\">InvokeDelete<\/a><\/li>\n<li><a href=\"\/invokeexecute\">InvokeExecute<\/a><\/li>\n<li><a href=\"\/invokeperform\">InvokePerform<\/a><\/li>\n<li><a href=\"\/invokeretrieve\">InvokeRetrieve<\/a><\/li>\n<li><a href=\"\/invokeupdate\">InvokeUpdate<\/a><\/li>\n<li><a href=\"\/ischtmlbrowser\">IsCHTMLBrowser<\/a><\/li>\n<li><a href=\"\/isemailaddress\">IsEmailAddress<\/a><\/li>\n<li><a href=\"\/isnull\">IsNull<\/a><\/li>\n<li><a href=\"\/isnulldefault\">IsNullDefault<\/a><\/li>\n<li><a href=\"\/isphonenumber\">IsPhoneNumber<\/a><\/li>\n<li><a href=\"\/length\">Length<\/a><\/li>\n<li><a href=\"\/livecontentmicrositeurl\">LiveContentMicrositeURL<\/a><\/li>\n<li><a href=\"\/localdatetosystemdate\">LocalDateToSystemDate<\/a><\/li>\n<li><a href=\"\/longsfid\">LongSFID<\/a><\/li>\n<li><a href=\"\/lookup\">Lookup<\/a><\/li>\n<li><a href=\"\/lookuporderedrows\">LookupOrderedRows<\/a><\/li>\n<li><a href=\"\/lookuporderedrowscs\">LookupOrderedRowsCS<\/a><\/li>\n<li><a href=\"\/lookuprows\">LookupRows<\/a><\/li>\n<li><a href=\"\/lookuprowscs\">LookupRowsCS<\/a><\/li>\n<li><a href=\"\/lowercase\">Lowercase<\/a><\/li>\n<li><a href=\"\/md5\">MD5<\/a><\/li>\n<li><a href=\"\/micrositeurl\">MicrositeURL<\/a><\/li>\n<li><a href=\"\/mod\">Mod<\/a><\/li>\n<li><a href=\"\/multiply\">Multiply<\/a><\/li>\n<li><a href=\"\/now\">Now<\/a><\/li>\n<li><a href=\"\/output\">Output<\/a><\/li>\n<li><a href=\"\/outputline\">OutputLine<\/a><\/li>\n<li><a href=\"\/propercase\">ProperCase<\/a><\/li>\n<li><a href=\"\/queryparameter\">QueryParameter<\/a><\/li>\n<li><a href=\"\/raiseerror\">RaiseError<\/a><\/li>\n<li><a href=\"\/random\">Random<\/a><\/li>\n<li><a href=\"\/ratingstars\">RatingStars<\/a><\/li>\n<li><a href=\"\/redirect\">Redirect<\/a><\/li>\n<li><a href=\"\/redirectto\">RedirectTo<\/a><\/li>\n<li><a href=\"\/regexmatch\">RegExMatch<\/a><\/li>\n<li><a href=\"\/replace\">Replace<\/a><\/li>\n<li><a href=\"\/replacelist\">ReplaceList<\/a><\/li>\n<li><a href=\"\/requestparameter\">RequestParameter<\/a><\/li>\n<li><a href=\"\/retrievemscrmrecords\">RetrieveMSCRMRecords<\/a><\/li>\n<li><a href=\"\/retrievemscrmrecordsfetchxml\">RetrieveMSCRMRecordsFetchXML<\/a><\/li>\n<li><a href=\"\/retrievesalesforcejobsources\">RetrieveSalesforceJobSources<\/a><\/li>\n<li><a href=\"\/retrievesalesforceobjects\">RetrieveSalesforceObjects<\/a><\/li>\n<li><a href=\"\/row\">Row<\/a><\/li>\n<li><a href=\"\/rowcount\">RowCount<\/a><\/li>\n<li><a href=\"\/setobjectproperty\">SetObjectProperty<\/a><\/li>\n<li><a href=\"\/setsmsconversationnextkeyword\">SetSmsConversationNextKeyword<\/a><\/li>\n<li><a href=\"\/setstatemscrmrecord\">SetStateMSCRMRecord<\/a><\/li>\n<li><a href=\"\/setvalue\">SetValue (SSJS)<\/a><\/li>\n<li><a href=\"\/sha1\">SHA1<\/a><\/li>\n<li><a href=\"\/sha256\">SHA256<\/a><\/li>\n<li><a href=\"\/sha512\">SHA512<\/a><\/li>\n<li><a href=\"\/stringtodate\">StringToDate<\/a><\/li>\n<li><a href=\"\/stringtohex\">StringToHex<\/a><\/li>\n<li><a href=\"\/substring\">Substring<\/a><\/li>\n<li><a href=\"\/subtract\">Subtract<\/a><\/li>\n<li><a href=\"\/systemdatetolocaldate\">SystemDateToLocalDate<\/a><\/li>\n<li><a href=\"\/transformxml\">TransformXML<\/a><\/li>\n<li><a href=\"\/treatascontent\">TreatAsContent<\/a><\/li>\n<li><a href=\"\/treatascontentarea\">TreatAsContentArea<\/a><\/li>\n<li><a href=\"\/trim\">Trim<\/a><\/li>\n<li><a href=\"\/updatedata\">UpdateData<\/a><\/li>\n<li><a href=\"\/updatede\">UpdateDE<\/a><\/li>\n<li><a href=\"\/updatemscrmrecords\">UpdateMSCRMRecords<\/a><\/li>\n<li><a href=\"\/updatesinglesalesforceobject\">UpdateSingleSalesforceObject<\/a><\/li>\n<li><a href=\"\/uppercase\">Uppercase<\/a><\/li>\n<li><a href=\"\/upsertcontact\">UpsertContact<\/a><\/li>\n<li><a href=\"\/upsertdata\">UpsertData<\/a><\/li>\n<li><a href=\"\/upsertde\">UpsertDE<\/a><\/li>\n<li><a href=\"\/upsertmscrmrecord\">UpsertMSCRMRecord<\/a><\/li>\n<li><a href=\"\/urlencode\">URLEncode<\/a><\/li>\n<li><a href=\"\/v\">V<\/a><\/li>\n<li><a href=\"\/wat\">WAT<\/a><\/li>\n<li><a href=\"\/watp\">WATP<\/a><\/li>\n<li><a href=\"\/wraplongurl\">WrapLongURL<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Function Index Add AddMSCRMListMember AddObjectArrayItem AttachFile AttributeValue AuthenticatedEmployeeID AuthenticatedEmployeeNotificationAddress AuthenticatedEmployeeUserName AuthenticatedEnterpriseID AuthenticatedMemberID AuthenticatedMemberName BarcodeURL Base64Decode Base64Encode BeginImpressionRegion BuildOptionList BuildRowSetFromJSON BuildRowSetFromString BuildRowSetFromXML Char ClaimRow ClaimRowValue CloudPagesURL Concat ContentArea ContentAreaByName ContentBlockByID ContentBlockByKey ContentBlockByName ContentImageByID ContentImageByKey CreateMSCRMRecord CreateObject CreateSalesforceObject CreateSmsConversation DataExtensionRowCount DateAdd DateDiff DateParse DatePart DecryptSymmetric DeleteData DeleteDE DescribeMSCRMEntities DescribeMSCRMEntityAttributes Divide Domain Empty EncryptSymmetric EndImpressionRegion EndSmsConversation ExecuteFilter ExecuteFilterOrderedRows [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v14.7 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>The AMPscript Guide - Function Index<\/title>\n<meta name=\"robots\" content=\"index, follow\" \/>\n<meta name=\"googlebot\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<meta name=\"bingbot\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/ampscript.guide\/function-index\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"The AMPscript Guide - Function Index\" \/>\n<meta property=\"og:description\" content=\"Function Index Add AddMSCRMListMember AddObjectArrayItem AttachFile AttributeValue AuthenticatedEmployeeID AuthenticatedEmployeeNotificationAddress AuthenticatedEmployeeUserName AuthenticatedEnterpriseID AuthenticatedMemberID AuthenticatedMemberName BarcodeURL Base64Decode Base64Encode BeginImpressionRegion BuildOptionList BuildRowSetFromJSON BuildRowSetFromString BuildRowSetFromXML Char ClaimRow ClaimRowValue CloudPagesURL Concat ContentArea ContentAreaByName ContentBlockByID ContentBlockByKey ContentBlockByName ContentImageByID ContentImageByKey CreateMSCRMRecord CreateObject CreateSalesforceObject CreateSmsConversation DataExtensionRowCount DateAdd DateDiff DateParse DatePart DecryptSymmetric DeleteData DeleteDE DescribeMSCRMEntities DescribeMSCRMEntityAttributes Divide Domain Empty EncryptSymmetric EndImpressionRegion EndSmsConversation ExecuteFilter ExecuteFilterOrderedRows [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/ampscript.guide\/function-index\/\" \/>\n<meta property=\"og:site_name\" content=\"The AMPscript Guide\" \/>\n<meta property=\"article:published_time\" content=\"2018-06-17T02:54:29+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-09-27T18:40:48+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebSite\",\"@id\":\"https:\/\/ampscript.guide\/#website\",\"url\":\"https:\/\/ampscript.guide\/\",\"name\":\"The AMPscript Guide\",\"description\":\"The Definitive Scripting Manual for Salesforce Marketing Cloud\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":\"https:\/\/ampscript.guide\/?s={search_term_string}\",\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/ampscript.guide\/function-index\/#webpage\",\"url\":\"https:\/\/ampscript.guide\/function-index\/\",\"name\":\"The AMPscript Guide - Function Index\",\"isPartOf\":{\"@id\":\"https:\/\/ampscript.guide\/#website\"},\"datePublished\":\"2018-06-17T02:54:29+00:00\",\"dateModified\":\"2025-09-27T18:40:48+00:00\",\"author\":{\"@id\":\"https:\/\/ampscript.guide\/#\/schema\/person\/5335042f77731e84f9808aecef25daec\"},\"breadcrumb\":{\"@id\":\"https:\/\/ampscript.guide\/function-index\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/ampscript.guide\/function-index\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/ampscript.guide\/function-index\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"item\":{\"@type\":\"WebPage\",\"@id\":\"https:\/\/ampscript.guide\/\",\"url\":\"https:\/\/ampscript.guide\/\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"position\":2,\"item\":{\"@type\":\"WebPage\",\"@id\":\"https:\/\/ampscript.guide\/function-index\/\",\"url\":\"https:\/\/ampscript.guide\/function-index\/\",\"name\":\"Function Index\"}}]},{\"@type\":[\"Person\"],\"@id\":\"https:\/\/ampscript.guide\/#\/schema\/person\/5335042f77731e84f9808aecef25daec\",\"name\":\"dev\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","_links":{"self":[{"href":"https:\/\/ampscript.guide\/wp-json\/wp\/v2\/posts\/39013"}],"collection":[{"href":"https:\/\/ampscript.guide\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ampscript.guide\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ampscript.guide\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ampscript.guide\/wp-json\/wp\/v2\/comments?post=39013"}],"version-history":[{"count":0,"href":"https:\/\/ampscript.guide\/wp-json\/wp\/v2\/posts\/39013\/revisions"}],"wp:attachment":[{"href":"https:\/\/ampscript.guide\/wp-json\/wp\/v2\/media?parent=39013"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ampscript.guide\/wp-json\/wp\/v2\/categories?post=39013"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ampscript.guide\/wp-json\/wp\/v2\/tags?post=39013"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}