Nested JSON file import problems

Hi vybory2016,

unfortunately the free version can’t handle this JSON. I tried, but the way objects and arrays are nested is not compatible.

For those JSONs I implemented the twig-templateengine which can do it very simple, but this is a pro-feature:

[jsoncontentimporterpro url=”https://www.compositorsoftware.com/logs/sas24p3lstat.json” parser=”twig”]
{{pattrstorage.slots[1].data.allevents[0]}}
{{pattrstorage.slots[1].data.answer[0]}}
{{pattrstorage.slots[1].data.arouse[0]}}
{{pattrstorage.slots[1].data.call[0]}}
{{pattrstorage.slots[1].data.discussion[0]}}
{{pattrstorage.slots[1].data.envy[0]}}
{{pattrstorage.slots[1].data.growl[0]}}
{{pattrstorage.slots[1].data.hello[0]}}
{{pattrstorage.slots[1].data.threat[0]}}
[/jsoncontentimporterpro]

Bernhard

Hi Bernhard,

Can I at least try the Pro version to verify it works on my site?

You have to buy the pro-version first. I’ll promise full refund if the pro-version is not what you need.

Can the free version handle something like this:
{"pricing_plans":[{"data":{"id":3,"name":"Pro","amount":"436.0","sms_allowed":3200,"created_at":"2016-03-29T06:52:43.945Z","updated_at":"2016-03-29T06:52:43.945Z","discount_percentage":"0.1","plan_type":"Paid"}},{"data":{"id":2,"name":"Basic","amount":"0.2","sms_allowed":3200,"created_at":"2016-03-29T06:52:18.253Z","updated_at":"2016-03-29T06:52:18.253Z","discount_percentage":"0.1","plan_type":"Paid"}},{"data":{"id":1,"name":"Lite","amount":"157.0","sms_allowed":3200,"created_at":"2016-03-29T06:30:57.117Z","updated_at":"2016-03-29T06:30:57.117Z","discount_percentage":"0.1","plan_type":"Paid"}}]}

@tjwizking:yes, try

[jsoncontentimporter url=”….json” basenode=”pricing_plans”]
{subloop:data:-1}{id}: {amount}{/subloop:data}
[/jsoncontentimporter]

Bernhard

That works! Thanks Bernhard. Grateful.

Hi,

Can free version handle this kind of json?
[{“AwardedBids”:[{“AwardedText”:[“EP-1216-Proposal – Automation Program Ma”,”EP-1219-Proposal – RFQ-8899 – Westerly C”,”EP-1225-Proposal / RFQ-9242 E.M.S.C. Fi”,”RFQ-10061-Bid-Substation Preventative Main”,”RFQ-10205-Bid – Ferric Chloride Solution -“,”RFQ-10352R-Re-Bid – RFQ-10352R Grit and Scr”,”RFQ-10569-Bid- 450 Type Truck with Utility”],”AwardedUrl”:[“https://test.org/birds.php?a=a_bid&i=2375″,”https://test.org/birds.php?a=a_bid&i=2390″,”https://test.org/birds.php?a=a_bid&i=2396″,”https://test.org/birds.php?a=a_bid&i=2414″,”https://test.org/birds.php?a=a_bid&i=2417″,”https://test.org/birds.php?a=a_bid&i=2418″,”https://test.org/birds.php?a=a_bid&i=2421″%5D,”AwardedType”:[“Engineering/Construction”,”Engineering/Construction”,”Engineering/Construction”,”Operations-Required”,”Operations-Required”,”Operations-Required”,”Operations-Required”]}],”OpenedBids”:[{“OpenText”:[“EB-2366-Bid – Shaw Brook Culvert Rehabil”,”EP-1241-Proposal – Cuyahoga River North”,”EP-1243-Proposal – CIP General Environme”,”P-1242-Proposal – Investment Advisory S”,”P-1244-Proposal – Diversity and Inclusi”,”RFQ-11034-Bid – Roof Deck Restoration SSA”],”OpenUrl”:[“https://test.org/birds.php?a=con_bid&i=2434″,”https://test.org/birds.php?a=con_bid&i=2430″,”https://test.org/birds.php?a=con_bid&i=2433″,”https://test.org/birds.php?a=con_bid&i=2431″,”https://test.org/birds.php?a=con_bid&i=2437″,”https://test.org/birds.php?a=con_bid&i=2427″%5D,”OpenType”:[“EB-2366-Bid – Shaw Brook Culvert Rehabil”,”EP-1241-Proposal – Cuyahoga River North”,”EP-1243-Proposal – CIP General Environme”,”P-1242-Proposal – Investment Advisory S”,”P-1244-Proposal – Diversity and Inclusi”,”RFQ-11034-Bid – Roof Deck Restoration SSA”]}],”ProposalBids”:[{“ProposalText”:[“EB-2357-Bid – RFQ-8105 Southerly Main Su”,”EB-2362-Bid – East 140th Street Consolid”,”EB-2363-Bid – (RFQ-10062) CSO 236 SWO Re”,”EB-2364-Bid – Superior Stones Canal CSO”,”EB-2365-Bid – Euclid Creek Channel Repai”,”EP-1214-Proposal – Morgana Run Relief Se”,”EP-1215-Proposal – Southerly Optimized P”,”EP-1226-Proposal – RFQ-9243 Combined Se”,”EP-1227-Proposal – GES – Treatment/Colle”,”EP-1228-Proposal – GES – Mechanical/Elec”,”EP-1231-Proposal – Cuyahoga River South”,”EP-1233-Proposal – Combined Sewer System”,”EP-1234-Proposal – Doan Valley Relief an”,”EP-1235-Proposal RFQ-10202 / Dugway Regu”,”EP-1236-Proposal – Air Emissions Stack T”,”EP-1238-Proposal – District Wide Decommi”,”EP-1239-Proposal – Beneficial Reuse of B”,”EP-1240-Proposal – London Road Relief Se”,”P-1188-Proposal – RFQ-4554 Underwriting”,”P-1197-Proposal – Good Neighbor Ambassa”,”P-1204-Proposal – Customer Inquiry Trac”,”P-1212-Reverse Auction Management Servi”,”P-1220-Proposal – Job Evaluation Assess”,”P-1224-Proposal – Court Reporting and T”,”P-1237-Proposal – GJM Core Switch Repla”,”RFQ-10985-Bid – Snow Plowing Service Domin”,”RFQ-11070-Bid – Stream Sediment and Debris”,”RFQ-6631-Proposal – (RFQ) Request for Qua”,”RFQ-7437-Bid – REF’s Scrubber Process and”,”RFQ-7438/R-Re-Bid 7438R-9201 REF Steam Turb”,”RFQ-7440-Bid – REF’s General Mechanical E”],”ProposalUrl”:[“https://test.org/birds.php?a=o_bid&i=2371″,”https://test.org/birds.php?a=o_bid&i=2412″,”https://test.org/birds.php?a=o_bid&i=2413″,”https://test.org/birds.php?a=o_bid&i=2415″,”https://test.org/birds.php?a=o_bid&i=2419″,”https://test.org/birds.php?a=o_bid&i=2368″,”https://test.org/birds.php?a=o_bid&i=2369″,”https://test.org/birds.php?a=o_bid&i=2397″,”https://test.org/birds.php?a=o_bid&i=2401″,”https://test.org/birds.php?a=o_bid&i=2402″,”https://test.org/birds.php?a=o_bid&i=2405″,”https://test.org/birds.php?a=o_bid&i=2409″,”https://test.org/birds.php?a=o_bid&i=2411″,”https://test.org/birds.php?a=o_bid&i=2416″,”https://test.org/birds.php?a=o_bid&i=2420″,”https://test.org/birds.php?a=o_bid&i=2424″,”https://test.org/birds.php?a=o_bid&i=2425″,”https://test.org/birds.php?a=o_bid&i=2426″,”https://test.org/birds.php?a=o_bid&i=2314″,”https://test.org/birds.php?a=o_bid&i=2328″,”https://test.org/birds.php?a=o_bid&i=2341″,”https://test.org/birds.php?a=o_bid&i=2364″,”https://test.org/birds.php?a=o_bid&i=2384″,”https://test.org/birds.php?a=o_bid&i=2393″,”https://test.org/birds.php?a=o_bid&i=2422″,”https://test.org/birds.php?a=o_bid&i=2428″,”https://test.org/birds.php?a=o_bid&i=2429″,”https://test.org/birds.php?a=o_bid&i=2346″,”https://test.org/birds.php?a=o_bid&i=2361″,”https://test.org/birds.php?a=o_bid&i=2395″,”https://test.org/birds.php?a=o_bid&i=2363″%5D,”ProposalType”:[“Engineering/Construction”,”Engineering/Construction”,”Engineering/Construction”,”Engineering/Construction”,”Engineering/Construction”,”Engineering/Construction”,”Engineering/Construction”,”Engineering/Construction”,”Engineering/Construction”,”Engineering/Construction”,”Engineering/Construction”,”Engineering/Construction”,”Engineering/Construction”,”Engineering/Construction”,”WaterShed”,”Engineering/Construction”,”WaterShed”,”Engineering/Construction”,”Finance”,”Other”,”Information Technology”,”Finance”,”Other”,”Legal”,”Information Technology”,”Operations-Required”,”Operations-Required”,”Finance”,”Operations-Required”,”Operations-Required”,”Operations-Required”]}]}]

maybe ??
I copypased the JSON and my software said that this is invalud json.
maybe something wnt wrong when copying into this forum.
the best way is, that you send me a url or file with the json at info AT json-content-importer.com
check at https://jsonviewer.stack.hu/ that it is valid json.

Hi ,

I am using PRO version but parsing is not working with either Twig or nodebase.
JSON : [{
“overall_officials”: [{
“last_name”: [“Anuja Jhingran, MD”],
“role”: [“Principal Investigator”],
“affiliation”: [“M.D. Anderson Cancer Center”]
}],
“primary_outcome”: [{
“measure”: [“Disease-free survival”],
“time_frame”: [“From randomization to date of first failure (local, regional, or distant metastases failure or death due to any cause) or last follow-up. Analysis occurs after 43 disease-free survival failure events on Cisplatin/RT Arm.”],
“safety_issue”: [“No”]
}],
“secondary_outcome”: [{
“measure”: [“Overall survival”],
“time_frame”: [“From randomization to date of death or last follow-up. Analysis occurs after all patients have been potentially followed for 4 years.”],
“safety_issue”: [“No”]
}, {
“measure”: [“Chemotherapy-induced neuropathy as measured by FACT-GOG/NTX4”],
“time_frame”: [“From completion of concurrent chemoradiation to 12 months.”],
“safety_issue”: [“No”]
}, {
“measure”: [“Quality of life as measured by FACT-Cx and FACIT-D”],
“time_frame”: [“From completion of concurrent chemoradiation to 12 months.”],
“safety_issue”: [“No”]
}],
“keywords”: [“cervical adenocarcinoma”, “cervical adenosquamous cell carcinoma”, “cervical squamous cell carcinoma”, “stage IA cervical cancer”, “stage IB cervical cancer”, “stage IIA cervical cancer”]
}]

Code :
[jsoncontentimporterpro url=”https://clinicalresearch.miami/details/NCT00980954/.json” basenode = “overall_officials”]

{last_name}

[/jsoncontentimporterpro]

• This reply was modified 8 years ago by techcartels.

Hi,

see https://api.json-content-importer.com/api-clinicalresearch-miami/
and switch to info AT json-content-importer.com

Bernhard

• This reply was modified 8 years ago by berkux.