Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Getting data dinamically from all pages in JSON

  1. #1
    Join Date
    Jan 2016
    Posts
    2

    Question Getting data dinamically from all pages in JSON

    Hi all,

    I`m executing a transformation using Rest client and i got a json with 695 pages that insert the first 100 rows that come from page 0, but i want get all data from all pages dinamically.
    any suggestion will be very grateful

    {
    "ok": false,
    "transactions": [
    {
    "_key": "eb8d1078",
    "created": "2016-01-13T12:59:43+01:00",
    "status": "P",
    },
    {
    "_key": "7f471153",
    "created": "2016-01-13T12:58:58+01:00",
    "status": "P",
    },..........................................
    ],
    "count": 69518,
    "page": 0,
    "pages": 695,
    "from": "2014-01-01T00:00:00+01:00",
    "to": "2016-01-13T23:59:59+01:00"
    }

  2. #2

    Default

    This looks like a pattern where one has to make repeat REST calls to get all of the data. I think you will have to script that externally.

  3. #3
    Join Date
    Apr 2008
    Posts
    4,696

    Default

    I've seen this posted here before with a solution... But I can't remember the solution.

  4. #4
    Join Date
    Jan 2016
    Posts
    2

    Default

    I "solve " my problem using javascript, not was the best way, because the query are calling 695 URLs and i dont have the best performance but , until then i have a best way. It`s working.

    sorry my english

    and thanks for replying

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.