LinkedIn Learning Report Download API -> JSON to CSV

Help Studio
, , , , ,
1

Hello Developers…

Need your assistance to achieve LinkedIn Learning Report JSON to CSV.

Objective:

  1. LinkedIn learning report download API call
  2. Received JSON response to CSV

JSON response | Below is 1 item, simarly have some 90 items in the response file:
{“paging”:{“start”:0,“count”:1000,“links”:,“total”:90},
“elements”:[{
“learnerDetails”:
{“name”:" “,
“enterpriseGroups”:,
“email":"sample@email.com”,
“entity”:
{“profileUrn”:“urn:li:enterpriseProfile:(urn:li:enterpriseAccount:11111111,222222224)”},
“uniqueUserId”:”",
“customAttributes”:{}},
“activities”:[
{“engagementType”:“SECONDS_VIEWED”,
“firstEngagedAt”:1597931100000,
“lastEngagedAt”:1597934700000,
“engagementMetricQualifier”:“TOTAL”,
“engagementValue”:912,“assetType”:“COURSE”},
{“engagementType”:“PROGRESS_PERCENTAGE”,
“lastEngagedAt”:1597934700000,
“engagementValue”:22,“assetType”:“COURSE”}],
“contentDetails”:
{“name”:“HR and Digital Transformation”,
“contentSource”:“EXTERNAL”,
“contentUrn”:“urn:li:lyndaCourse:756286”,
“locale”:
{“country”:“US”,
“language”:“en”}}},

Tried with below:

  1. Used custom activity, but got all the data in single row
  2. Deserialize JSON array didn’t work, because it says at the starting of the JSON file is not an array.
  3. Deserialize JSON, it worked, but when I use for each with JSON Object and argument type as JObject, it says “object reference not set”

One of the code snippet, which I tried:
image

Please assist.

Thank You.

Regards,
Rajesh Attada

Finding my Path → Using UiPath

2

Hello @Rajesh.Attada01,

Looks like you have posted an extract of the JSON here. Could you please post the exact JSON in a text file (With atleast 2 records).

Regards,
Nithin

1 Like
3

Nithin,

Firstly, thank you so much for coming forward to assist me.
This means a lot.

PFA for the LinkedIn_Learning_Report_Download_APICall_JSON_Response fileLinkedIn_Learning_Report_Download_APICall_JSON_Response.txt (4.0 KB)

Attached JSON file contains couple of learnerDetails as you requested.
Names, email-ids and group names are changed to achieve compliance issue.

Thank You.

Regards,
Rajesh Attada

Finding my Path → Using Uipath

1 Like
4

Hi,

Please try the following:

  1. After deserialize Json activity, get the JObj(“elements”) to a string.
  2. Deserialize the Json array from the string above and then try extracting the learnerDetails.
1 Like
5

Sowmya,

Thank You so much for coming forward to assist me.

About JObj(“elements”) to a string, is it with a assign activity?
String = JObj(“elements”)

Also Extracting learnerDetails, is it like below?

For each item of JArray(“learnerDetails”)
{
Item(“name”).Value
Item (“email”).Value
And so on
}

Please assist.

Thank You.

Regards,
Rajesh Attada

Finding my Path —> Using UiPath

6
  1. Deserialize Json activity (The one you already have )
  2. Deserialize Json Array activity - The Json String will be Response(“elements”).ToString - save the output to the Json Array variable
  3. ForEach Item in JsonArrayVariable - item will be of type JObject
    item(“learnerDetails”)(“name”).ToString - to access the name
2 Likes
7

Sowmya,

I can’t express my happiness.
You made my day :smiley:

Finally I see some output, now understood a bit on how to read data from JSON.
From here I will explore on how to get my relevant data to a datatable and write it to CSV.

Can’t forgot your help.
Thank You so much :handshake:

Regards,
Rajesh Attada

Finding my Path → Using Uipath

1 Like
8

Glad I was able to help :slight_smile: Good luck and Happy automation…

1 Like
9

Thank you so much Sowmya :blush:
Great help :handshake:

Regards
Rajesh Attada

Finding my Path → Using Uipath

10

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.