Formatting Json Input Data Source

[Masond3]

Afternoon Team, 

Hoping this lovely community can help me. 

I have spent the last couple of hours trying to get the desired output but not  having much had luck.

I have the following R Configuration

As you can see the R configuration just calls a particular URL. When executing the workflow i can see it returns a data set, however the data set it returns is as follows ;

{"data":[{"type":"fuzzycompletions","attributes":{"value":"CIT Bank"},"relationships":{"lei-records":{"data":{"type":"lei-records","id":"549300SM3PTSE5SHTE15"},"links":{"related":"https:\/\/api.gleif.org\/api\/v1\/lei-records\/549300SM3PTSE5SHTE15"}}}},{"type":"fuzzycompletions","attributes":{"value":"CITIBANK N A"}},{"type":"fuzzycompletions","attributes":{"value":"CITIBANK BERHAD"},"relationships":{"lei-records":{"data":{"type":"lei-records","id":"QINWV8RCPXRMH5IWUL13"},"links":{"related":"https:\/\/api.gleif.org\/api\/v1\/lei-records\/QINWV8RCPXRMH5IWUL13"}}}},{"type":"fuzzycompletions","attributes":{"value":"Citibank Canada"},"relationships":{"lei-records":{"data":{"type":"lei-records","id":"YJW4XPRSVL5L1ANG2086"},"links":{"related":"https:\/\/api.gleif.org\/api\/v1\/lei-records\/YJW4XPRSVL5L1ANG2086"}}}},{"type":"fuzzycompletions","attributes":{"value":"CIT BANK LIMITED"},"relationships":{"lei-records":{"data":{"type":"lei-records","id":"213800BDSS5OAYCMM819"},"links":{"related":"https:\/\/api.gleif.org\/api\/v1\/lei-records\/213800BDSS5OAYCMM819"}}}},{"type":"fuzzycompletions","attributes":{"value":"CITIBANK SENEGAL"},"relationships":{"lei-records":{"data":{"type":"lei-records","id":"5493004OQLIOSZL7YK83"},"links":{"related":"https:\/\/api.gleif.org\/api\/v1\/lei-records\/5493004OQLIOSZL7YK83"}}}},{"type":"fuzzycompletions","attributes":{"value":"Citibank Gabon SA"},"relationships":{"lei-records":{"data":{"type":"lei-records","id":"549300VCGUSH7TB4IS76"},"links":{"related":"https:\/\/api.gleif.org\/api\/v1\/lei-records\/549300VCGUSH7TB4IS76"}}}},{"type":"fuzzycompletions","attributes":{"value":"CITIBANK ARUBA N.V."},"relationships":{"lei-records":{"data":{"type":"lei-records","id":"549300QK978F6WDQIK25"},"links":{"related":"https:\/\/api.gleif.org\/api\/v1\/lei-records\/549300QK978F6WDQIK25"}}}},{"type":"fuzzycompletions","attributes":{"value":"Citibank Korea Inc."},"relationships":{"lei-records":{"data":{"type":"lei-records","id":"745P3MMS7E8CUVXDRJ82"},"links":{"related":"https:\/\/api.gleif.org\/api\/v1\/lei-records\/745P3MMS7E8CUVXDRJ82"}}}},{"type":"fuzzycompletions","attributes":{"value":"CITIBANK UK LIMITED"},"relationships":{"lei-records":{"data":{"type":"lei-records","id":"549300U8H3KN0K301B23"},"links":{"related":"https:\/\/api.gleif.org\/api\/v1\/lei-records\/549300U8H3KN0K301B23"}}}}]}` = col_character()

What i would like to do is transpose this data into the following Desired out come :

fuzzycompletions	Lei- Record	Link
CIT Bank	549300SM3PTSE5SHTE15	https://api.gleif.org/api/v1/lei-records/549300SM3PTSE5SHTE15
CITIBANK N A		https://api.gleif.org/api/v1/lei-records/
CITIBANK BERHAD	QINWV8RCPXRMH5IWUL13	https://api.gleif.org/api/v1/lei-records/QINWV8RCPXRMH5IWUL13
Citibank Canada	YJW4XPRSVL5L1ANG2086	https://api.gleif.org/api/v1/lei-records/YJW4XPRSVL5L1ANG2086
CIT BANK LIMITED	213800BDSS5OAYCMM819	https://api.gleif.org/api/v1/lei-records/213800BDSS5OAYCMM819

I am using Alteryx Version 19.3 

Looking forward to your assistance 

Regards
Masond3

[BrandonB · Accepted solution]

Here you go!