Trying to read the new report json files using microsoft pubished schemas

[bernatagulloesbrina]

Hello,
I'm attempting to create a script which can parse the report json schemas using microsoft's own published schemas. I have succeeded in getting the url from the file and even the contents of the published schema file. However, it looks like the scheme references other schemas and here is where I'm stuck. ChatGPT proposals do not seem to work, but maybe is because of some limitation in the way that C# code is executed by TE3? maybe the way forward is to just use simplified schemas that are enough for the use cases in which I want to use them?

here's one of the last attempts in case you want to have a look

#r "I:\La meva unitat\Power BI\Changing the report\C Sharp Code\Report\bin\Debug\Newtonsoft.Json.Schema.dll"
#r "I:\La meva unitat\Power BI\Changing the report\C Sharp Code\Report\bin\Debug\Newtonsoft.Json.dll"


using System;

using System.IO;
using Newtonsoft.Json;
using Newtonsoft.Json.Linq;
using Newtonsoft.Json.Schema;
using System.Net.Http;
using System.Threading.Tasks;


        // Path to your JSON file
        string jsonFilePath = @"I:\La meva unitat\Power BI\Changing the report\change the report\changing the report.Report\definition\pages\8f8b3c965803c00bd659\page.json";

        // Read the JSON file
        string jsonData = File.ReadAllText(jsonFilePath);

        // Parse the JSON data
        JObject jsonObject = JObject.Parse(jsonData);

        // Get the schema URL from the $schema property
        string schemaUrl = jsonObject["$schema"]?.ToString();

        if (string.IsNullOrEmpty(schemaUrl))
        {
            Console.WriteLine("The $schema property is not found in the JSON file.");
            return;
        }

        // Load the JSON schema from the URL with references resolved
        JSchema schema = await LoadSchemaWithReferencesAsync(schemaUrl);

        // Validate the JSON data against the schema
        bool isValid = jsonObject.IsValid(schema, out IList<string> validationErrors);

        // Output validation results
        if (isValid)
        {
            Console.WriteLine("JSON is valid.");
        }
        else
        {
            Console.WriteLine("JSON is invalid. Errors:");
            foreach (string error in validationErrors)
            {
                Console.WriteLine(error);
            }
        }


// Method to load schema and resolve references
    private static async Task<JSchema> LoadSchemaWithReferencesAsync(string schemaUrl)
    {
        var client = new HttpClient();
        var preloadedResolver = new JSchemaPreloadedResolver();

        // Load the main schema
        var mainSchemaData = await client.GetStringAsync(schemaUrl);
        preloadedResolver.Add(new Uri(schemaUrl), mainSchemaData);

        // Parse the main schema
        var mainSchema = JSchema.Parse(mainSchemaData);

        // Load all referenced schemas
        await LoadReferencedSchemasAsync(mainSchema, new Uri(schemaUrl), client, preloadedResolver);

        return JSchema.Parse(mainSchemaData, new JSchemaReaderSettings
        {
            Resolver = preloadedResolver
        });
    }

    private static async Task LoadReferencedSchemasAsync(JSchema schema, Uri baseUri, HttpClient client, JSchemaPreloadedResolver resolver)
    {
        var references = new List<string>();
        var visitor = new CollectReferencesVisitor();
        visitor.Visit(schema);

        foreach (var reference in visitor.References)
        {
            var referenceUri = new Uri(baseUri, reference);
            if (!resolver.Contains(referenceUri))
            {
                var referenceData = await client.GetStringAsync(referenceUri);
                resolver.Add(referenceUri, referenceData);

                var referenceSchema = JSchema.Parse(referenceData);
                await LoadReferencedSchemasAsync(referenceSchema, referenceUri, client, resolver);
            }
        }
    }

    private class CollectReferencesVisitor : JSchemaVisitor
    {
        public List<string> References { get; } = new List<string>();

        protected override void VisitSchema(JSchema schema)
        {
            if (schema.Reference != null)
            {
                References.Add(schema.Reference.ToString());
            }
            base.VisitSchema(schema);
        }
    }

[otykier]

Tabular Editor should not execute C# in a way that’s notably different. Are you able to make it work by creating, say, a C# console application in Visual Studio?

[bernatagulloesbrina]

Thank you! Finally I have chosen a less ambitious path creating the c# class manually based on an example json. Hopefully blogpost coming soon.