All working, my event handler hadn't saved or rather i hadn't saved it. All working fine now

Again thanks for the reply

Hi Phil

Thanks for getting back on this.

Simplified version for testing in the screenshot, so basically the small scheme needs to always execute to completion and then the large scheme will...

Phil

quick update, was decided this was no longer required so it appears i swerved one here!

Thanks for your help on this though, much appreciated

cheers Phil , i'll give that a try

Hi Phil

added in "Start-Sleep -Seconds 60" for a minutes pause but the window still just flicks open and closes as before, there appears to be some text in the window...

Hi Phil,

Opens a new blank window and then closes that and thats pretty much it, no errors or feedback at all

cheers

Hi Phil

It is valid JSON but there's valid JSON and then there's JSON that makes sense, not sure why you would have unnamed arrays for something like this but i...

ha ha attempts have been made Jeff

JSON is being passed to us and the team that produce it have refused to fix as they claim its valid JSON so that's a no no

thank Eddie

Steve that works perfectly, you've saved me from losing even more hair!

Thanks for your help on this

Sure, its the final cross apply which is the issue. Have also attached section of the file which hopefully highlights what my issue is

Thanks for looking into it

SELECT

parentDataId

,dataId

,isRated

,id

,label

,value

,previousDataId

FROM OPENJSON(@JSON)

WITH

(

policyStatus NVARCHAR(25)...