JSON, creating order, but not creating the order lines.

Question

0.00/5 (No votes)

See more:

I am new to JSON, so no doubt this is an easy one for you experts ;-).
I am able to post the following and it is creating the order, but it is not adding any lines. Could someone please check out the code and see if it is structurally correct, appreciate you don't know what tags should be written to, but is the format correct?

Also do I have the address bits right for multiple lines in there?

This order is just for one line, other orders will be multiple lines, but I can't even get a one line order in... All assistance gratefully received.

{"header":
{
  "account": "0000420",
  "reference": "1234",
  "name": "Fred Jones",
  "address": {
    "line": ["Address line 1",
    "Address line 2",
    "Address line 3",
    "Address line 4"
    ],
    "postcode": "post"
  },
  "deliverycountry": "GB",
  "invoicename": "Fred Jones",
  "invoicecountry": "GB",
  "instructions": "Sample text inst",
  "ordertype": "sale",
  "lines": [{
	  "line": {
	    "product": "ABC123",
	    "extendeddescription": "Product description",
	    "quantity": 1,
	    "price": 100
	  }
  }]
}
}

What I have tried:

I have googled, no joy, moved the braces and the square bracket, no joy.

Posted 4-Apr-19 1:46am

MKM_Matt

Updated 4-Apr-19 1:57am

Add a Solution

Comments

Richard Deeming 4-Apr-19 7:52am

We can't answer that - we have no idea what the API you're posting to is expecting.

As a pure guess, the nested line object looks a little suspicious to me. I'd expect it to look more like:

"lines":[{
    "product": "ABS123",
    "extendeddescription": "Product description",
    "quantity": 1,
    "price": 100
}]

But without knowing what the API expects, that's just a guess.

MKM_Matt 4-Apr-19 8:07am

Thanks Richard, yes you don't know the API I am putting it against, but appreciate the comment about the line looking suspicious, have changed so same as yours. I will go back to the providers and check the tags with them, (am thinking incorrect name now), but they are ridiculously slow at replying. Thanks again.

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)

OriginalGriff · Answer 1 · 2019-04-04T01:58:00

Check the data against your classes. A quick run through of that via json2csharp - generate c# classes from json[^]
gives:

C#

public class Address
{
    public List<string> line { get; set; }
    public string postcode { get; set; }
}

public class Line2
{
    public string product { get; set; }
    public string extendeddescription { get; set; }
    public int quantity { get; set; }
    public int price { get; set; }
}

public class Line
{
    public Line2 line { get; set; }
}

public class Header
{
    public string account { get; set; }
    public string reference { get; set; }
    public string name { get; set; }
    public Address address { get; set; }
    public string deliverycountry { get; set; }
    public string invoicename { get; set; }
    public string invoicecountry { get; set; }
    public string instructions { get; set; }
    public string ordertype { get; set; }
    public List<Line> lines { get; set; }
}

public class RootObject
{
    public Header header { get; set; }
}