not able to json parse and goto nextpage

Question

Hi, I am having a challenge with the below data. I cannot paste workflow due to security issues. Here is my data:

EmpCollection:
URI:http://empdata.com/v1/survey/?emptemplateid=1?pageIndex=1&pagesize=30
pagination:
  currrentpage:1
  totalpages: 7
  resourcesperpage: 30
  resourcesreturned: 30
  totalresources: 193
  nexturl: http://empdata.com/v1/survey/?emptemplateid=2?pageIndex=1&pagesize=30
data:
  empresponse:
       fname:dinesh
      lname: ka
      createdby:
            isactive: y
            status: yes
      class: 10

empresponse:
       fname:vydi
      lname: ka
      createdby:
            isactive: y
            status: yes
      class: 11

empresponse:
       fname:viru
      lname: ka
      createdby:
            isactive: y
            status: yes
      class: 11

Requirement -  I have an API with huge data that return 30 records per page and it is having 7 pages. I have multiple issues.

I'm able to see these columns and data in API download tool - URL, DownloadData, DownloadHeaders

1st Issue - DownloadData - I'm not getting all data. It says "Cell has > 256 characters".

2nd Issue -  When i add json parser, am getting conversion error  and not able to see data in  columns.

Also, how do i do iterative macro?

Raj_007 · Answer

Conversion Error72Error message: Invalid value. at character position: 1Hi All, I am getting the same error - download tool - and i checked the encode URL text, and the output to a field is string , data encoded as UTF-8then JSON field=DownloadData - tried both options of single string field and also output values into multiple based on data typesi have been going through for few hours and not able to figure out -- any ideas please

Dinesh13 · Answer

Hi, I'm getting JSON Parse (37) Error message: Invalid value.  at character position: 0. I think the data is in xml but it doesn't look like that for me.

davidskaife · Answer

Hi @Dinesh13

1st Issue - don't worry about this one, your data is there and this message can be considered a warning. If you were missing data you'd get a message saying the data was truncated instead. Alteryx just won't display more than 256 characters (unless you use a browse tool). For API calls the Download Data column is usually very long anyway so i'd expect that.

2nd Issue - could you share the error message and your configuration? Usually the JSON Parse tool returns the data in a useable format but you have to use additional tools - this challenge solution covers parsing JSON extracted via an API which may be able to help you as well -> https://community.alteryx.com/t5/Weekly-Challenge/Challenge-7-Download-Data-and-Parse-JSON/td-p/36734

Iterative macros - there is a wealth of info here -> https://community.alteryx.com/t5/Interactive-Lessons/tkb-p/interactive-lessons/label-name/Macros which includes learning on creating an iterative macro. In addition within Alteryx under Help-Sample Workflows there are examples to look at.