How can I insert multiple items of data into SQL using Web API?

Question

I have a code like this:

public IHttpActionResult Post(CUSTOMER [] newCustomer)
{
    try
    {
        foreach (CUSTOMER item in newCustomer)
        {
            var AddedCust = db.CUSTOMERs.Add(item);
        }

        int insertedRecords = db.SaveChanges();
        return Ok(insertedRecords);
    }
    catch (Exception)
    {
        return BadRequest(ModelState);
    }
}

With Postman I am trying to post more than one record - but I get an exception:

{

    "NAME": "test1",
    "SURNAME": "Aleksandrova",
    "BIRTHPLACE": "Minsk",
    "GENDER": "F",
    "IDENTITYNO": "AA75 857445",
    "IDENTITYPINCODE": 2552,
    "BIRTHDATE": "1970-06-19T00:00:00"
}
{

    "NAME": "test2",
    "SURNAME": "Aleksat34t34ndrova",
    "BIRTHPLACE": "Minsk",
    "GENDER": "F",
    "IDENTITYNO": "AA75 857445",
    "IDENTITYPINCODE": 2552,
    "BIRTHDATE": "1970-06-19T00:00:00"
}
{

    "NAME": "test3",
    "SURNAME": "Aleksandrova",
    "BIRTHPLACE": "Minsk",
    "GENDER": "F",
    "IDENTITYNO": "AA75 857445",
    "IDENTITYPINCODE": 2552,
    "BIRTHDATE": "1970-06-19T00:00:00"
}

ERROR:

"Cannot deserialize the current JSON object (e.g. {\"name\":\"value\"}) into type 'First_API.Models.CUSTOMER[]' because the type requires a JSON array (e.g. [1,2,3]) to deserialize correctly.\r\nTo fix this error either change the JSON to a JSON array (e.g. [1,2,3]) or change the deserialized type so that it is a normal .NET type (e.g. not a primitive type like integer, not a collection type like an array or List) that can be deserialized from a JSON object.

How can I solve this problem?

Please read How to Ask. This error has been asked about - and answered hundreds of times already. What have you tried? — CodeCaster
– CodeCaster, Commented Feb 10, 2020 at 9:51

Prasad Telkikar · Accepted Answer · 2020-02-10 09:46:07Z

6

Your json body is invalid, Json array should be enclosed in [ ] (square brackets) and each record should be separated by ,(Comma)

Try to send api request with below json

[{

    "NAME": "test1",
    "SURNAME": "Aleksandrova",
    "BIRTHPLACE": "Minsk",
    "GENDER": "F",
    "IDENTITYNO": "AA75 857445",
    "IDENTITYPINCODE": 2552,
    "BIRTHDATE": "1970-06-19T00:00:00"
},
{

    "NAME": "test2",
    "SURNAME": "Aleksat34t34ndrova",
    "BIRTHPLACE": "Minsk",
    "GENDER": "F",
    "IDENTITYNO": "AA75 857445",
    "IDENTITYPINCODE": 2552,
    "BIRTHDATE": "1970-06-19T00:00:00"
},
{

    "NAME": "test3",
    "SURNAME": "Aleksandrova",
    "BIRTHPLACE": "Minsk",
    "GENDER": "F",
    "IDENTITYNO": "AA75 857445",
    "IDENTITYPINCODE": 2552,
    "BIRTHDATE": "1970-06-19T00:00:00"
}]

answered Feb 10, 2020 at 9:46

Prasad Telkikar

16.1k7 gold badges26 silver badges49 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Alish Safarli Over a year ago

how can I return just data itself which was added?

Alish Safarli Over a year ago

I know. I get the number of inserted records for example with one record I write return ok(value) but this value is in the loop How can i return it?

Prasad Telkikar Over a year ago

@AlishSafarli, error which you posted is self explanatory, it it addressed before on stackoverflow that might be the reason for getting -1 on your question

pasha goroshko · Accepted Answer · 2020-02-10 09:46:52Z

0

try

[
    {
        "NAME": "test1",
        "SURNAME": "Aleksandrova",
        "BIRTHPLACE": "Minsk",
        "GENDER": "F",
        "IDENTITYNO": "AA75 857445",
        "IDENTITYPINCODE": 2552,
        "BIRTHDATE": "1970-06-19T00:00:00"
    },
    {
        "NAME": "test2",
        "SURNAME": "Aleksat34t34ndrova",
        "BIRTHPLACE": "Minsk",
        "GENDER": "F",
        "IDENTITYNO": "AA75 857445",
        "IDENTITYPINCODE": 2552,
        "BIRTHDATE": "1970-06-19T00:00:00"
    },
    {
        "NAME": "test3",
        "SURNAME": "Aleksandrova",
        "BIRTHPLACE": "Minsk",
        "GENDER": "F",
        "IDENTITYNO": "AA75 857445",
        "IDENTITYPINCODE": 2552,
        "BIRTHDATE": "1970-06-19T00:00:00"
    }
]

answered Feb 10, 2020 at 9:46

pasha goroshko

1992 silver badges14 bronze badges

3 Comments

user1945782 Over a year ago

You could add an explanation as to why you've formatted the JSON like you have, for completeness (see Prassad's answer).

CodeCaster Over a year ago

"try" is not an answer.

pasha goroshko Over a year ago

@CodeCaster you can always do better

Collectives™ on Stack Overflow

How can I insert multiple items of data into SQL using Web API?

2 Answers 2

3 Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related