3rd iPaaS Puzzle: Who’s Country is improving the most on the UN Sustainable Development Goals?

This is the third in a series of 5 iPaaS Puzzles we are posting in the next couple of weeks. Don’t we all love a little puzzle, even more if it helps us keep our webMethods skills sharp. If the solution is practical and immediately applicable to the benefit of the environment even better!

3rd iPaaS Puzzle: Who’s Country is improving the most on the UN Sustainable Development Goals?

The 2030 Agenda for Sustainable Development, adopted by all United Nations Member States in 2015, provides a shared blueprint for peace and prosperity for people and the planet, now and into the future. At its heart are the 17 Sustainable Development Goals (SDGs), which are an urgent call for action by all countries – developed and developing – in a global partnership.


Picture and Video from UNSD - Welcome to UNSD

How can iPaaS help in achieving this?

Help Countries look up data, by developing a connector for the UN Sustainability API using webMethods.io Integration Connector Builder

The best connector will be published to webMethods.io Integration and will be made available to all the users of webMethods.io Integration.


Use Custom Connectors to compare and derive statistics on how Countries perform on various goals.

Stretch goal

Create a game or dashboard that compares the development of different countries on one sustainability goal. To make the improvement numbers comparable between two countries, let’s calculate the delta improvement year over year.

One can even create a loop that pairs the winner against the next country until there is an overall winner countra for all 17 UN goals.


Please post your solution to the puzzle as replies to this thread.
Use the “blur spoiler” tag to hide your results so that folks must click on your solution to indicate they want to see it!

iPaaS Puzzle Show

Every other Friday for the next couple of weeks, we are hosting an iPaaS Puzzle Show.

We will briefly talk about the different solutions for this week’s puzzle, what to learn from them, and introduce next week’s iPaaS Puzzle. Hope you can join us.

We are officially kicking off the 3rd iPaaS Puzzle this Friday the 23rd of September:

APJ/EMEA 11.30am IST / 8am CEST

EMEA/Americas 11am EDT / 8am PDT / 5pm CEST

The 3rd iPaaS Puzzle show will be on Friday the 7th of October 8am CEST! and 5pm CEST! Details to come!


Just have your solution posted before the iPaaS Puzzle Show on Friday the 7th of October 8am CEST. If you want to be invited on the show, please post your solution by Thursday the 6th 8am CEST.


The winners get fame and glory. We want this to be a friendly competition and we want to highlight great work, without having to crown a weekly winner.

Suggest a Puzzle

If you have another great idea for an iPaaS Puzzle, please suggest it in this form . It should be a little challenge that is doable within a week and has easy access to the source data needed. If your challenge is geared towards improving our lives, then even better!

If your iPaaS Puzzle suggestion does get selected, we’d invite you to personally introduce it in our iPaaS Puzzle Show and you will receive a wooden Tangram game as a token of our appreciation.

The actual prize may look differently!