Astera Data Stack

Version 10

Version 11 Version 10 Version 9 Version 8 Version 7 Version 6

Welcome to Astera Data Stack Documentation
RELEASE NOTES
SETTING UP
DATAFLOWS
WORKFLOWS
Subflows
- Using Subflows in Astera
DATA MODEL
REPORT MODEL
API Flow
- API Publishing
- API Consumption
  - Consume
    API Connection
    Making API Calls with the API Client
    API Browser
    Type 1 – JSON/XML File
    Type 2 – JSON/XML URL
    Type 3 – Import Postman API Collections
    Type 4 - Create or customize API collection
    Pre-built Custom Connectors
    Request Service Options - eTags
    HTTP Redirect Calls
    Method Operations
    Pagination
    Raw Preview And Copy Curl Command
    Support for text/XML and SOAP Protocol
    API Logging
  - Authorize
    Open APIs - Configuration Details
    Authorizing Facebook APIs
    Authorizing Astera’s Server APIs
    Authorizing Avaza APIs
    Authorizing the Square API
    Authorizing the ActiveCampaign API
    Authorizing the QuickBooks’ API
    Astera’s Server API Documentation
    NTLM Authentication
    AWS Signature Authentication
    Accessing Astera’s Server APIs Through a Third-Party Tool
    Workflow Use Case
Project Management and Scheduling
Data Governance
Functions
USE CASES
- End-to-End Use Cases
CONNECTORS
Incremental Loading
- Trigger Based CDC
- Incremental CDC
MISCELLANEOUS
FAQs

Powered by GitBook

© Copyright 2023, Astera Software

On this page

Was this helpful?

String

PreviousSYD NextCenter (String)

Last updated 1 year ago

Center (String)

AddCDATAEnvelope

Concatenate (String)

ContainsAnyChar (String)

Contains (String)

Compact (String)

EndsWith (String)

FindIntStart (Int32)

Extract (String)

GetFindCount (Int64)

FindLast (Int64)

GetDigits (String)

Insert (String)

Length (String)

LeftOf (String)

Mid (String Chars)

LSplit (String)

ReplaceAllSpecialCharsWithSpace

RemoveChars (String str, StringCharsToRemove)

RSplit (String)

SplitStringMultipleRecords

SplitStringMultipleRecords (2 Separators)

SplitString (3 separators)

SplitStringMultipleRecords (3 Separators)

SubString (NoOfChars)

TrimExtraMiddleSpace

PascalCaseWithSpace (String str)

Trim (String str)

ToLower(String str)

ToProper(String str)

ToUpper (String str)

Substring (String str, Integer startAt)

StartsWith (String str, String value)

RemoveAt (String str, Integer startAt, Integer noofChars)

Proper (String str)

Repeat (String str, Integer count)

ReplaceAll (String str, String lookFor, String replaceWith)

ReplaceFirst (String str, String lookFor, String replaceWith)

RightOf (String str, String lookFor)

RemoveChars (String str, String charsToRemove)

SplitString (String str, String separator1, String separator2)