JUMP TOOverviewReferenceAirscriptText FunctionsCAPITALIZECONCATISSTRINGLOWERCASEPADSTRINGREPLACEREPTSPLITSTRING_COMPARESTRING_FINDSTRIPSUBSTITUTESUBSTRINGTITLECASETRIMUPPERCASEDateTime FunctionsADD_TO_DATEADD_TO_DATETIMEDATEDATETIMEDATETIME_DELTADATETIME_FROM_FORMATDATETIME_FROM_TIMESTAMPDATE_DELTADATE_FROM_DATETIMEDATE_FROM_FORMATDAYDAYSFORMAT_DATEFORMAT_DATETIMEFORMAT_TIMEHOURISO_WEEKMINUTEMONTHNOWSECONDSUBTRACT_FROM_DATESUBTRACT_FROM_DATETIMETIMETIMESTAMP_FROM_DATETIMETIME_DELTATIME_FROM_DATETIMETIME_FROM_FORMATTODAYUPDATE_DATEUPDATE_DATETIMEUPDATE_DAYUPDATE_HOURUPDATE_MILLISECONDUPDATE_MINUTEUPDATE_MONTHUPDATE_SECONDUPDATE_TIMEUPDATE_TIMEZONEUPDATE_YEARWEEKWEEKDAYYEARList FunctionsCONTAINSFIRSTFLATJOINLASTLENGTHREMOVE_EMPTYREVERSESHUFFLEObject FunctionsKEYSMERGE_OBJECTSOBJECT_TO_SOAPOBJECT_TO_XMLSOAP_TO_OBJECTSOAP_HEADER_TO_OBJECTVALUESXML_TO_OBJECTMath FunctionsABSACOSACOSHACOTACOTHASINASINHATANATAN2ATANHCEILINGCOMBINCOMBINACOSCOSHCOTCOTHCSCCSCHDEGREESEVENEXPFACTFACTDOUBLEFLOORGCDISEVENISNUMBERISODDLATLNGDISTANCELCMLNLOGMAXMINMROUNDMULTINOMIALODDPIPOWERPRODUCTRADIANSRANDOMRANGEROUNDROUNDDOWNROUNDUPSECSECHSIGNSINSINHSQRTSQRTPISUMSUMSQTANTANHTRUNCConditional FunctionsEQUALIFISEMPTYISNOTEMPTYNOTCurrency FunctionsCURRENCYFORMAT_CURRENCYPARSE_CURRENCYPhone FunctionsFORMAT_PHONEISPHONEPARSE_PHONEEmail FunctionsISEMAILNumber Formatting FunctionsARABICFORMAT_NUMBERPARSE_NUMBERROMANData Type FunctionsFROM_JSONTO_JSONTYPEOFAsset FunctionsASSET_SIZEASSET_STATEASSET_THUMBNAIL_URLASSET_TO_URIASSET_TYPEURI_TO_ASSETEncoding FunctionsBASEBASE64_DECODEBASE64_ENCODEHMAC_MD5HMAC_SHA1HMAC_SHA256MD5SHA1SHA256URL_DECODEURL_ENCODEUUIDVALUE_OFError Handling FunctionsTHROWTRYForm and Validation FunctionsFIRST_VALIDATIONRUN_VALIDATIONSArithmetic OperatorsAddition (+)Subtraction (-)Multiplication (*)Division (/)Remainder (%)Comparison OperatorsEquality (=)Inequality (<>, !=)Ordering (<, <=, > , >=)Logical OperatorsANDORXORNull Coalescing Operator (??)Advanced ExpressionsLET...INUser Defined FunctionsWeb ControlsButtonCheckboxChatSimple Checkbox ListContainerContainer ListCredit CardCurrency InputDate InputDate PickerDropdown ListEmail InputEmbedded External Content (iFrame)Fieldset ContainerFile UploadFormHyperlinkImageInline ContainerLabelMapMarkdownNumber InputPayment Request ButtonPhone InputPlace Search InputProgress BarQR CodeRadio ButtonSimple Radio ListSchedulerSecure String InputSelectable ContainerSignature InputText AreaText InputTime InputWeb FlowWeb PageVoice and Chat ControlsDecision MenuForward CallSecure Touchtone CaptureText Response CaptureTouchtone CaptureData OperationsData Operation OverviewAirData RequestDELETEPUTINSERTPATCHQUERYDEPRECATED_QUERYCalendar SearchClose ConversationConversation TranscriptCreate FileDelete AssetsDownload Encoded AssetEarly ReturnFetch Agent InformationFetch Asset DetailsFetch Routing Flow StatsFind Conversations by Customer IdentifierFill PDF FormGoogleHTML to PDFHTTP RequestUsing an API With PagingJWT GenerationMerge PDFMove Conversation to Routing FlowOpt Out SearchOpt Out ListRun Data FlowRun Event in JourneySalesforceSecure Value RetrievalSend EmailSend Message to ConversationSFTPStart JourneySwagger Schema ValidationTransformUpdate Customer IdentifierWaitXML to JSONZendeskZIP FileActionsAnalytics IdentifyAnalytics Send EventClose ModalConditionEnd SessionExtend Session Expiration TimeInitialize ActorLog Custom EventMetric: CountMetric: FieldMetric: Start TimerMetric: StatisticMetric: Stop TimerNavigate To Web FlowNavigate to Web PageOpen ModalRun Data FlowRun Data Flow RepeatedlyRun Embedded Outgoing EventRun EventSend EmailSend SMSSet AuthenticationSet IdentifierSet VariableStart Chat BotStart Voice BotStart TimerStop TimerThrowTrigger Form ValidationTryConversation ActionSConversation Actions OverviewAsk A QuestionCapture User ResponseClose ConversationMove Customer to ResourceMove Conversation to Routing FlowQuick RepliesRun Answer FlowStart Conversation Chat BotStart ConversationSend LinkText AnswerUpdate Customer IdentifierVariable Data TypesData Types OverviewAny (JSON)AssetDetailed AssetBooleanCurrencyDateDateTimeEmailListNullNumberPhoneTextTimeIntegrationsAirtable IntegrationGenesys Widget IntegrationGoogle IntegrationGuidewire IntegrationHubspot IntegrationKustomer IntegrationMX IntegrationPlaid IntegrationSalesforce IntegrationSendGrid IntegrationSFTP IntegrationShopify IntegrationStripe IntegrationTwilio IntegrationZendesk IntegrationQuickstart Sample APIThe Transportation Products APIGET productsgetGET product-by-idgetDELETETo designate a column – that is, an App Object instance – to Delete from Airdata, it must be referred to by its unique __id. Delete Properties Keys to delete Expects type text. The App Object instance to Delete from Airdata. It must be referred to by its unique __id