No Code API Consumption platform

Simplifies the complexities in parsing JSON & XML structures.

Request Engine

Convert Relational tables to JSON/XML/API in few clicks.

Response Engine

Convert JSON/XML/API to Relational tables in few clicks.

ERD Engine

Dashboards & Job Logs to view the complete run statistics.

Productivity

Reduce Development effort for API Consumption process (touch it & take it approach) by 95%

Technology Compatibility

API Finz Modules are exposed as secured REST APIs which are compatible with Enterprise
Schedulers, iPAAS platforms, POSTMAN and Web Applications

Execution Stats

Dashboards & Job Logs to view the complete run statistics

Features

REQUEST

  • Generate JSON/XML structures from structured data.
  • Input data can be Tables, Views or Flat Files.
  • Limit the number of objects to be created for POST.

RESPONSE

  • Converts Complex JSON/XML structures to structured format in few clicks.
  • Can Flatten or Normalize unstructured data.
  • Complex Arrays and Objects can be converted in few clicks.

CONNECTIONS

  • Direct API Connects with advanced authentication methods.
  • Handle Pagination & Parameters in API operations.
  • Easy Connections to RDBMS & Cloud storages.

SCHEDULER & DASHBOARDS

  • Scheduler to execute the API Integrations on defined frequencies.
  • Dashboards to analyze the usage.
  • Detailed reports on the conversions.

How it works

APIFINZ - How it Works

Solutions

Slide Structured Files 1.Parse the REST API Response to Flat Files Structured files (delimited files)
with the relationship key Model : Generate ERD from REST API metadata
Schedule the process

 REST API JSON Data with complex arrays in one object File Storage can be in AWS S3 or Azure Blob or Data Lake or On-Prem
 Each Array in JSON is created as a Child table with a relation key to the Parent table

 Parses REST API Response with Authentications & creates structured data in RDBMS Tables
Integrate : Build Pipeline
Connect : Configure REST API & File Storage Connections
 Slide Tables 2.Parse the REST API Response to Tables Structured data loaded to the
multiple related Tables Model : Generate ERD from REST API metadata
Schedule the process


 REST API JSON Data with complex arrays in one object Tables can be any RDBMS in On-Prem or Cloud
 Each Array in JSON is created as a Child table with a relation key to the Parent table

 Parses REST API Response with Authentications & creates structured data in RDBMS Tables Integrate : Build Pipeline
Connect : Configure REST API & RDBMS (JDBC) Connections
 Slide REST API 3. Build JSON Payload & Perform the REST API Request from the Tables JSON Data with complex arrays in one object
 Model : Generate ERD from REST API metadata
Schedule the process

 Tables Structured Data in multiple related tables Tables can be any RDBMS in On-Prem or Cloud
 Each related table is created as an Array in JSON object
 Converts the structured tables to JSON Payload & performs REST API Request with

authentication Integrate : Build Pipeline
Connect : Configure REST API & RDBMS (JDBC) Connections
 Slide REST API 4. Build JSON Payload & Perform the REST API Request from the Flat Files JSON Data with complex
arrays in one object
 Model : Generate ERD from REST API metadata Schedule the process

 Structured Files Structured Data in multiple related Flat Files File Storage can be in AWS S3 or Azure Blob or Data Lake or On-Prem Each related Flat File is created as an Array in JSON object
 Converts the structured files to JSON Payload & performs REST API Request with
authentication Integrate : Build Pipeline
Connect : Configure REST API & File Storage Connections
 Slide Semi-Structured Files 5. Convert the Structured Tables to JSON or XML JSON or XML files with the complex
 arrays in one object
Tables can be any RDBMS in On-Prem or Cloud Model : Generate ERD from JSON or XML template Schedule the process

 Tables Structured Data in multiple related Flat Files File Storage can be in AWS S3 or Azure Blob or Data Lake or On-Prem Each related table is created as an Array in JSON object
 Converts the structured tables to JSON or XML files & stores in File Storage Integrate : Build Pipeline
Connect : Configure File Storage Connection & RDBMS (JDBC) Connection
 Slide Semi-Structured Files 6. Convert the Structured Files to JSON or XML JSON or XML files with the complex
arrays in one object
 Model : Generate ERD from JSON or XML template Schedule the process

 Structured Files Structured Data in multiple related Flat Files File Storage can be in AWS S3 or Azure Blob or Data Lake or On-Prem Each related table is created as an Array in JSON object
 Converts the structured files to JSON or XML files & stores in File Storage Integrate : Build Pipeline
Connect : Configure File Storage Connections Slide Flat Files 7. Parse the JSON/XML Files to Flat Files Structured files (delimited files)
with the relationship key
 Model : Generate ERD from JSON or XML template Schedule the process

 Semi-Structured Files JSON or XML files with the complex arrays in one object File Storage can be in AWS S3 or Azure Blob or Data Lake or On-Prem Each Array in JSON or XML is created as new Child File with a relation key to the

Parent File Parses JSON or XML files and creates structured files in File Storage Integrate : Build Pipeline
Connect : Configure File Storage Connections Slide Tables 8. Parse the JSON/XML Files to Tables Structured data loaded to the multiple related tables Tables can be any RDBMS in On-Prem or Cloud Model : Generate ERD from JSON or XML template Schedule the process

 Semi-Structured Files JSON or XML files with the complex arrays in one object File Storage can be in AWS S3 or Azure Blob or Data Lake or On-Prem Each Array in JSON or XML is created as a Child table with a relation key to

the Parent table Parses JSON or XML files and creates structured files in File Storage Integrate : Build Pipeline
Connect : Configure File Storage Connection & RDBMS (JDBC) Connection Slide Azure 9. Data Copy from AWS to Azure Unstructured files in AWS Unstructured files in Azure Structured, Semi-Structured and Schedule the process

 AWS Structured, Semi-Structured and File Storage can be in AWS S3 or Azure Blob or Data Lake or On-Prem Copy the Files from AWS to Azure Integrate : Build Pipeline
Connect : Configure File Storage Connections Slide AWS 10. Data Copy from Azure to AWS Structured, Semi-Structured and Schedule the process

Unstructured files in Azure Unstructured files in AWS Azure Structured, Semi-Structured and File Storage can be in AWS S3 or Azure Blob or Data Lake or On-Prem Copy the Files from Azure to AWS Integrate : Build Pipeline
Connect : Configure File Storage Connections Slide Data Lake 11. Replicate Tables to Data Lake Structured files (csv or tab) Tables can be any RDBMS in On-Prem or Cloud Schedule the process

 Tables Structured data in the multiple
related tables Data Lake can be in AWS or Azure Copy the Files from Azure to AWS Integrate : Build Pipeline
Connect : Configure RDBMS (JDBC) Connection and Data Lake Connection

Demo Videos

CONNECTION FTP Connection
Method SFTP Connection
Method Rest API - Key
Connection Method Database Connection
Method Rest API - Dynamic
Variable
Connection Method Azure Blob Storage
Connection Method Azure Data Lake
Storage Connection
Method AWS S3 Connection
Method Rest OAUTH 2.0 JWT
Connection Method Rest API - OAUTH 2.0
Client Credentials
Connection Method Rest API - No Auth
Connection Method Rest API Rest API - Basic Auth
Connection Method MODEL Model Generation from
REST End Point Model Generation from
JSON File INTEGRATION Table Replication to
Data Lake Response - Advance
Features Simple Response Request- Advance
Features Simple Request Convert to Table and
File to JSON or XML Files Copy into
Data Lake

Pricing Catalog

Slide PRICING PRICING Generate ERD, Templates Connections Integration Integration Run Accounts Usage FEATURES CONTACT US Support 100 1000 100 10 Email 5 Users *Dedicated Email/Phone Call STANDARD Email/Phone Call CONTACT US 5000 500 50 10 Users *Dedicated PRO CONTAC T US 500 ENTERPRISE Unlimited *Dedicated Unlimited Email/Phone Call Unlimited Unlimited Unlimited