Convert array to object in ASP MVC API

Question

1.00/5 (1 vote)

See more:

i want to use stringbuilder to convert the object to array in my api but i don't get it.
i know array is [] and object is {}.you help is needed.please help me with the query and the stringbuilder.thank you

What I have tried:

this is the api controller

public ApiResult<List<Event>> GetUpcomingEvents()
        {
            EventMasterDb repo = new EventMasterDb();
            var result = new ApiResult<List<Event>>();
            try
            {
                StringBuilder  query = new StringBuilder();

                var list = repo.Fetch<Event>(query.ToString());
                result.Successfull = 1;
                result.Model = list;
            }
            catch (Exception ex)
            {
                result.Successfull = 0;
                result.InternalError = ex.Message;
                result.Error = "Error from server";
            }
            finally
            {
                repo.Dispose();
            }

            return result;

        }

this is the results from api,its in curly braces,that object type

{"EventId":2,"EventName":"Vodafone Ghana Videos Awards","Description":"Awards for music videos in Ghana","MerchantId":1,"VenueId":2,"VenueName":"Accra International Conference Center","Latitude":null,"Longitude":null,"Thumbnail":null,"CoverImage":null,"VideoUrl":null,"Url":null,"AddedDate":"2017-06-08T00:00:00","PublishedDate":"2017-06-10T00:00:00","EventDate":"2017-06-15T00:00:00"}]}

Posted 22-Jun-17 7:46am

Member 13053943

Updated 22-Jun-17 10:37am

Add a Solution

Comments

F-ES Sitecore 23-Jun-17 5:03am

Google "deserialise json c#" - there are loads of examples on how to do this.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Afzaal Ahmad Zeeshan · Answer 1 · 2017-06-22T10:37:00

Technically your need is unclear and very much ambiguous. Why do you need to do that? How can you convert, an object to an array?

One simple way would be, to accept the object, create an array, add that object to the array, and serialize the array. :D I mean, this is a very surreal sort of scenario, in which you would be needed to do this. There can be several ways where you might want to do this, such as, server or client might be looking for an array response. But nonetheless, this is not a good approach, you need to rethink your API protocol, verb and resource sharing.

Your code is showing a good example of doing this, I can see that you already have a list of your collection there in the repo object.

public List<Event> GetUpcomingEvents()
{
   EventMasterDb repo = new EventMasterDb();
   StringBuilder  query = new StringBuilder();
   // Missed the query? 
   var list = repo.Fetch<List<Event>>(query.ToString()); 
   // Fetch List<Event> instead of Event

   // You already have a list, return it!
   return list;
}

One more thing, the API do not require you to use MVC wrappers, such as ActionResults etc, you just need to return your own custom types, or containers (List etc). ASP.NET Web API will automatically map them to what you need in the JSON or XML format.