Bjwebb

declare namespace output = "http://www.w3.org/2010/xslt-xquery-serialization";
declare option output:method "csv";
declare option output:csv "header=yes, separator=comma";
<csv>{
for $org in /iati-organisations/iati-organisation
  return <record>
      <organisation-identifier>{
          if ($org/organisation-identifier)
          then $org/organisation-identifier/text()
          else $org/iati-identifier/text()

Bjwebb

import os
import json

import requests

repos = requests.get('https://api.github.com/orgs/OpenDataServices/repos?per_page=200').json()
for repo in repos:
    protection = requests.get(
        "https://api.github.com/repos/OpenDataServices/{}/branches/master/protection".format(repo["name"]),
        headers={"Authorization":  "token {}".format(os.environ["GH_TOKEN"])},

Bjwebb

<codelist><metadata/><codelist-items>{
for $org in /iati-organisations/iati-organisation
  let $code := if ($org/organisation-identifier)
          then $org/organisation-identifier/text()
          else $org/iati-identifier/text()
  return if ($code = $org/reporting-org/@ref/data()) then
    <codelist-item>
      <code>{$code}</code>
      {if ($org/name/narrative)
        then $org/name else

Bjwebb

from lxml import etree
root = etree.parse('csvconv.xml')
for activity in root.findall('iati-activity'):
    for transaction in activity.findall('transaction'):
        if transaction.find('value').text is None:
            activity.remove(transaction)
root.write('transactions_removed.xml')

Bjwebb

{
  "uri": "tmXf6cC4QU+lwO3O73T-ZvUX4qo2GMJ0Sd",
  "publisher": {
    "name": "ducimus recusandae"
  },
  "publishedDate": "4440-04-11T01:58:02.871Z",
  "releases": [
    {
      "ocid": "et et tempora eos est",
      "id": "facere",

Bjwebb

{
    "uri": "http://example.org/invalid_record.json",
    "version": "1.1",
    "publishedDate": "2019-09-18T17:56:21.078Z",
    "publisher": {
        "name": "A Publisher Name"
    },
    "records": [
        {
            "ocid": "EXAMPLE-0",

Bjwebb

import os
import json
import jsonref

# From libcove/lib/common.py
class CustomJsonrefLoader(jsonref.JsonLoader):
    '''This ref loader is only for use with the jsonref library
    and NOT jsonschema.'''

    def get_remote_json(self, uri, **kwargs):

Bjwebb

<?xml version='1.0' encoding='UTF-8'?>
<!--This is example XML for the IATI activity standard.  No reference to actual data, real organisations or development cooperation models is intended.-->

<!--iati-activities starts-->
<iati-activities generated-datetime="2014-09-10T07:15:37Z" version="2.03" linked-data-default="http://data.example.org/">

 <!--iati-activity starts-->
 <iati-activity xml:lang="en" default-currency="USD" last-updated-datetime="2014-09-10T07:15:37Z" humanitarian="1" linked-data-uri="http://data.example.org/123456789" hierarchy="1" budget-not-provided="1">

  <!--iati-identifier starts-->

Bjwebb

Bjwebb