Calc with data from 2 JSON-URLs

Your challenge: You have 2 JSON-URLs/APIs. You want to bring together these 2 and calculate with data out of both JSON-datasources.

The solution: Put both JSON-URLs/APIs (completely or only needed parts of it) into one JSON and calculate.

This is done by the PRO-version of the JSON Content Importer Plugin in this way:

1. Create a new entry in the plugins template-manager as JSON-styled template for the 1st JSON:
   JSON-URl-1 (put this into template-manager entry):
   http://api.json-content-importer.com/extra/json/n1.json

   Template-Code:
   ,{“json2”: {“no2”:{{no2}} } }

   Name the template like “calc1” or something….

   Remember the no of this template.

2. Create a 2nd new entry in the plugins template-manager as JSON-styled template containing a nested-shortcode of the plugn to get the 2nd JSON.
   Example:
   JSON-URl-1 (put this into template-manager entry):
   http://api.json-content-importer.com/extra/json/n2.json

   Template-Code:
   {“json”:[{“json1”: {“no1”:{{no1}} }} No URL defined - plugin aborted: Check url= parameter, remove quotation marks and linefeeds!

   ---

   ]}
   “NUMBER_OF_TEMPLATE_FROM_STEP1” is the template-manager-no of the frist created template.

   Name the template like “calc2” or something….

   Remember the no of this template.

3. Create a new page with that shortcode:
   No URL defined - plugin aborted: Check url= parameter, remove quotation marks and linefeeds!

   ---

   and publish this page.

   In the example the page is named “multiply” and http://api.json-content-importer.com/multiply/?show=oc shows valid JSON-data.
   The “?show=oc” is NEEDED, as this removes the WordPress-Temaplte and gives pure JSON.

   If there are <p> in this JSON (see sourcecode in browser for that): Switch off wpautop at the Pluginoptions>Settings>”Use wpautop or not” by selecting “remove wpautop”

4. Create another new template-manager entry:

   
   json1: {{json[0].json1.no1}}
   json2: {{json[1].json2.no2}}
   multiply: {{json[0].json1.no1 * json[1].json2.no2}}

   and URL: http://api.json-content-importer.com/multiply/?show=oc

   Name the template like “calc3” or something….

   Remember the no of this template.

5. Create another new page with that shortcode:
   No URL defined - plugin aborted: Check url= parameter, remove quotation marks and linefeeds!

   ---

In action:

json1: 8
json2: 5
multiply: 40