I appreciate any help here. I've tried everything I can think of. I've compared the Postman requests and C# requests, but not seeing anything.
I have several simple search queries. Searches by Id or getting all results works great and everything works fine in Postman. However, with my C# code any record collection filtering gets the 401 error.
Here is some sample code to reproduce it:
internal async void TestSearches()
{
//string query = "nonInventorySaleItem"; // Works
//string query = "nonInventorySaleItem/12885"; // Works
//string query = "nonInventorySaleItem?q=itemId CONTAIN ABC123"; //Gets a 401 Unauthorized
string query = "nonInventoryResaleItem"; //Works
//string query = "nonInventoryResaleItem/7517"; //Works
//string query = "nonInventoryResaleItem?q=itemId IS 32305"; // Gets a 401 Unauthorized
string accountId = _settings.accountId;
string realm = _settings.realm;
string baseUrl = $"https://{_settings.accountId}.suitetalk.api.netsuite.com";
string consumerKey = _settings.consumerKey;
string consumerSecret = _settings.consumerSecret;
string tokenId = _settings.tokenId;
string tokenSecret = _settings.tokenSecret;
var client = new RestClient(baseUrl);
var request = new RestRequest($"/services/rest/record/v1/{query}", Method.Get);
var authHeader = GetAuthorizationHeader(realm, baseUrl + request.Resource, consumerKey, consumerSecret, tokenId, tokenSecret);
request.AddHeader("Authorization", authHeader);
request.AddHeader("Accept", "*/*");
var response = await client.ExecuteAsync(request);
Console.WriteLine("Response Data: " + response.Content);
}
Here is the where the authorization header is created. It works for all queries by id and also others where I don't use record filtering.
private static string GetAuthorizationHeader(string realm, string url, string consumerKey, string consumerSecret, string tokenId, string tokenSecret)
{
string nonce = Guid.NewGuid().ToString("N");
string timestamp = DateTimeOffset.UtcNow.ToUnixTimeSeconds().ToString();
string method = "GET";
string baseString = $"{method}&{Uri.EscapeDataString(url)}&" +
$"{Uri.EscapeDataString($"oauth_consumer_key={consumerKey}&oauth_nonce={nonce}&oauth_signature_method=HMAC-SHA256&oauth_timestamp={timestamp}&oauth_token={tokenId}&oauth_version=1.0")}";
string signingKey = $"{Uri.EscapeDataString(consumerSecret)}&{Uri.EscapeDataString(tokenSecret)}";
var hmac = new HMACSHA256(Encoding.UTF8.GetBytes(signingKey));
string signature = Convert.ToBase64String(hmac.ComputeHash(Encoding.UTF8.GetBytes(baseString)));
return $"OAuth realm=\"{realm}\", " +
$"oauth_consumer_key=\"{consumerKey}\", " +
$"oauth_token=\"{tokenId}\", " +
$"oauth_signature_method=\"HMAC-SHA256\", " +
$"oauth_timestamp=\"{timestamp}\", " +
$"oauth_nonce=\"{nonce}\", " +
$"oauth_version=\"1.0\", " +
$"oauth_signature=\"{Uri.EscapeDataString(signature)}\"";
}
Thanks again!