NetSuite Rest Web服务C＃RestSharp-请求失败，而状态代码BADREQUEST

Question

在这个电话中，我继续将头撞在墙上。它在Postman中返回完全很好，但是当我跑步时，我会得到以下内容：

例外消息：发生一个或多个错误。 （请求因状态代码badrequest失败）。

例外数据：system.collections.listDictionaryInternal

我正在尝试使用最新的RestSharp构建，但可能必须降级才能使其正常工作，以便我可以使用提供的Postman代码。我还确保在运行脚本之前要获得有效的令牌。

*请注意，该代码在VS中构建正常。

using System;
using RestSharp;
using System.Net.Http;
using System.Threading.Tasks;

namespace NetSuite
{

    class Program
    {

        static void Main(string[] args)
        {

            try
            {

                MainAsync().Wait();

                static async Task MainAsync()
                {

                    var client = new RestClient("https://xxxxxxxxxxxxxxxxxxx.suitetalk.api.netsuite.com/services/rest/query/v1/suiteql?limit=500");
                    var request = new RestRequest();

                    request.AddHeader("Content-Type", "application/json");
                    request.AddHeader("prefer", "transient");
                    request.AddHeader("Authorization", "Bearer xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx");


                    var body = @"{""q"": ""SELECT * FROM entity where id = 999""}";

                    request.AddParameter("application/json", body,  ParameterType.RequestBody);

                    var response = await client.PostAsync(request);

                }

            }
            catch (Exception ex)
            {
                Console.WriteLine("ERROR -- Exception Message: " + ex.Message.ToString());
                Console.WriteLine("ERROR -- Exception Data: " + ex.Data.ToString());
                System.Threading.Thread.Sleep(300);
            }

        }

    }
}

Answer 1

您缺少身份验证代码。这是使用您的SUITEQL请求的示例。我发现RestSharp无法与方法相关。浪费了一天，然后决定尝试一种方法。它可以正常工作。 Get the token information found in the tutorial at

public dynamic GetEntity(int? entityid = null)
{
    string url = _config.ApiRoot + "/query/v1/suiteql";
    string sql = "SELECT * FROM entity ";
            
    if (entityid != null){
        sql += " WHERE id = " + entityid.ToString();                    
    }

    var authenticator = OAuth1Authenticator.ForAccessToken(
        _config.ClientId,
        _config.ClientSecret,
        _config.TokenId,
        _config.TokenSecret,
        OAuthSignatureMethod.HmacSha256);
    authenticator.Realm = _config.AccountId;

    var content = "{\"q\":\"" + sql + "\"}";

    var options = new RestClientOptions(url);
    options.Authenticator = authenticator;
    var client = new RestClient(options);
    var httpRequest = new RestRequest(url, Method.Post);
    httpRequest.AddHeader("prefer", "transient");
    httpRequest.AddBody(content);
    var httpResponse = client.Execute(httpRequest);

    if (httpResponse.StatusCode == System.Net.HttpStatusCode.OK)
    {
        dynamic obj = Newtonsoft.Json.JsonConvert.DeserializeObject<dynamic>(httpResponse.Content);
        return obj;
    }
    else
    {
        return null;
    }