Table of Contents

Search

  1. Preface
  2. Introduction to PowerExchange for Microsoft Azure Blob Storage
  3. PowerExchange for Microsoft Azure Blob Storage Configuration
  4. Microsoft Azure Blob Storage Connections
  5. Microsoft Azure Blob Storage Data Objects
  6. Microsoft Azure Blob Storage Mappings
  7. Data Type Reference

PowerExchange for Microsoft Azure Blob Storage User Guide

PowerExchange for Microsoft Azure Blob Storage User Guide

JSON File Data Types and Transformation Data Types

JSON File Data Types and Transformation Data Types

The following table lists the JSON data types that the Data Integration Service supports and the corresponding transformation data types:
JSON File Data Type
Transformation Data Type
Range and Description
Array
Array
Unlimited number of characters.
Bigint
Bigint
-9,223,372,036,854,775,808 to 9,223,372,036,854,775,807
Precision 19, scale 0
Double
Double
Precision 15
Int
Integer
-2,147,483,648 to 2,147,483,647
Precision 10, scale 0
Object
Struct
Unlimited number of characters.
String
String
1 to 104,857,600 characters

Unsupported JSON Data Types

The Developer tool does not support the following JSON data types:
  • date/timestamp
  • enum
  • union