topic What's the API call to retrieve hierarchical reference list in SAS Viya

What's the API call to retrieve hierarchical reference list

uncle_ho — Tue, 14 Mar 2023 13:37:41 GMT

Hello

Have any of you figured out how to get a hierarchical list with an API/URL call?

Like lists with this url?

svi-datahub/admin/lists?name=OBJECTNAME

Example:

On the Viya Admin page (Manage Investigate and Search), on the "Data Object" tab and the "Reference Data" sub tab, I have created a list named "regions" which contains a list of districts.

If I enter the url into the browser "homepage/svi-datahub/admin/lists?name=regions, the list "regions" is returned as json.

So, now I try to get a hierarchical list as json via an API call. This hierarchical list has been created in "Reference Data" sub-tab, tab Hierarchies.

Thanks

Re: What's the API call to retrieve hierarchical reference list

rudfaden — Tue, 14 Mar 2023 11:41:25 GMT

Your question barly makes senese. Please rewrite it with a minimal working example.

Re: What's the API call to retrieve hierarchical reference list

uncle_ho — Tue, 14 Mar 2023 13:38:16 GMT

No worries, I have updated the query.

Re: What's the API call to retrieve hierarchical reference list

gwootton — Tue, 14 Mar 2023 13:46:27 GMT

So when you call svi-datahub/admin/lists?name=regions the items in the response are your districts which could be retrieved using svi-datahub/admin/lists?name=district_name. Would you be able to read the response from the first call and then iterate through those?

Edit: To answer your question, I don't think there is a separate API call that will return a flat response.

Re: What's the API call to retrieve hierarchical reference list

uncle_ho — Tue, 14 Mar 2023 15:50:06 GMT

Thanks much, that helped .../svi-datahub/admin/lists?name=region_districts_sub_lev did the trick.