We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Converting JSON from an API to a nice clean table

DKMI
7 - Meteor

Everyone here is so helpful, but I wonder if anyone can help with this.

 

I have the following data, and want it in a nice clean table

 

{
    "value": [
        {
            "type": "AssignmentCardLearning",
            "user_id": 112913,
            "external_user_id": "vwr@company.com",
            "external_email": "vwr@company.com",
            "plp_id": 1807,
            "external_plp_id": null,
            "module_id": 4545,
            "external_context_id": "",
            "class_id": 12503,
            "external_assignment_id": "",
            "assignment_id": 31972,
            "progress": 0,
            "completion_date": null
        },
        {
            "type": "AssignmentCardLearning",
            "user_id": 112913,
            "external_user_id": "vwr@company.com",
            "external_email": "vwr@company.com",
            "plp_id": 1807,
            "external_plp_id": null,
            "module_id": 4555,
            "external_context_id": "",
            "class_id": 12503,
            "external_assignment_id": "",
            "assignment_id": 31972,
            "progress": 0,
            "completion_date": null
        },
        {
            "type": "AssignmentCardLearning",
            "user_id": 112913,
            "external_user_id": "xyz@company.com",
            "external_email": "xyz@company.com",
            "plp_id": 1807,
            "external_plp_id": stuff,
            "module_id": 4612,
            "external_context_id": "",
            "class_id": 12503,
            "external_assignment_id": "",
            "assignment_id": 31972,
            "progress": 0.14,
            "completion_date": null
        }
    ],
    "paging": {
        "next_page": "/api/v1/eud/outcome?eud-id=1234etc""
    },
    "transaction_id": 166530

 

How could I use Alteryx to output it like the following:

 

typeuser_idexternal_user_idexternal_emailplp_idexternal_plp_idmodule_idexternal_context_idclass_idexternal_assignment_idassignment_idprogresscompletion_date
AssignmentCardLearning112913vwr@company.comvwr@company.com1807null4545 12503 319720null
AssignmentCardLearning112913vwr@company.comvwr@company.com1807null4555 12503 319720null
AssignmentCardLearning112914xyz@company.comxyz@company.com1807stuff4612 12503 319720.14null
3 REPLIES 3
PhilipMannering
16 - Nebula
16 - Nebula

Hi @DKMI 

 

Something like this should do the trick,

image.png

PhilipMannering
16 - Nebula
16 - Nebula

Made some fixes to the json to make it valid.

DKMI
7 - Meteor

amazing!

Labels
Top Solution Authors