Logo
Home · Centerprise · ReportMiner · EDIConnect · Data Virtualization

Getting Started

  • Centerprise 9 – System Requirements
  • Astera Centerprise – Product Architecture
  • Installing Client and Server Applications
  • How to Install Centerprise Lean Client
  • How to Set up a Server Certificate (.pfx) File in a New Environment
  • Connecting to a Centerprise Server using Lean Client
  • How to Connect to a Different Centerprise Server from the Lean Client
  • How to Build a Cluster Database and Create Repository
  • How to Configure the Server
  • How to Login from Lean Client
  • Licensing Model in Centerprise 9
  • User Roles and Access Control
  • UI Walkthrough - Astera Centerprise 8.0
  • Offline Activation of Astera Centerprise
  • Setting Up R in Astera Centerprise

Sources

  • Data Providers and File Formats Supported in Centerprise
  • Setting Up Sources
  • Excel Workbook Source
  • COBOL File Source
  • Database Table Source
  • Delimited File Source
  • File System Items Source
  • Fixed Length File Source
  • Email Source
  • Report Source
  • SQL Query Source
  • XML/JSON File Source
  • PDF Form Source

Transformations

  • Introducing Transformations
  • Aggregate Transformation
  • Constant Value Transformation
  • Denormalize Transformation
  • Distinct Transformation
  • Expression Transformation
  • Filter Transformation
  • Join Transformation
  • List Lookup Transformation
  • Merge Transformation
  • Normalize Transformation
  • Passthru Transformation
  • Reconcile Transformation
  • Route Transformation
  • Sequence Generator
  • Sort Transformation
  • Sources as Transformations
  • Subflow Transformation
  • Switch Transformation
  • Tree Join Transformation
  • Using the Tree Join Transformation
  • Tree Transform
  • Union Transformation
  • Data Cleanse Transformation
  • File Lookup Transformation
  • SQL Statement Lookup
  • Database Lookup

Destinations

  • Setting Up Destinations
  • Database Table Destination
  • Delimited File Destination
  • Excel Workbook Destination
  • Fixed Length File Destination
  • SQL Statement Destination
  • XML File Destination

Data Logging and Profiling

  • Creating Data Profile
  • Creating Field Profile
  • Data Quality Mode
  • Using Data Quality Rules in Astera Centerprise
  • Record Level Log

Workflow

  • What are Workflows?
  • Decision
  • EDI Acknowledgment
  • File System
  • File Transfer
  • OR
  • Run Dataflow
  • Run Program
  • Run SQL File
  • Run SQL Script
  • Run Workflow
  • Send Mail
  • Creating Workflows in Astera Centerprise
  • Workflows with a Dynamic Destination Path
  • Customizing Workflows With Parameters
  • GPG-Integrated File Decryption in Astera Centerprise

Subflow

  • Using Subflow in Astera Centerprise

Database Write Strategies

  • Database Write Strategies
  • Data Driven
  • Source Diff Processor
  • Database Diff Processor

Testing and Diagnostics

  • Pre-Analytics Testing
  • Correlation Analysis

Analytical Models

  • Time Series Smoothing
  • Linear Regression

Visualization

  • Basic Plots
  • Distribution Plots

Text Processors

  • Delimited Parser
  • Delimited Serializer
  • Language Parser
  • Fixed Length Parser
  • Fixed Length Serializer
  • XML/JSON Parser
  • XML/JSON Serializer

Connectors

  • Setting Up IBM DB2/iSeries Connectivity in Centerprise
  • Connecting to SAP HANA Database
  • Connecting to MariaDB Database
  • Connecting to Salesforce Database
  • Connecting to Salesforce – Legacy Database
  • Connecting to Vertica Database
  • Connecting to Snowflake Database
  • Connecting to Amazon Redshift Database
  • Connecting to Amazon Aurora Database
  • Connecting to Google Cloud SQL in Astera Centerprise
  • Connecting to MySQL Database
  • Connecting to PostgreSQL in Astera Centerprise
  • Connecting to Netezza Database
  • Connecting to Oracle Database
  • Connecting to Microsoft Azure Databases
  • Connecting to Amazon RDS Databases

Project Management

  • Deployment
  • Server Monitoring and Job Management
  • Connecting to Source Control
  • Centerprise Project and Project Explorer

Web Services

  • REST Connection
  • Making API Calls with the REST Client Object in Astera Centerprise
  • REST API Browser
  • Method Operations
  • Pagination
    • Offset
    • Cursor
    • Next URL
    • Page Number
  • Open APIs – Configuration Details
  • Authorizing Facebook APIs in Astera Centerprise
  • Authorizing Centerprise’s Server APIs
  • Authorizing Avaza APIs in Astera Centerprise
  • Authorizing Square API in Astera Centerprise
  • Authorizing ActiveCampaign API in Astera Centerprise
  • Authorizing QuickBooks’ API in Astera Centerprise
  • Accessing Centerprise’s Server APIs Through a Third-Party Tool
  • Centerprise’s Server API Documentation

Miscellaneous

  • Using Dynamic Layout/Template Mapping in Astera Centerprise
  • Synonym Dictionary File
  • SmartMatch Feature
  • Scheduling Jobs on the Server
  • Job Monitor
  • Role-Based Access Control in Astera Centerprise
  • Astera Centerprise – What’s New in Version 7 and Version 8
  • Updating Your License in Astera Centerprise
  • Deploying Astera Centerprise on Microsoft Azure Cloud
  • Deploying Astera Centerprise on Oracle Cloud
  • Using Output Variables in Astera Centerprise
  • Connection Vault
  • Safe Mode
  • Using the Data Source Browser in Astera Centerprise
  • Pushdown Mode

Use Cases

  • Using Astera Centerprise to Create and Orchestrate an ETL Process for Partner Onboarding

Resources

  • Context Information
Centerprise
  • »
  • Pagination

Pagination¶

Pagination refers to managing the traffic of records coming from a source. It divides the records into a discrete number of pages so that they are comprehensible for a user. Pagination is not supported by all APIs. For those that do support it, Astera Centerprise offers four types of pagination.

Offset¶

This type of pagination requires two parameters: a limit and an offset value to be specified by the user. A limit specifies the number of records that you want to specify in one page and an offset simply tells the number of records to be skipped before selecting records.

Initial Offset: The record from which you want to start your pagination.

Number of Pages: The number of pages which you want to be processed.

Limit: Number of records on one page.

Offset Parameter: Here, you specify the offset parameter of the API that you are working with, as specified on the Parameters screen.

Limit Parameter: Here, you specify the limit parameter of the API that you are working with, as specified on the Parameters screen.

01-Offset-Pagination

Cursor¶

This type of pagination generates a token for the next page of records. You can set a limit to the number of pages you want to process.

Cursor Field: Here, you can specify the field you want to attach your cursor with.

Number of Pages: Here, you can specify the number of pages you want to see in your output, or you can simply check the ‘Read till End’ option if you want to process all the records without any limit.

Cursor Parameter: Here, you can specify the cursor parameter of the API that you are working with, as specified on the Parameters screen.

02-Cursor-Pagination-GET

Next URL¶

This type is the same as Cursor pagination, except that it generates a URL instead of a token for every subsequent page.

Next URL Field: Here, you can specify the field you want to attach your URL with.

Number of Pages: Here, you can specify the number of pages you want to see in your output, or you can simply check the ‘Read Till End’ option if you want to process all the records without any limit.

03-Next-URL-Pagination-GET

Page Number¶

In this type of pagination, you can specify the number of pages you would like to fetch in one go. It requires two parameters:

Start Page Number: The page number from where you want to start fetching your output, or the lower limit.

End Page Number: The page number where you want to end.

Page Number Parameter: Here, you can specify the page number parameter of the API that you are working with, as specified on the Parameters screen.

04-Page-Number-Pagination-GET

This concludes our discussion of pagination for APIs in Astera Centerprise.


© Copyright 2021, Astera Software

Versions & Downloads v: 9
Versions
9
8
7
6
Downloads
pdf
On Read the Docs
Project Home
Builds