locked
Getting full cosmos json document in SSIS RRS feed

  • Question

  • Hi, I'm trying to get the full json document either using the cosmos odbc connector or kingswaysoft but it just returns me the root data (without the arrays).

    How can i extract the full json document, same as how i query in azure portal data explorer?

    thanks.

    Tuesday, May 19, 2020 7:57 AM

All replies

  • Hi Milsnips,

    Yes, if you pass the query: 

    SELECT * FROM c

    or

    SELECT * FROM c where c.id = 'id_value'


    Does this not get you all of the doc json? If you are still not seeing the result you are expecting, can you please provide an example of your document.

    Thank you,

    Mike

    Wednesday, May 20, 2020 3:08 AM
  • Hi Milsnips,

    Did you have any additional questions of find a resolution to your issue? If you need additional assistance, please detail the issue you are facing and we can assist you. The question presented did not have much context.

    Regards,

    Mike

    Tuesday, May 26, 2020 2:16 AM