Articles in this section

See more

EDI to JSON

Avatar
Admin
  • Updated
Follow

Exporting or importing EDI to or from JSON

The quickest method of converting between JSON text and a .NET object is using the JsonSerializer. For full examples download the SDK.

Export EDI to JSON using Netonsoft's Json.Net

//  Read EDI file
List ediItems;
using (var ediReader = new X12Reader(ediStream, factory))
    ediItems = ediReader.ReadToEnd().ToList();

//  Pull all EDI objects
var transactions = ediItems.OfType<TS850>();

//  Serialize each EDI object to JSON
foreach (var transaction in transactions)
    var json = Newtonsoft.Json.JsonConvert.SerializeObject(transaction);

Export EDI to JSON using Microsoft's JavaScriptSerializer

//  Read EDI file
List ediItems;
using (var ediReader = new X12Reader(ediStream, factory))
    ediItems = ediReader.ReadToEnd().ToList();

//  Pull all EDI objects
var transactions = ediItems.OfType<TS850>();

//  Serialize each EDI object to JSON
foreach (var transaction in transactions)
    var json = new JavaScriptSerializer().Serialize(transaction);

Import EDI from JSON using Netonsoft's Json.Net

//  Read JSON string
var ediJson = File.OpenRead(@"C:\PurchaseOrder.json").LoadToString();

//  Deserialize to EDI object
var transaction = Newtonsoft.Json.JsonConvert.DeserializeObject<TS850>(ediJson);

Import EDI from JSON using Microsoft's JavaScriptSerializer

// Read JSON string
var ediJson = File.OpenRead(@"C:\PurchaseOrder.json").LoadToString();

// Deserialize to EDI object
var transaction = new JavaScriptSerializer().Deserialize<TS850>(ediJson);

Sample JSON String

{
	"ST": {
		"TransactionSetIdentifierCode_01": "850",
		"TransactionSetControlNumber_02": "0001",
		"ImplementationConventionPreference_03": null
	},
	"BEG": {
		"TransactionSetPurposeCode_01": "00",
		"PurchaseOrderTypeCode_02": "SA",
		"PurchaseOrderNumber_03": "XX-1234",
		"ReleaseNumber_04": null,
		"Date_05": "20170301",
		"ContractNumber_06": null,
		"AcknowledgmentType_07": "NA",
		"InvoiceTypeCode_08": null,
		"ContractTypeCode_09": null,
		"PurchaseCategory_10": null,
		"SecurityLevelCode_11": null,
		"TransactionTypeCode_12": null
	},
	"CUR": null,
	"REF": null,
	"PER": [{
		"ContactFunctionCode_01": "BD",
		"Name_02": "ED SMITH",
		"CommunicationNumberQualifier_03": "TE",
		"CommunicationNumber_04": "8001234567",
		"CommunicationNumberQualifier_05": null,
		"CommunicationNumber_06": null,
		"CommunicationNumberQualifier_07": null,
		"CommunicationNumber_08": null,
		"ContactInquiryReference_09": null
	}],
	"TAX": [{
		"TaxIdentificationNumber_01": "53247765",
		"LocationQualifier_02": "SP",
		"LocationIdentifier_03": "CA",
		"LocationQualifier_04": null,
		"LocationIdentifier_05": null,
		"LocationQualifier_06": null,
		"LocationIdentifier_07": null,
		"LocationQualifier_08": null,
		"LocationIdentifier_09": null,
		"LocationQualifier_10": null,
		"LocationIdentifier_11": null,
		"TaxExemptCode_12": "9",
		"CustomsEntryTypeGroupCode_13": null
	}],
	"FOB": null,
	"CTP": null,
	"PAM": null,
	"CSH": null,
	"TC2": null,
	"SACLoop": null,
	"ITD": null,
	"DIS": null,
	"INC": null,
	"DTM": null,
	"LDT": null,
	"LIN": null,
	"SI": null,
	"PID": null,
	"MEA": null,
	"PWK": null,
	"PKG": null,
	"TD1": null,
	"TD5": null,
	"TD3": null,
	"TD4": null,
	"MAN": null,
	"PCT": null,
	"CTB": null,
	"TXI": null,
	"AMTLoop": null,
	"N9Loop": null,
	"N1Loop": [{
		"N1": {
			"EntityIdentifierCode_01": "BY",
			"Name_02": "ABC AEROSPACE",
			"IdentificationCodeQualifier_03": "9",
			"IdentificationCode_04": "1234567890101",
			"EntityRelationshipCode_05": null,
			"EntityIdentifierCode_06": null
		},
		"N2": [{
			"Name_01": "AIRCRAFT DIVISION",
			"Name_02": null
		}],
		"N3": [{
			"AddressInformation_01": "2000 JET BLVD",
			"AddressInformation_02": null
		}],
		"N4": [{
			"CityName_01": "FIGHTER TOWN",
			"StateorProvinceCode_02": "CA",
			"PostalCode_03": "98898",
			"CountryCode_04": null,
			"LocationQualifier_05": null,
			"LocationIdentifier_06": null
		}],
		"NX2": null,
		"REF": null,
		"PER": null,
		"SI": null,
		"FOB": null,
		"TD1": null,
		"TD5": null,
		"TD3": null,
		"TD4": null,
		"PKG": null
	}],
	"LMLoop": null,
	"SPILoop": null,
	"ADVLoop": null,
	"PO1Loop": [{
		"PO1": {
			"AssignedIdentification_01": "1",
			"QuantityOrdered_02": "25",
			"UnitorBasisforMeasurementCode_03": "EA",
			"UnitPrice_04": "36",
			"BasisofUnitPriceCode_05": "PE",
			"ProductServiceIDQualifier_06": "MG",
			"ProductServiceID_07": "XYZ-1234",
			"ProductServiceIDQualifier_08": null,
			"ProductServiceID_09": null,
			"ProductServiceIDQualifier_10": null,
			"ProductServiceID_11": null,
			"ProductServiceIDQualifier_12": null,
			"ProductServiceID_13": null,
			"ProductServiceIDQualifier_14": null,
			"ProductServiceID_15": null,
			"ProductServiceIDQualifier_16": null,
			"ProductServiceID_17": null,
			"ProductServiceIDQualifier_18": null,
			"ProductServiceID_19": null,
			"ProductServiceIDQualifier_20": null,
			"ProductServiceID_21": null,
			"ProductServiceIDQualifier_22": null,
			"ProductServiceID_23": null,
			"ProductServiceIDQualifier_24": null,
			"ProductServiceID_25": null
		},
		"LIN": null,
		"SI": null,
		"CUR": null,
		"CN1": null,
		"PO3": null,
		"CTPLoop": null,
		"PAM": null,
		"MEA": [{
			"MeasurementReferenceIDCode_01": "WT",
			"MeasurementQualifier_02": "WT",
			"MeasurementValue_03": "10",
			"CompositeUnitofMeasure_04": {
				"UnitorBasisforMeasurementCode_01": "OZ",
				"Exponent_02": null,
				"Multiplier_03": null,
				"UnitorBasisforMeasurementCode_04": null,
				"Exponent_05": null,
				"Multiplier_06": null,
				"UnitorBasisforMeasurementCode_07": null,
				"Exponent_08": null,
				"Multiplier_09": null,
				"UnitorBasisforMeasurementCode_10": null,
				"Exponent_11": null,
				"Multiplier_12": null,
				"UnitorBasisforMeasurementCode_13": null,
				"Exponent_14": null,
				"Multiplier_15": null
			},
			"RangeMinimum_05": null,
			"RangeMaximum_06": null,
			"MeasurementSignificanceCode_07": null,
			"MeasurementAttributeCode_08": null,
			"SurfaceLayerPositionCode_09": null,
			"MeasurementMethodorDevice_10": null
		}],
		"PIDLoop": null,
		"PWK": null,
		"PO4": null,
		"REF": null,
		"PER": null,
		"SACLoop": null,
		"IT8": {
			"SalesRequirementCode_01": null,
			"ActionCode_02": null,
			"Amount_03": null,
			"AccountNumber_04": null,
			"Date_05": null,
			"AgencyQualifierCode_06": null,
			"ProductServiceSubstitutionCode_07": "B0",
			"ProductServiceIDQualifier_08": null,
			"ProductServiceID_09": null,
			"ProductServiceIDQualifier_10": null,
			"ProductServiceID_11": null,
			"ProductServiceIDQualifier_12": null,
			"ProductServiceID_13": null,
			"ProductServiceIDQualifier_14": null,
			"ProductServiceID_15": null,
			"ProductServiceIDQualifier_16": null,
			"ProductServiceID_17": null,
			"ProductServiceIDQualifier_18": null,
			"ProductServiceID_19": null,
			"ProductServiceIDQualifier_20": null,
			"ProductServiceID_21": null,
			"ProductServiceIDQualifier_22": null,
			"ProductServiceID_23": null,
			"ProductServiceIDQualifier_24": null,
			"ProductServiceID_25": null,
			"ProductServiceIDQualifier_26": null,
			"ProductServiceID_27": null
		},
		"CSH": null,
		"ITD": null,
		"DIS": null,
		"INC": null,
		"TAX": null,
		"FOB": null,
		"SDQ": null,
		"IT3": null,
		"DTM": null,
		"TC2": null,
		"TD1": null,
		"TD5": null,
		"TD3": null,
		"TD4": null,
		"PCT": null,
		"MAN": null,
		"MSG": null,
		"SPI": null,
		"TXI": null,
		"CTB": null,
		"QTYLoop": null,
		"SCHLoop": [{
			"SCH": {
				"Quantity_01": "25",
				"UnitorBasisforMeasurementCode_02": "EA",
				"EntityIdentifierCode_03": null,
				"Name_04": null,
				"DateTimeQualifier_05": "106",
				"Date_06": "20170615",
				"Time_07": null,
				"DateTimeQualifier_08": null,
				"Date_09": null,
				"Time_10": null,
				"RequestReferenceNumber_11": null,
				"AssignedIdentification_12": null
			},
			"TD1": null,
			"TD5": null,
			"TD3": null,
			"TD4": null,
			"REF": null
		}],
		"PKGLoop": null,
		"LSLoop": null,
		"N9Loop": null,
		"N1Loop": null,
		"SLNLoop": null,
		"AMTLoop": null,
		"LMLoop": null
	}],
	"CTTLoop": {
		"CTT": {
			"NumberofLineItems_01": "1",
			"HashTotal_02": null,
			"Weight_03": null,
			"UnitorBasisforMeasurementCode_04": null,
			"Volume_05": null,
			"UnitorBasisforMeasurementCode_06": null,
			"Description_07": null
		},
		"AMT": {
			"AmountQualifierCode_01": "TT",
			"MonetaryAmount_02": "900",
			"CreditDebitFlagCode_03": null
		}
	},
	"SE": {
		"NumberofIncludedSegments_01": "15",
		"TransactionSetControlNumber_02": "0001"
	},
	"Name": "850",
	"Version": "004010",
	"Format": "X12",
	"SplitterProperty": null,
	"PartsCount": 0,
	"IsPart": false,
	"SplitPostion": 0,
	"HasErrors": false,
	"ErrorContext": {
		"Name": "850",
		"ControlNumber": "0001",
		"Version": "004010",
		"Codes": [],
		"Errors": [],
		"HasErrors": false,
		"Message": null
	}
}

Related articles

Comments

0 comments

Please sign in to leave a comment.