locked
HELP ! SA jobs json limitation RRS feed

  • Question

  • We have set up an SA job with iot hub as the input and JSON as the payload format. We cannot access json values which has nesting levels greater than 3.

    for example in I have json object the following works device.id.state, but if I have device.id.state.description it does not.

    I there a way around this issues?

    Friday, October 13, 2017 4:27 PM

All replies

  • There should be no limit on the depth of the nesting level. Can you share sample of the data?
    Friday, October 13, 2017 4:42 PM
  • Hi, 

    as a workaournd you could use a UDF:

    https://blogs.msdn.microsoft.com/streamanalytics/2017/04/04/using-azure-stream-analytics-javascript-udf-to-lookup-values-in-json-array/ 

    Regards, 

    Thomas 

    Monday, November 6, 2017 3:49 PM