JSON to AL
Convert JSON files into Microsoft Dynamics 365 Business Central AL objects (Table + List Page + Card Page).
<<<<<<< HEAD
Right-click any .json file in Explorer → EMT: Convert JSON to AL
Command Palette (inside a JSON file) → EMT: Convert JSON to AL
Generates:
- AL Table with inferred field types
- List Page with repeater
- Card Page with General group
Handles nested objects → creates separate related tables with foreign keys
Handles arrays of objects → creates child tables with ParentId + TableRelation
Type inference:
| JSON type |
AL type |
string |
Text[250] |
number (integer) |
Integer |
number (decimal) |
Decimal |
boolean |
Boolean |
"2024-01-15" |
Date |
"2024-01-15T14:30:00Z" |
DateTime |
Output
Files are created in a new folder named after the JSON file:
./<JsonFileName>/
<JsonFileName>.Table.al
<JsonFileName>List.Page.al
<JsonFileName>Card.Page.al
NestedObject.Table.al
NestedObjectList.Page.al
NestedObjectCard.Page.al
...
2409ec8364725ba0f5241e4516ddda216dd1a814
Configuration
| Setting |
Default |
Description |
jsonToAL.baseObjectId |
50100 |
Base object ID (table = base, list = base+1, card = base+2) |
jsonToAL.defaultTextLength |
250 |
Default length for Text fields |
jsonToAL.primaryKeyType |
Code[20] |
PK type: Code[20] ("No.") or Integer ("Entry No.") |
| |
