Back to forum list… Back to How Do I?...

JSON Reader Post Request Syntax (5 replies)

Chad Hadwick
4 years ago
Chad Hadwick 4 years ago

Hi 

I just need a little help as I am setting up a JSON reader but my predicate is a POST Request in the body.

I can succesfully get the response through postman but when setting up in iman not sure where I am getting wrong so I attached screenshots if you can help thanks.

https://www.realisable.co.uk/wp-content/uploads/2020/09/Postman.png
https://www.realisable.co.uk/wp-content/uploads/2020/09/JSON-reader.png
https://www.realisable.co.uk/wp-content/uploads/2020/09/error-syntax.png
Support
4 years ago
Support 4 years ago

Hi, we don't have an actual service where we can test your requirements, however we think the following should work.

  1. Change the URL to:

    /api/3.5/api.php?request=getAccpacData&start_date=2001-01-31&end_date=2020-12-31

  2. Remove the value in the Post Request.
  3. Remove the Content-Type header.
Chad Hadwick
4 years ago
Chad Hadwick 4 years ago

Hiya

Actually that was my first URL and I had errors so I decided to populate the Post Request since the API is a POST and the request is in the body but for some reason IMAN does not like that.

I am at my wits end now 🙁

Do you have some examples of JSON reader that uses POST because the KB seems to cater for GET.

I will really appreciate.

https://www.realisable.co.uk/wp-content/uploads/2020/09/Screenshot-2020-09-16-175109.png
Chad Hadwick
4 years ago
Chad Hadwick 4 years ago

Hi

I think the problem is the JSON Entry Point, my URL is as follows:

https://www.fakeurl.com/api/v3.5/api.php?request=getAccpacData&start_date=2020-01-31&end_date=2020-12-31

So the question is what would be my entry point?

I have been using /api.php but it seems IMan does not like the .php, can you advise if there is a way to escape the period?

Chad Hadwick
4 years ago
Chad Hadwick 4 years ago

Oh and my data looks like this so not sure what IMan needs because the documentation seems to be specific on the entry point name https://www.realisable.co.uk/support/Documentation/iman-user-guide/Readers/JSON.htm

[
    {
        "id": 3,
        "vendor_id": "SAX001",
        "capture_date": "2020-08-30",
        "invoice_no": 0,
        "invoice_date": "2020-08-30",
        "pm_total_incl_vat": 2587.5,
        "job_code": "555",
        "gl_code": "7037",
        "description": "Landscaping",
        "amount_excl_vat": "2250.00",
        "vat_percent": 15
    }
]
Chad Hadwick
4 years ago
Chad Hadwick 4 years ago

Solved by adding the entry point in the transaction JSON path. 

 
 

Transaction JSON Path

Contact

Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

Looking to purchase IMan, please see our resellers here.

Realisable Software
Ph: +44 (0) 208 123 1017

Copyright © Realisable. All rights reserved.
Realisable is a registered trademark

Close

Request Demo

Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

Looking to purchase IMan, please see our resellers here.

Realisable Software
Ph: +44 (0) 208 123 1017

Copyright © Realisable. All rights reserved.
Realisable is a registered trademark

Close

Access Downloads

Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

Looking to purchase IMan, please see our resellers here.

Realisable Software
Ph: +44 (0) 208 123 1017

Copyright © Realisable. All rights reserved.
Realisable is a registered trademark

Close