question

BandiVenkateswarlu-0829 avatar image
0 Votes"
BandiVenkateswarlu-0829 asked KamleshKumar commented

I'm triying to parse and load the following Json file into table I'm getting the records only if party address have the vallues if it is null the record is not loaded even party name and party type having values. please anyone solve this.

{
" Party": [
{
" Party Address": [
{
"Country": "Belgium",
"First Order Administrative Division": "Wallonia"
},
{
"Country": "Canada",
"First Order Administrative Division": null
}
],
" Party Name": "PRODUCTION DU DRAGON SA",
" Party Type": "Insured"
},
{
"Contract Party Address": []

                     " Party Name": "COMPANHIA DESEGUROS FI DELI DADE MUNDIAL",
                     " Party Type": "Reinsured"
                 }
             ]

}

biztalk-server
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Can you edit your question to include what you have tried, and what errors if any you are getting?
What is your table structure? How are you trying to insert into the table?

0 Votes 0 ·

Hi There,

Thank you for asking this question on the Microsoft Q&A Platform.

We would need more details about your issue, what steps did you try and what is not working, if you can provide more details to understand your issue and accordingly we'll help you to resolve it.

Regards,
Kamlesh Kumar

If this answer solved your problem, please click the Verify Answer button (found below the answer) to help other users who have the same question.

0 Votes 0 ·

0 Answers