Astera Data Stack

Version 11

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

Welcome to Astera Data Stack Documentation
RELEASE NOTES
SETTING UP
Astera Intelligence (Coming Soon!)
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?

Date Time

PreviousSplitString (String str, String separator1, String separator2)NextAddMinutes (DateTime)

AddMinutes (DateTime)

AddDays (DateTimeOffset)

AddDays (DateTime)

AddHours (DateTime)

AddSeconds (DateTime)

AddMonths (DateTime)

AddMonths (DateTimeOffset)

AddMinutes (DateTimeOffset)

AddSeconds (DateTimeOffset)

AddYears (DateTimeOffset)

AddYears (DateTime)

Age (DateTimeOffset)

CharToSeconds (Str)

DateDifferenceDays (DateTimeOffset)

DateDifferenceDays (DateTime)

DateDifferenceHours (DateTimeOffset)

DateDifferenceHours (DateTime)

DateDifferenceMonths (DateTimeOffset)

DateDifferenceMonths (DateTime)

DatePart (DateTimeOffset)

DatePart (DateTime)

DateDifferenceYears (DateTimeOffset)

DateDifferenceYears (DateTime)

Month (DateTime)

Month (DateTimeOffset)

Quarter (DateTime)

Quarter (DateTimeOffset)

Second (DateTime)

Second (DateTimeOffset)

SecondsToChar (String)

TimeToInteger (DateTime)

TimeToInteger (DateTimeOffset)

ToDate Date (DateTime)

ToDate DateTime (DateTime)

ToDateString (DateTime)

ToDateTimeOffset-Date (DateTimeOffset)

ToDate DateTime (DateTimeOffset)

ToDateString (DateTimeOffset)

ToLocal (DateTime)

ToJulianDate (DateTime)

ToJulianDayNumber (DateTime)

ToTicks (Date dateTime)

ToTicks (DateTimeWithOffset dateTime)

ToUnixEpoc (Date dateTime)

ToUtc (Date dateTime)

UnixTimeStampToDateTime (Real unixTimeStamp)

Week (Date dateTime)

Week (DateTimeWithOffset dateTime)

Year (Date dateTime)

Year (DateTimeWithOffset dateTime)

DateToJulian (Date dateTime, Integer length)

DateTimeOffsetUtcNow ()

DateTimeOffsetNow ()

Day (DateTimeWithOffset dateTime)

Day (Date dateTime)

DayOfWeekStr (DateTimeWithOffset dateTime)

DayOfWeek (DateTimeWithOffset dateTime)

DayOfWeek (Date dateTime)

DateToJulian (DateTimeWithOffset dateTime, Integer length)

DayOfWeekStr (Date dateTime)

FromJulianDate (Real julianDate)

DayOfYear (Date dateTime)

DaysInMonth(Integer year, Integer month)

DayOfYear (DateTimeWithOffset dateTime)

FromJulianDayNumber (Integer julianDayNumber)

FromTicksUtc(Integer ticks)

FromTicksLocal(Integer ticks)

Hour (Date dateTime)

Hour (DateTimeWithOffset dateTime)

Minute (Date dateTime)

JulianToDate (String julianDate)

Minute (DateTimeWithOffset dateTime)

DateToIntegerYYYYMMDD (DateTimeWithOffset dateTime)

DateToIntegerYYYYMMDD (Date dateTime)