Getting Indentation Error in JSON Structure - Need Help (How to Normalize Complex Nested JSON Data )

Patel0786 — Fri, 24 Jan 2025 12:37:14 GMT

Hello everyone,

I’m working with a JSON structure, but I’m encountering an indentation error when trying to process the following JSON data. I’ve double-checked for proper alignment and syntax, but I still can’t figure out the issue. Could anyone please help me identify why the error is happening?

Here's the JSON output schema:

[
{
"name": "output",
"type": "array",
"of": "object",
"label": "Output",
"properties": [
{
"control_type": "number",
"label": "Supplier Node URL ID",
"parse_output": "integer_conversion",
"type": "integer",
"name": "Supplier_Node_URL_ID"
},
{
"control_type": "text",
"label": "Supplier Node URL",
"type": "string",
"name": "Supplier_NodeURL"
},
{
"control_type": "text",
"label": "Supplier Node Name",
"type": "string",
"name": "Supplier_Node_Name"
},
{
"control_type": "text",
"label": "Supplier State",
"type": "string",
"name": "Supplier_maiState"
},
{
"control_type": "text",
"label": "Local Supplier Name",
"type": "string",
"name": "Supplier_maiLocalSuppliername"
},
{
"control_type": "text",
"label": "Supplier PLM ID",
"type": "string",
"name": "Supplier_maiPLMID"
},
{
"control_type": "text",
"label": "Supplier Group Name",
"type": "string",
"name": "Supplier_maiGroupName"
},
{
"control_type": "text",
"label": "Is Agent",
"type": "string",
"name": "Supplier_IsAgent"
},
{
"control_type": "text",
"label": "Is Warehouse",
"type": "string",
"name": "Supplier_IsWarehouse"
},
{
"control_type": "text",
"label": "Is Factory",
"type": "string",
"name": "Supplier_maiIsFactory"
},
{
"control_type": "text",
"label": "Business License Registration Number",
"type": "string",
"name": "Supplier_maiLocalBussinessLicenseRegistrationNumber"
},
{
"control_type": "text",
"label": "Business License Expiry Date",
"type": "string",
"name": "Supplier_maiExpiryDateBussinessLicense"
},
{
"control_type": "text",
"label": "Supplier Product Class",
"type": "string",
"name": "Supplier_maiSupplierProductClass"
},
{
"control_type": "text",
"label": "Business Address",
"type": "string",
"name": "Supplier_maiBussinessAddress"
},
{
"control_type": "text",
"label": "City",
"type": "string",
"name": "Supplier_maiCity"
},
{
"control_type": "text",
"label": "Province/State",
"type": "string",
"name": "Supplier_maiProvinceState"
},
{
"control_type": "text",
"label": "Postal Code",
"type": "string",
"name": "Supplier_maiPostalCode"
},
{
"control_type": "text",
"label": "Country Node Name",
"type": "string",
"name": "Supplier_Country_NodeName"
},
{
"control_type": "text",
"label": "Local Language Business Address",
"type": "string",
"name": "Supplier_maiLocalLangBusinessAddress"
},
{
"control_type": "text",
"label": "Local Language City",
"type": "string",
"name": "Supplier_maiLocalLanguageCity"
},
{
"control_type": "text",
"label": "Local Language Province",
"type": "string",
"name": "Supplier_maiLocallanguageProvince"
},
{
"control_type": "number",
"label": "Local Language Country",
"parse_output": "integer_conversion",
"type": "integer",
"name": "Supplier_maiLocalLanguageCountry"
},
{
"control_type": "text",
"label": "Phone Number",
"type": "string",
"name": "Supplier_PhoneNumber"
},
{
"control_type": "text",
"label": "Email",
"type": "string",
"name": "Supplier_Email"
},
{
"control_type": "text",
"label": "Classification",
"type": "string",
"name": "Supplier_Classification"
},
{
"control_type": "text",
"label": "Classification Sub Type",
"type": "string",
"name": "maiClassificationSubType"
},
{
"control_type": "text",
"label": "Currency",
"type": "string",
"name": "Supplier_Currency"
},
{
"control_type": "number",
"label": "VAT",
"parse_output": "integer_conversion",
"type": "integer",
"name": "Supplier_maiVAT"
},
{
"control_type": "text",
"label": "Payment Term",
"type": "string",
"name": "Supplier_PaymentTerm"
},
{
"control_type": "text",
"label": "Trade Term",
"type": "string",
"name": "Supplier_TradeTerm"
},
{
"control_type": "text",
"label": "Contact Person Agent",
"type": "string",
"name": "Supplier_maiContactPersonAgent"
},
{
"control_type": "text",
"label": "Agent Salutation Name",
"type": "string",
"name": "Supplier_maiAgentSalutationName"
},
{
"control_type": "text",
"label": "Bank Key",
"type": "string",
"name": "Supplier_maiBankKey"
},
{
"control_type": "text",
"label": "Bank Account Number",
"type": "string",
"name": "Supplier_maiBankaccountnumber"
},
{
"name": "Contact",
"type": "array",
"of": "object",
"label": "Contact",
"properties": [
{
"control_type": "text",
"label": "Contact_maiPLMID",
"type": "string",
"name": "Contact_maiPLMID"
},
{
"control_type": "text",
"label": "Contact_NodeURL",
"type": "string",
"name": "Contact_NodeURL"
},
{
"control_type": "text",
"label": "Contact_JobTitle",
"type": "string",
"name": "Contact_JobTitle"
},
{
"control_type": "text",
"label": "Mobile",
"type": "string",
"name": "Contact_Mobile"
},
{
"control_type": "text",
"label": "Email",
"type": "string",
"name": "Contact_Email"
},
{
"control_type": "text",
"label": "ContactCreatedTime",
"type": "string",
"name": "ContactCreatedTime"
},
{
"control_type": "text",
"label": "ContactUpdatedTime",
"type": "string",
"name": "ContactUpdatedTime"
}
]
},
{
"control_type": "text",
"label": "Supplier_maiJDEBusinessUnit",
"type": "string",
"name": "Supplier_maiJDEBusinessUnit"
},
{
"control_type": "text",
"label": "Supplier_maiJDECurrencyCodeABAmounts",
"type": "string",
"name": "Supplier_maiJDECurrencyCodeABAmounts"
},
{
"control_type": "text",
"label": "Supplier_maiJDECurrencyCodeAccountsPayable",
"type": "string",
"name": "Supplier_maiJDECurrencyCodeAccountsPayable"
},
{
"control_type": "text",
"label": "Supplier_maiJDEElectronicAddressType",
"type": "string",
"name": "Supplier_maiJDEElectronicAddressType"
},
{
"control_type": "text",
"label": "Supplier_maiJDEElectronicAddressTypeEnum",
"type": "string",
"name": "Supplier_maiJDEElectronicAddressTypeEnum"
},
{
"control_type": "text",
"label": "Supplier_maiJDEGLOffset",
"type": "string",
"name": "Supplier_maiJDEGLOffset"
},
{
"control_type": "text",
"label": "Supplier_maiJDELineNumberID",
"type": "string",
"name": "Supplier_maiJDELineNumberID"
},
{
"control_type": "text",
"label": "Supplier_maiJDENameMailing",
"type": "string",
"name": "Supplier_maiJDENameMailing"
},
{
"control_type": "text",
"label": "Supplier_maiJDENameoftheBankandtheBranch",
"type": "string",
"name": "Supplier_maiJDENameoftheBankandtheBranch"
},
{
"control_type": "text",
"label": "Supplier_maiJDEPaymentTermsAP",
"type": "string",
"name": "Supplier_maiJDEPaymentTermsAP"
},
{
"control_type": "text",
"label": "Supplier_maiJDEPreNoteCode",
"type": "string",
"name": "Supplier_maiJDEPreNoteCode"
},
{
"control_type": "text",
"label": "Supplier_maiJDETaxExplCode2",
"type": "string",
"name": "Supplier_maiJDETaxExplCode2"
},
{
"control_type": "text",
"label": "Supplier_maiJDETaxRateArea2",
"type": "string",
"name": "Supplier_maiJDETaxRateArea2"
},
{
"control_type": "text",
"label": "Supplier_MaiJDETypeCode",
"type": "string",
"name": "Supplier_MaiJDETypeCode"
},
{
"control_type": "text",
"label": "SupplierCreatedTime",
"type": "string",
"name": "SupplierCreatedTime"
},
{
"control_type": "text",
"label": "SupplierModifiedTime",
"type": "string",
"name": "SupplierModifiedTime"
},
{
"control_type": "text",
"label": "SupplierModifiedBy",
"type": "string",
"name": "SupplierModifiedBy"
},
{
"control_type": "text",
"label": "SupplierCreatedBy",
"type": "string",
"name": "SupplierCreatedBy"
},
{
"control_type": "text",
"label": "SupplierTagetERP",
"type": "string",
"name": "SupplierTagetERP"
}
]
}
]

Here's the JSON structure Input : [
{
"Supplier.Node_URL_ID": 12345,
"Supplier.NodeURL": "C0/S1|Supplier",
"Supplier.Node Name": "SupplierName1",
"Supplier.maiState": "Active",
"Supplier.maiLocalSuppliername": "Dummy Supplier Name",
"Supplier.maiPLMID": "SUP_00001",
"Supplier.maiGroupName": "Dummy Group",
"Supplier.IsAgent": "false",
"Supplier.IsWarehouse": "true",
"Supplier.maiIsFactory": "false",
"Supplier.maiLocalBussinessLicenseRegistrationNumber": "dummy",
"Supplier.maiExpiryDateBussinessLicense": null,
"Supplier.maiSupplierProductClass": "A",
"Supplier.maiBussinessAddress": "123 Dummy Street",
"Supplier.maiCity": "Dummy City",
"Supplier.maiProvinceState": "Dummy State",
"Supplier.maiPostalCode": "000000",
"Supplier.Country.NodeName": "Dummy Country",
"Supplier.maiLocalLangBusinessAddress": "",
"Supplier.maiLocalLanguageCity": "",
"Supplier.maiLocallanguageProvince": "",
"Supplier.maiLocalLanguageCountry": 1,
"Supplier.PhoneNumber": "1234567890",
"Supplier.Email": "dummy@domain.com",
"Supplier.Classification": "Dummy Classification",
"maiClassificationSubType": "Type1,Type2,Type3",
"Supplier.Currency": "USD",
"Supplier.maiVAT": 0,
"Supplier.PaymentTerm": "",
"Supplier.TradeTerm": "Dummy Trade Term",
"Supplier.maiContactPersonAgent": "Dummy Person",
"Supplier.maiAgentSalutationName": "Mr",
"Supplier.maiBankKey": "DUMMYBANK",
"Supplier.maiBankaccountnumber": "DUMMYACCOUNT",
"Contact.maiPLMID": "1",
"Contact.NodeURL": "C1234",
"Contact.JobTitle": "",
"Contact.Mobile": "",
"Contact.Email": "",
"Contact.CreatedTime": "2025-01-14T09:18:00",
"Supplier.maiJDEBusinessUnit": "",
"Supplier.maiJDECurrencyCodeABAmounts": "",
"Supplier.maiJDECurrencyCodeAccountsPayable": "",
"Supplier.maiJDEElectronicAddressType": "",
"Supplier.maiJDEElectronicAddressTypeEnum": "",
"Supplier.maiJDEGLOffset": "",
"Supplier.maiJDELineNumberID": 0,
"Supplier.maiJDENameMailing": "",
"Supplier.maiJDENameoftheBankandtheBranch": "",
"Supplier.maiJDEPaymentTermsAP": "",
"Supplier.maiJDEPreNoteCode": "",
"Supplier.maiJDETaxExplCode2": "Processing",
"Supplier.maiJDETaxRateArea2": "",
"Supplier.maiJDETypeCode": "Dummy Type",
"Supplier.CreatedTime": "2025-01-02T10:38:00",
"Supplier.ModifiedTime": "2025-01-02T11:00:00",
"Supplier.CreatedBy": "DummyUser1",
"Supplier.ModifiedBy": "DummyUser2",
"TagetERP": "D001"
},
{
"Supplier.Node_URL_ID": 12346,
"Supplier.NodeURL": "C0/S2|Supplier",
"Supplier.Node Name": "SupplierName2",
"Supplier.maiState": "Active",
"Supplier.maiLocalSuppliername": "Dummy Supplier Name 2",
"Supplier.maiPLMID": "SUP_00002",
"Supplier.maiGroupName": "Dummy Group 2",
"Supplier.IsAgent": "false",
"Supplier.IsWarehouse": "true",
"Supplier.maiIsFactory": "false",
"Supplier.maiLocalBussinessLicenseRegistrationNumber": "dummy",
"Supplier.maiExpiryDateBussinessLicense": null,
"Supplier.maiSupplierProductClass": "B",
"Supplier.maiBussinessAddress": "456 Dummy Street",
"Supplier.maiCity": "Dummy City",
"Supplier.maiProvinceState": "Dummy State",
"Supplier.maiPostalCode": "111111",
"Supplier.Country.NodeName": "Dummy Country",
"Supplier.maiLocalLangBusinessAddress": "",
"Supplier.maiLocalLanguageCity": "",
"Supplier.maiLocallanguageProvince": "",
"Supplier.maiLocalLanguageCountry": 1,
"Supplier.PhoneNumber": "0987654321",
"Supplier.Email": "dummy2@domain.com",
"Supplier.Classification": "Dummy Classification 2",
"maiClassificationSubType": "TypeA,TypeB,TypeC",
"Supplier.Currency": "EUR",
"Supplier.maiVAT": 0,
"Supplier.PaymentTerm": "",
"Supplier.TradeTerm": "Dummy Trade Term 2",
"Supplier.maiContactPersonAgent": "Dummy Person 2",
"Supplier.maiAgentSalutationName": "Ms",
"Supplier.maiBankKey": "DUMMYBANK2",
"Supplier.maiBankaccountnumber": "DUMMYACCOUNT2",
"Contact.maiPLMID": "2",
"Contact.NodeURL": "C1235",
"Contact.JobTitle": "",
"Contact.Mobile": "",
"Contact.Email": "",
"Contact.CreatedTime": "2025-01-16T04:53:00",
"Supplier.maiJDEBusinessUnit": "",
"Supplier.maiJDECurrencyCodeABAmounts": "",
"Supplier.maiJDECurrencyCodeAccountsPayable": "",
"Supplier.maiJDEElectronicAddressType": "",
"Supplier.maiJDEElectronicAddressTypeEnum": "",
"Supplier.maiJDEGLOffset": "",
"Supplier.maiJDELineNumberID": 0,
"Supplier.maiJDENameMailing": "",
"Supplier.maiJDENameoftheBankandtheBranch": "",
"Supplier.maiJDEPaymentTermsAP": "",
"Supplier.maiJDEPreNoteCode": "",
"Supplier.maiJDETaxExplCode2": "Processing",
"Supplier.maiJDETaxRateArea2": "",
"Supplier.maiJDETypeCode": "Dummy Type 2",
"Supplier.CreatedTime": "2025-01-02T10:38:00",
"Supplier.ModifiedTime": "2025-01-02T11:00:00",
"Supplier.CreatedBy": "DummyUser1",
"Supplier.ModifiedBy": "DummyUser2",
"TagetERP": "D002"
}
]

The JSON structure is quite large, and I’m getting an indentation error when I try to parse or process it. I’ve ensured proper syntax, but the issue still persists. Could anyone help me pinpoint what could be wrong with the indentation or if there is another issue at play here?

Thanks in advance!

Re: Getting Indentation Error in JSON Structure - Need Help (How to Normalize Complex Nested JSON Da

shivakumara — Fri, 24 Jan 2025 15:42:52 GMT

Hi @Patel0786 ,
Could you please help us with your answer for below questions
1. Which application is providing the output structure you’ve shared?
2. What are your sample and actual data documents used for parsing JSON? (Based on the context, it seems you are utilizing a JSON Parser.)

Please include a screenshot of the error message for reference.

Thanks and Regards,
Shivakumar

Re: Getting Indentation Error in JSON Structure - Need Help (How to Normalize Complex Nested JSON Da

Patel0786 — Mon, 27 Jan 2025 10:05:06 GMT

this issue is solved

Re: Getting Indentation Error in JSON Structure - Need Help (How to Normalize Complex Nested JSON Da

Patel0786 — Mon, 27 Jan 2025 10:06:49 GMT

@shivakumara now this issue/error solved

Re: Getting Indentation Error in JSON Structure - Need Help (How to Normalize Complex Nested JSON Da

shivakumara — Mon, 27 Jan 2025 10:25:09 GMT

Hi @Patel0786,
Thank you for your response. I would greatly appreciate it if you could assist me with my query above. Your insights would help me better understand the issue and, if possible, provide a solution that could benefit others who may encounter a similar challenge.

Thanks and Regards,
Shivakumar

topic Getting Indentation Error in JSON Structure - Need Help (How to Normalize Complex Nested JSON Data ) in Workato Pros Discussion Board

Getting Indentation Error in JSON Structure - Need Help (How to Normalize Complex Nested JSON Data )

Re: Getting Indentation Error in JSON Structure - Need Help (How to Normalize Complex Nested JSON Da

Re: Getting Indentation Error in JSON Structure - Need Help (How to Normalize Complex Nested JSON Da

Re: Getting Indentation Error in JSON Structure - Need Help (How to Normalize Complex Nested JSON Da

Re: Getting Indentation Error in JSON Structure - Need Help (How to Normalize Complex Nested JSON Da