How to create a Graphql query from OrchardCore Backend

[hyzx86]

I hope I can use graphql query to export some data to Excel files, but this requires me to initiate a graphql query request in the background and then obtain the data. I found such a class in the source code

    public class OrchardGraphQLClient
    {
        public OrchardGraphQLClient(HttpClient client)
        {
            Client = client;
        }

        public ContentResource Content => new ContentResource(Client);

        public HttpClient Client { get; }
    }

As shown above, I need to build an httpclient before using it

At the same time, we need to fill all the information requested by the clientRequest into the new httpclient
This may require some tedious work. Has anyone implemented similar operations?
Or do you have any better suggestions?

[hyzx86]

http:

 private readonly HttpClient _httpClient;
    public ExcelController(IHttpClientFactory httpClientFactory)
    {
        _httpClient = httpClientFactory.CreateClient(Consts.GraphqlClient);
    }
    public async Task<ActionResult> ExportByGraphqlQuery(ExportByGraphqlQueryOptions options)
    {

#if DEBUG
        options.GraphQLQuery = @"  customer {    createdUtc
    custNum    dateeeee    datetimesssssss    displayText    guimo    modifiedUtc    name    publishedUtc    timeeeeeeeeeee  }";
#endif

        _httpClient.BaseAddress = new Uri($"{Request.Scheme}://{Request.Host}");
        _httpClient.DefaultRequestHeaders.Clear();
        if (!string.IsNullOrEmpty(Request.Headers["Cookie"]))
        {
            _httpClient.DefaultRequestHeaders.Add("Cookie", Request.Headers["Cookie"].ToString());
        }
        if (!string.IsNullOrEmpty(Request.Headers["Authorization"]))
        {
            _httpClient.DefaultRequestHeaders.Add("Authorization", Request.Headers["Authorization"].ToString());
        }

        var requestJson = new JObject(
        new JProperty("query", @"query { " + options.GraphQLQuery + " }")
        );
        if (options.QueryParams is not null)
        {
            requestJson["variables"] = JObject.FromObject(options.QueryParams);
        }
        var request = new HttpRequestMessage(HttpMethod.Post, "api/graphql");
        request.Content = new StringContent(requestJson.ToString(), Encoding.UTF8, "application/json");
        request.Headers.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));
        var response = await _httpClient.SendAsync(request);

        if (!response.IsSuccessStatusCode)
        {
            throw new Exception(response.StatusCode + " " + await response.Content.ReadAsStringAsync());
        }

        var result = JObject.Parse(await response.Content.ReadAsStringAsync());
        return Json(result);//scuccess

    }

direct to excute graphql Query：

OrchardCore/src/OrchardCore.Modules/OrchardCore.Apis.GraphQL/GraphQLMiddleware.cs

Lines 172 to 189 in c255456

	var result = await _executer.ExecuteAsync(_ =>
	{
	_.Schema = schema;
	_.Query = queryToExecute;
	_.OperationName = request.OperationName;
	_.Inputs = request.Variables.ToInputs();
	_.UserContext = _settings.BuildUserContext?.Invoke(context);
	_.ExposeExceptions = _settings.ExposeExceptions;
	_.ValidationRules = DocumentValidator.CoreRules()
	.Concat(context.RequestServices.GetServices<IValidationRule>());
	_.ComplexityConfiguration = new ComplexityConfiguration
	{
	MaxDepth = _settings.MaxDepth,
	MaxComplexity = _settings.MaxComplexity,
	FieldImpact = _settings.FieldImpact
	};
	_.Listeners.Add(dataLoaderDocumentListener);
	});

[lampersky]

@hyzx86 if you are interested I can share later how I've achieved same thing but without http client

[hyzx86]

@lampersky

I have used _executer.ExecuteAsync achieved the effect I needed,
But it would be great to see your code, Thanks! 😊

[lampersky]

@hyzx86

I've created my own GraphQLService, which looks like this:

and within my controller I'm able to perform queries directly from string or GQL files:

Please note, that it would be good to add some permission checks, which was omitted in my case.

[hyzx86]

Thanks for sharing

After reading your code, I am similar to your usage
In terms of permission, you should be able to directly use the permission setting of OC without additional inspection of the content