Hi All, This is my first attempt at learning and using JSON. I am trying to POST some excel contacts to a HTTP URL using SSIS and zappy sys Web API destination. I have a valid login details and it is generating JSON. But it does POST any rows. Now when I use a JSON validation tool it says that the single row JSON is valid but the multiple row JSON is not valid. Then when I check the syntax it is exactly the same, so I am confused as to why it won’t load.
Works:
{“mode”:“live”,“contacts”:[{“contactid”:“W02_VCS_F4”,“FirstName”:“chole”,“LastName”:“Jennett”,“Mobile”:619999999}]}
Doesn’t work:
{“mode”:“live”,“contacts”:[{“contactid”:“W02_VCS_F4”,“FirstName”:“chole”,“LastName”:“jennett”,“Mobile”:61555555}]},
{“mode”:“live”,“contacts”:[{“contactid”:“W022_VCS_F4”,“FirstName”:“cameron”,“LastName”:“ficks”,“Mobile”:61555555}]},
{“mode”:“live”,“contacts”:[{“contactid”:“W022_VCS_F5”,“FirstName”:“monique”,“LastName”:“budgee”,“Mobile”:55555127}]},
{“mode”:“live”,“contacts”:[{“contactid”:“W022_VCS_F8”,“FirstName”:“leanne”,“LastName”:“rumlee”,“Mobile”:555555374}]},
{“mode”:“live”,“contacts”:[{“contactid”:“W022_VCS_F11”,“FirstName”:“Gabriella”,“LastName”:“Hiernan”,“Mobile”:5555623}]},
{“mode”:“live”,“contacts”:[{“contactid”:“W022_VCS_F13”,“FirstName”:“stephanie”,“LastName”:“kohlback”,“Mobile”:45555774}]},
{“mode”:“live”,“contacts”:[{“contactid”:“W022_VCS_F15”,“FirstName”:“jessica”,“LastName”:“db”,“Mobile”:null}]},
{“mode”:“live”,“contacts”:[{“contactid”:“W022_VCS_F17”,“FirstName”:“Lousie”,“LastName”:“unknown”,“Mobile”:41555558}]},
{“mode”:“live”,“contacts”:[{“contactid”:“W022_VCS_F20”,“FirstName”:“Felsea”,“LastName”:“Carle”,“Mobile”:43555552}]},
{“mode”:“live”,“contacts”:[{“contactid”:“W022_VCS_F22”,“FirstName”:“cjbsjhdj”,“LastName”:“unknown”,“Mobile”:4999999999}]},
{“mode”:“live”,“contacts”:[{“contactid”:“W022_VCS_F24”,“FirstName”:“lffis”,“LastName”:“lfu”,“Mobile”:43555560}]},
{“mode”:“live”,“contacts”:[{“contactid”:“W022_VCS_F25”,“FirstName”:“kona”,“LastName”:“Tarsh”,“Mobile”:43555525}]}
Any assistance is appreciated.