Retrieving Picklist and Picklist Items via Infor CRM (Saleslogix) SData using C#

Accessing system level data, such as picklists, groups, etc, is an easy task with the SData system endpoint. In this post we will look at how to retrieve picklists and picklist items using SData, C#, and the DotNetSDataClient library.

The DotNetSDataClient Library

As I mentioned in an earlier post outlining SData resources, the DotNetSDataClient Library is a newer, officially supported client library for SData and .NET. This library replaces the older SDataCSharpClientLib library and is the recommended library for SData when using .NET. It is available via NuGet as DotNetSdataClient or on github, and has excellent documentation.

Retrieving Picklists and Picklist Items via SData

The way the DotNetSDataClient Library generally works is you create POCO (Plain Old CLR Object) classes for the entities and the library retrieves the data and fills the objects. If you’re familiar with Sublogix, it works the exact same way. For retrieving Picklists, the first thing we need to do is create the objects. We only need to create properties for the SData entity properties we’re interested in keeping. We could add more properties for Picklist entity properties and they will be filled as well (such as Id etc).

[SDataPath("pickLists")]
public class PickList
{
    public string Name { get; set; }
    public IList<PickListItem> Items { get; set; }
}

public class PickListItem
{
    public string Text { get; set; }
    public string Code { get; set; }
}

Now that we have those objects we can have the library fill them with our Picklist data.

// create the SData client
var client = new SDataClient("http://localhost/sdata/slx/system/-")
{
    UserName = "admin",
    NamingScheme = NamingScheme.CamelCase
};

// use the client to get the Picklist with ID kSYST0000001 and include the items 
var pickList = client.Get<PickList>("kSYST0000001", null, new SDataPayloadOptions {Include = "items"}); 

// display the picklist name on the console
Console.WriteLine(pickList.Name); 

// display the items on the console
foreach (var item in pickList.Items) 
{
    Console.WriteLine("- ({0}) {1}", item.Code, item.Text); 
}

That’s it. View more about retrieving picklists in the documentation.

ABOUT THE AUTHOR

Ryan Farley

Ryan Farley is the Director of Development for Customer FX and creator of slxdeveloper.com. He's been blogging regularly about SalesLogix since 2001 and believes in sharing with the community. He loves C#, Javascript, Python, web development, open source, and Linux. He also loves his hobby as an amateur filmmaker.

1 Comment

  1. Why is that we cannot retrieve the Id for a picklist item, following the sdata specification for a picklistitem or Picklist. So basically i have tried adding PickListItemId, ItemId, Id to the picklistitem class it still does not populate it.

    Reply

Submit a Comment

Your email address will not be published. Required fields are marked *

Subscribe To Our Newsletter

Join our mailing list to receive the latest Infor CRM (Saleslogix) news and product updates!

You have Successfully Subscribed!