Share
Report
4Originally I have posted my question here - https://answers.microsoft.com/en-us/msoffice/forum/msoffice_other-msoffice_unknown-mso_unsupported/offline-json-schema-validator-tool-in/a1bd7ee5-7381-4436-8218-fe856f74c4d7?messageId=def23238-5706-4a17-ab01-39138d5886bc
The problem is I have JSON files extracted from database and I want to perform validation against defined JSON schema like this online tool. I searched but couldn't find any tool but I got a very good suggestion from Jonathan to use Power Automate, Office script and excel. I would really appreciate if someone could help me to achieve it. Even if I could a sample script and excel having just few lines would be a lot. I would then replace my json and json schema for validation at appropriate places. Thank you in advance.
The problem is I have JSON files extracted from database and I want to perform validation against defined JSON schema like this online tool. I searched but couldn't find any tool but I got a very good suggestion from Jonathan to use Power Automate, Office script and excel. I would really appreciate if someone could help me to achieve it. Even if I could a sample script and excel having just few lines would be a lot. I would then replace my json and json schema for validation at appropriate places. Thank you in advance.
Categories:
I have the same question (0)
All responses (
Answers (
