After some testing I was able to successfully get this to work:
| parse regex "\"ConfirmationNumber\":\"(?<ConfirmationNumber>[0-9]*)\"" multi nodrop