need json schema structure for input data

[mavijayk]

Hi All, below is the json input file structure I'm receiving daily,
ETL : Informatica Cloud Intelligence
Source : Json event files

sample data

[
{
	"apple-2023-11-21": [
		{
			"name": "apple",
			"type": "fruit",
			"taste": "sweet"
		}
	],
	"potato-2023-11-21": [
		{
			"name": "potato",
			"type": "veggie",
			"taste": "sour"
		}
	]
}
]

schema I have generated

{
	"$id": "https://example.com/object1700667140.json", 
	"type": "array",
	"default": [],
	"items":{
		"type": "object",
		"properties": {
			"apple-2023-11-21": {
				"type": "array",
				"default": [],
				"items":{
					"type": "object",
					"properties": {
						"name": {
							"type": "string",
							"default": "",
							"pattern": "^.*$"
						},
						"type": {
							"type": "string",
							"default": "",
							"pattern": "^.*$"
						},
						"taste": {
							"type": "string",
							"default": "",
							"pattern": "^.*$"
				}
		}}},
		"potato-2023-11-21": {
				"type": "array",
				"default": [],
				"items":{
					"type": "object",
					"properties": {
						"name": {
							"type": "string",
							"default": "",
							"pattern": "^.*$"
						},
						"type": {
							"type": "string",
							"default": "",
							"pattern": "^.*$"
						},
						"taste": {
							"type": "string",
							"default": "",
							"pattern": "^.*$"
						}	}	}	}	}}}

Above tile name is dynamic value changes in a pattern "fruitname-yyyy-mm-dd" now problem here is, Informatica NOT able to parse the json file which is coming in pattern like above. I tired many options/properties etc. but didn't work. kindly do the needful and appreciate your help.

Regards,
vijay Kumar

[benjagm]

Hi @mavijayk. If your Pattern for Strings is expected to accept strings you'll need to change it. The current value set to ^.$ allows only a single character string. If you want to allow any string, you can use ^.*$ instead.

[mavijayk]

I tried this "^.*$" also but IICS(etl) not even reading data and populating nulls

[jdesrosiers]

You'll want to use patternProperties to express property names that fit a pattern.

[mavijayk]

If I give patterPropertiesin schema informatica not recognizing attributes

Any other suggestions please.

[jdesrosiers]

Your patternProperties regex only allows one character, but other than that your schema looks fine. I'm not familiar with the tool you're using or what you're trying to do with it, but I'd guess that tool just doesn't know how to deal with patternProperties.

[mavijayk]

Yes @jdesrosiers my tool can't deal patternproteries.