Need to fetch data from token-based API

Csharp dev

I'm new to C# coding, I need to fetch data through the SSIS package using a script component task from api which has many filter api URL inside it. The main login URL is similar to http://URL:portname/user/signin. By using the loginid and password, I need to generate the token and then I need to pass the token in the filter api header whose url is similar to http://URL:portname/division.

Please help

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Viswanatha Swamy6y ago
Accepted answer
Csharp Dev,

Good morning. Below are the high-level steps. Please let me know if you need anything else. The details will vary based on the technology. Many thanks.

Step 1:

I assume the call to retrieve the Token is Post. You have to pass the User Id, and Password, that call will return the Token. Store the token inside another variable.

Step 2:

Before invoking the 2nd call you have to attach the token received from your previous call.

RequestObject.authorization = 'Bearer jxxxxxxxxxx'
Viswanatha Swamy6y ago
Good evening,
I have created a console application to retrieve the JWT token using RestSharp. Also given the URL below. We have to create a class with Token, Expiration as minimum properties. Please let me know if you need any other assistance. Many thanks.

URL: https://github.com/vishipayyallore/speaker_series/tree/master/C%23/RetrieveJwtTokeUsingRestSharp
static void Main(string[] args)
{
    var client = new RestClient("http://localhost:50460");
    var request = new RestRequest("/api/auth/token", Method.POST);

    request.AddJsonBody(new
    {
        username = "userone",
        password = "abcd123"
    });

    IRestResponse response = client.Execute(request);
    var content = response.Content; // {"message":" created."}

    UserAuthorization userAuthorization = JsonConvert.DeserializeObject(content);
    Console.WriteLine($"Token: {userAuthorization.Token} \nExpiration: {userAuthorization.Expiration}");

    Console.WriteLine("\n\nPress any key ...");
    Console.ReadKey();
}
Image for reference:
Viswanatha Swamy6y ago
Csharp Dev,
Good morning. I got it. I will work on the code sample and publish it to my GitHub Repository. Currently at work. I will work on this sample by today EOD. Will that work? Many thanks.
Csharp dev6y ago
Hi Viswanatha Swamy,

Thanks a lot for your reply.

Yes, my token is JWT and will expire on 12 April.

Kindly help me to get the web content from API as I'm not able to get any data in

var mytoken = gettoken.token; (in this variable) and because of this the token is not able to authorize the other APIs

Also, I'm not able to deserialize/serialize the content.

Thanks a lot for your help and time.
Viswanatha Swamy6y ago
Good evening. Is your token JWT token. If yes, could you please visit "https://jwt.io/" and find out the Token Expiration time. Please let me know if you need some more assistance. Many thanks.
Csharp dev6y ago
Hi Viswanatha Swamy,

Thank you for your reply.

I tried the same thing using the RestSharp but I'm not able to serialize/deserialize the web API content.

My token becomes invalid after 3 days.

Please help me to resolve this issue

Here is my code
var client = new RestClient("http://url/");
client.Timeout = -1;
var request = new RestRequest(Method.POST);
request.AddHeader("username", "password");
request.AddHeader("Content-Type", "application/json");
request.AddParameter("application/json", "{ \r\n\"loginid\" : \"myloginid\",\r\n \r\n \"password\" : \"mypassword\"\r\n }\r\n", ParameterType.RequestBody);
IRestResponse response = client.Execute(request);
string getresponsetoken = response.Content;
extracttoken gettoken = JsonConvert.DeserializeObject(getresponsetoken);
var mytoken = gettoken.token;
user_master_api_Response user_master = new JavaScriptSerializer().Deserialize(getresponseusers);
foreach (var item in user_master.data)
{
Output0Buffer.AddRow();
// if (!String.IsNullOrEmpty(item.password.ToString()))
//{
Output0Buffer.fieldname= item.fieldname.ToString();
// }
Output0Buffer.fieldname1 = item.fieldname1.ToString();
}
}
/*
public class user_master_api_Response
{
public List data { get; set; }
}
public class user_master_api
{
public string fieldname1 { get; set; }
public string fieldname2 { get; set; }
}
public class extracttoken
{
public string token { get; set; }
}
}