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 FunctionsKEYSVALUESMERGE_OBJECTSMath 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 FunctionsTHROWTRYArithmetic OperatorsAddition (+)Subtraction (-)Multiplication (*)Division (/)Remainder (%)Comparison OperatorsEquality (=)Inequality (<>, !=)Ordering (<, <=, > , >=)Logical OperatorsANDORXORNull Coalescing Operator (??)Advanced ExpressionsLET...INUser Defined FunctionsWeb ControlsButtonCheckboxSimple Checkbox ListContainerContainer ListCredit CardCurrency InputDate InputDate PickerDropdown ListEmail InputEmbedded External Content (iFrame)Fieldset ContainerFile UploadHyperlinkImageInline ContainerLabelMapNumber InputPayment Request ButtonPhone InputPlace Search InputProgress BarRadio ButtonSimple Radio ListSchedulerSecure String InputSelectable ContainerSignature InputText AreaText InputTime InputWeb FlowWeb PageQR CodeVoice and Chat ControlsDecision MenuForward CallSecure Touchtone CaptureText Response CaptureTouchtone CaptureData OperationsData Operation OverviewAirData RequestDELETEPUTINSERTPATCHQUERYDEPRECATED_QUERYCalendar SearchCreate FileDelete AssetsDownload Encoded AssetEarly ReturnFetch Asset DetailsFill PDF FormGoogleHTML to PDFHTTP RequestUsing an API With PagingJWT GenerationMerge PDFRun Data FlowRun Event in JourneySalesforceSecure Value RetrievalSend EmailSFTPStart JourneySwagger Schema ValidationTransformWaitXML 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 TimerThrowTryVariable Data TypesData Types OverviewAny (JSON)AssetDetailed AssetBooleanCurrencyDateDateTimeEmailListNullNumberPhoneTextTimeCustom Data TypesIntegrationsAirtable 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