Correlation File Formats

Input file format

Please provide your correlation files in the following format. For optional content, the column heading must still be present in the csv file.

Column name	Type
ExternalEntitlementId	String
CustomerIdentifier	* String
EntitlementId	* UUID
Status	* String
MerchantAccountKey	String
ProductKey	* String
OfferKey	String
DisplayName	String
CreatedDate	ISO 8601 timestamp string
ActivatedDate	ISO 8601 timestamp string
SuspendedDate	ISO 8601 timestamp string
ResumedDate	ISO 8601 timestamp string
ExpiryDate	ISO 8601 timestamp string
EndDate	ISO 8601 timestamp string

Output file formats

The four output files have the same file format as shown below:

Column name	Description
EntitlementId	Bango’s unique identifier for an entitlement
ExternalEntitlementId	Your unique identifier for an entitlement (if provided)
CorrelationResult	The result of the correlation. Possible values are: OK: Entitlement data matches Error: Extra Entitlement detected in Bango system Error: Missing Entitlement detected in Bango system Error: ProductKey is different Error: Status is different Error: CustomerIdentifier is different Error: Multiple differences