Can you provide me a sample of the json being returned by the web service request? If you want, just turn on input and output logging for the entire flow and send me the log files.
Greg W.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hello guys, can anybody help me with Json Parser component, what the format for path should be. I am trying to provide raw json to Json Parser and want to have a model as output. But I keep receiving the error "At least one path setting must be provided."
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
You are probably getting that error because in the Advanced Edit window most likely I'm guessing the 'Path' field is not filled in with a node reference that corresponds to the parent or high-level JSON array node for which the data repeats below.
Fyi, the Json Parser component is expecting the format of the Json data to be starting with an Array object.
For example if your input looks like the following:
{"parent": [ {
"number" : "A-14",
"name" : "TEST" } ,
{ "number" : "B-22",
"name" : "ANOTHER TEST" }
]
}
Then in the Advanced Edit window of the Json Parser the row where your desired Entity to populate has no Attribute Name, this is where you enter your parent array node name of 'paren't in my case above. Then I can enter 'number' and 'name' in the corresponding Attribute Name rows that they refer to.
For Example if my model has an Entity called 'test' with Attributes 'versionNumber' and 'hostName' then the Advanced Edit would look like the following:
Entity Name
Attribute Name
Path
test
parent
test
versionNumber
number
test
hostName
name
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
e
Last edit: Petar ILiev 2018-12-06
Can you provide me a sample of the json being returned by the web service request? If you want, just turn on input and output logging for the entire flow and send me the log files.
Greg W.
z
Last edit: Petar ILiev 2018-12-06
Hello guys, can anybody help me with Json Parser component, what the format for path should be. I am trying to provide raw json to Json Parser and want to have a model as output. But I keep receiving the error "At least one path setting must be provided."
You are probably getting that error because in the Advanced Edit window most likely I'm guessing the 'Path' field is not filled in with a node reference that corresponds to the parent or high-level JSON array node for which the data repeats below.
Fyi, the Json Parser component is expecting the format of the Json data to be starting with an Array object.
For example if your input looks like the following:
{"parent": [ {
"number" : "A-14",
"name" : "TEST" } ,
{ "number" : "B-22",
"name" : "ANOTHER TEST" }
]
}
Then in the Advanced Edit window of the Json Parser the row where your desired Entity to populate has no Attribute Name, this is where you enter your parent array node name of 'paren't in my case above. Then I can enter 'number' and 'name' in the corresponding Attribute Name rows that they refer to.
For Example if my model has an Entity called 'test' with Attributes 'versionNumber' and 'hostName' then the Advanced Edit would look like the following: