Forum Discussion
Generate json data from web url stored in a table column
Community SupportHi Anonymous ，
Is that your excepted reuslt? If it doesn't meet your requirement, kindly share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.
Column = MID ( 'Table'[Self], LEN ( 'Table'[Self] ) - 3, 3 )
Thanks for your reply,
My report is full of confidential data, it is nearly impossible to remove them...
Anyway, I will show you a few examples:
Example 1
[self] column
https://jira.xxx.com/rest/api/2/issue/49407
json data
"customfield_10608":[{"id":"155","name":"Curious - MOX MIS","_links":{"self":"https://jira.xxx.com/rest/servicedeskapi/organization/155"}}]
[Column]
Id 155 (or name Curious - MOX MIS)
Example 2
https://jira.xxx.com/rest/api/2/issue/45442
json data
"customfield_10608":[{"id":"43","name":"West Essex","_links":{"self":"https://jira.xxx.com/rest/servicedeskapi/organization/43"}}]
[Column]
Id 43 (or name West Essex)
Example 3
https://jira.xxx.com/rest/api/2/issue/45421
json data
"customfield_10608":[{"id":"31","name":"RISE","_links":{"self":"https://jira.xxx.com/rest/servicedeskapi/organization/31"}}]
[Column]
Id 31 (or name Rise)
The column self contains the URL for the json data and on the new column, I need the ID customer name or the customer name.
If you need the report file I might able to send you directly without publishing here.
Thanks a lot for your help.