x
Mart
Docs
Pipeline Script Guide
|
Back to site ⤴
General
Submenu
Overview of xMart
Navigate to mart
Architecture of xMart
Tutorials
Submenu
1. Simple REPLACE
2. Simple MERGE
3. Model Validation
4. Custom Business Rules
5. Global Transformations
6. Table-Specific Transforms
7. Foreign Keys
Release Notes
Submenu
Version 4.29
Version 4.28
Version 4.27
Version 4.26
Version 4.25
Version 4.24
Version 4.23
Version 4.22
Version 4.21
Version 4.20
Version 4.19
Version 4.18
How Tos
Data Catalog
Submenu
Create Categories
Register Custom Views
Data Editing
Submenu
Read Data
Edit data in UI
Download Data
Upload data from Excel
Data Loading
Submenu
Data Load
Exclude some rows
Ignore Lookup Issues
Data Load History
Truncate a Table
Notifications
Export Staged Data
Resolve Lookups
Data Modeling
Submenu
Data Modelling Basics
How to create tables
Best Practices
Data to model
Edit model via Excel template
Edit model via UI
Creating a Model from SQL Server
Hard Delete Tables and Fields
Change FK Table
Centralized Business Rules
Pipelines - Basics
Submenu
Introduction to Pipelines
Writing Normal Pipelines
Writing Flow Pipelines
Use Variables
Test and debug a pipeline
Set up batch approval
Pipelines - Extract
Submenu
Process Data View Rows
Call ArcGis API
Call DHIS API
Call Excel Online (via Graph Explorer)
Call GoogleSheet API
Call ODK Central API
Consume Excel file stored on SharePoint Site
Consume data from a SharePoint List
Consume data from MS Word Forms
Pipelines - Transform
Submenu
Country to ISO3
Use the HierarchyLookup command
Resolve Lookups in UI
Data Forms
Submenu
Data Entry Forms
Standard Forms
Custom Forms
SubForms
Custom Views
Submenu
Create Custom Views
SQL FAQs
Optimize Custom Views
Custom Views in xMart UI
Xmart Api
Submenu
Introduction to xMart API
OData API
Trigger Pipeline API
Register client app
Consume OData in Postman
Consume OData in R
Consume OData in Excel
Consume OData in PowerBI
Security
Submenu
Create Roles
Change Permissions
Add Users
Choose Active Roles
Row-level Security
Deploy
Submenu
Export Mart
Import Mart
Sys Admin
Submenu
Edit the Mart Information
Write a HowTo
Create a mart
Delete a mart
Architecture of xMart
Architecture
Jump to Section