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

Paypal Pagination (8 replies)

Browndog
4 years ago
Browndog 4 years ago

Hi,

I am trying to get a simple transaction search json reader for Paypal working in Iman, I have proven the request in Postman but am struggling to replicate in Iman. I believe it is down to pagination but have exhausted all possible options that I am aware of.

In the reader I can get one result displayed successfully with the information I want however not all of the results from the query. After trying all webservice behaviour option I decided to set pagination to none and use the url in the reader which should replicate the request from postman, I still only get one result in the preview. I am sure it is something I am doing wrong but am at a loss as to what it is. Please advise how to debug this?

Thanks

https://www.realisable.co.uk/wp-content/uploads/2020/09/preview.jpg
Browndog
4 years ago
Browndog 4 years ago

Request with data attached

https://www.realisable.co.uk/wp-content/uploads/2020/09/request.jpg
Support
4 years ago
Support 4 years ago

Browndog, can you show me your Webservice Behaviour? And also the setup of your JSON Reader?

Browndog
4 years ago
Browndog 4 years ago

Hi, it is currently set as attached, I have tried using url pagination here with various options all with the same result

https://www.realisable.co.uk/wp-content/uploads/2020/09/webservice.jpg
Browndog
4 years ago
Browndog 4 years ago

Json reader attached, using full request here

 

/v1/reporting/transactions?start_date=2020-08-10T12:31:17-0000&end_date=2020-09-01T23:31:17-0000&fields=all&page_size=100&page=1

https://www.realisable.co.uk/wp-content/uploads/2020/09/json.jpg
Browndog
4 years ago
Browndog 4 years ago

Json entry point, I have some doubt about this as felt the transaction_info should have been under the transaction ID but was the only way I could get the values to show

/transaction_details/transaction_info

Browndog
4 years ago
Browndog 4 years ago

Field setting

https://www.realisable.co.uk/wp-content/uploads/2020/09/transaction.jpg
Support
4 years ago
Support 4 years ago

OK, thanks.

  1. Pagination - Set your pagination per the screenshot below.
  2. JSON Entry Point - Should be pointing to the first recurring node/array. In this instance it is /transaction_details
  3. Your fields should then be prefixed by transaction_info so the id field will have the JPath of transaction_info/transaction_id

This will get you going.

Browndog
4 years ago
Browndog 4 years ago

All working now, many thanks

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