Method GetEmpData

Summary

REST service that returns information about Employees

Example

Parameters

Sample Code

using System.Net;

public void MethodName(parms){
    string uri = "https://fusion.superion.com/FusionOSServices/v1/ONESolution/HumanResources/Employees/2010215?fields=fname,lname";
    WebClient wc = new WebClient();
    Common.SetResponseType(wc, "json");
    Common.SetLicenseKey(wc);
    string stringResult = wc.DownloadString(new Uri(uri));
    
    JObject response = JObject.Parse(stringResult);
    foreach(var employee in response["DATA"]["EMPLOYEES"])
    {
       // TODO
    }
}

$.get('https://fusion.superion.com/FusionOSServices/v1/ONESolution/HumanResources/Employees/2010215?fields=fname,lname', function(response) {
    $('#resultDiv).html(response); 
 });

Sample Responses

                        
            {
              "RequestResponse": {
                "Count": "1",
                "DATA": {
                  "EMPLOYEES": [
                    {
                      "FNAME": "ERIC",
                      "LNAME": "LEONE"
                    }
                  ]
                }
              }
            }
        

Remarks

Query string options SkipRows: The number of rows at the begining of the query to not report. TakeRows: The number of rows from the query to report. If left blank the default is 1000. ?TakeRows=10 results in only 10 rows being returned. ?SkipRows=10 results in all rows after row 10 being returned. ?SkipRows=10&TakeRows=10 results in rows 11 through 20 being returned. Fields: A list of table columns to be included in the query. If this is included in the query string then only the listed columns will be reported. ?fields=fname,lname results in only the first and last name being reported. Columns can be renamed by appending the new name after the default name. ?fields=fname+FirstName,lname+LastName Filters: Any column name can be added to the query string as a filter. For example ?fname=Dan ?hdt=1/1/2017 By default the filter comparison is equality. Other comparison are available and can be appended to the filter "?fname=Dan+like " will select Dan, Daniel and Dannie "?hdt=1/1/2017+gt" will include all dates after 1/1/2017 Available comparisons are: "ge", greater than or equal to (>=) "gt", greater than (>) "isnotnull", is not null "isnull", is null "le", less than or equal to (<=) "like", like "lt", less than (<) "ne", not equal (!= , <>) "notlike", not like