Trying to do subloop

  • Resolved laman7

    (@laman7)


    8 years, 5 months ago

    The JSON that I have produces this

    {
	"response": {
		"result": {
			"Candidates": {
				"row": [{
					"no": "1",
					"FL": [{
						"val": "CANDIDATEID",
						"content": "401682000000646210"
					}, {
						"val": "Experience in Years",
						"content": "5"
					}, {
						"val": "Created Time",
						"content": "2017-11-22 13:19:47"
					}, {
						"val": "Updated On",
						"content": "2017-11-22 21:10:24"
					}, {
						"val": "Currency",
						"content": "MYR"
					}, {
						"val": "Exchange Rate",
						"content": "1.000000000"
					}, {
						"val": "Last Activity Time",
						"content": "2017-11-24 18:24:58"
					}, {
						"val": "SMOWNERID",
						"content": "401682000000167003"
					}, {
						"val": "Email Opt Out",
						"content": "false"
					}, {
						"val": "Is Locked",
						"content": "false"
					}, {
						"val": "Is Unqualified",
						"content": "false"
					}, {
						"val": "Is Attachment Present",
						"content": "true"
					}, {
						"val": "Candidate Status",
						"content": "New"
					}, {
						"val": "Availability Date",
						"content": "2018-01-02"
					}, {
						"val": "Available for Contract",
						"content": "false"
					}, {
						"val": "Consultant Pay Rate",
						"content": "0"
					}, {
						"val": "Publish in Us",
						"content": "false"
					}, {
						"val": "Travel",
						"content": "false"
					}, {
						"val": "Part Time",
						"content": "false"
					}, {
						"val": "Client Billing Rate",
						"content": "0"
					}]
				},

    My code is
    [jsoncontentimporter url=https://recruit.zoho.com/recruit/private/json/Candidates/getRecords?authtoken=4c87896eab1c908dd883fb22c4e3e93f&scope=recruitapi basenode=response.result.Candidates.row] {no} <br> [/jsoncontentimporter]

    How do I get the “content” of “val: CANDIDATEID” for all? Do I need to do subloop?

    Thanks for your help

    • This topic was modified 8 years, 5 months ago by laman7.
Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author berkux

    (@berkux)

    8 years, 5 months ago

    Hi,

    try
    [jsoncontentimporter url=https://recruit.zoho.com/recruit/private/json/Candidates/getRecords?authtoken=4c87896eab1c908dd883fb22c4e3e93f&scope=recruitapi döebugmode=10 basenode=response.result.Candidates.row] {no} <br>
    {subloop-array:FL:-1}{FL.val}<br>{/subloop-array:FL}
    <hr>
    [/jsoncontentimporter]

    I always like to get a voting for my plugin here 🙂

    Bernhard

    Thread Starter laman7

    (@laman7)

    8 years, 5 months ago

    1. This works, however I dont want to display all info from the JSON.

    2. I am considering to purchase the pro version for search, or saving the value in php string. Can this be done?

    Plugin Author berkux

    (@berkux)

    8 years, 5 months ago

    The PRO-Version can do this (the free version is limited to select data out of the JSON):
    http://wptest.kux.de/recruit-zoho-com-2/

    [jsoncontentimporterpro url=https://recruit.zoho.com/recruit/private/json/Candidates/getRecords?authtoken=4c87896eab1c908dd883fb22c4e3e93f&scope=recruitapi parser=twig] 
{% for i in response.result.Candidates.row %}i.no: {{i.no}}: {{i.FL[2].content}}, {{i.FL[3].content}}, {{i.FL[4].content}}<br>{% endfor %}<hr>
[/jsoncontentimporterpro]
    • This reply was modified 8 years, 5 months ago by berkux.
Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Trying to do subloop’ is closed to new replies.