Try specifying the data-threshold attribute:   Creating HTML Forms with Dynamic Data > Attributes https://documentation.sas.com/doc/en/pgmsascdc/v_029/jobexecug/p0zom39gtjeq29n17jspywuzebvv.htm   Performance in your Web browser will likely degrade as the number of items in the widget increases.   Vince DelGobbo ex-SAS R&D   ... View more

Glad to hear you are using the JES web application!  That’s a good question!   According to the documentation, if your dataset is loaded to a caslib and is promoted, you can use a rest API call to retrieve the distinct values of a column.  The details for this can be found here: https://developer.sas.com/apis/rest/v3.5/Compute/#get-distinct-values-for-a-column   In your JES HTML Form, you could make the API call and then convert the REST API’s response JSON to a html dropdown using javascript.  An example of how to do something very similar to this (using the Viya Reports API to dynamically retrieve a collection of reports) can be found in this article:   https://communities.sas.com/t5/SAS-Communities-Library/Creating-JES-Prompts-and-Output-Using-the-Viya-Reports-API/ta-p/664314   Using these to pieces: The CAS Management API to dynamically retrieve the columns distinct values Using the output of the API rest call as the values in a HTML dropdown You should be able to create the functionality you’re looking for!    And once you have it, you will have the beginnings of what would be a great SAS Communities Article!   Mike ... View more

@saifislam wrote:     We are told Viya 4.0 is not going to read .json file- is that correct- if so, what's the solution Where did you get this information? It's very rare for SAS to deprecate features as backwards compatibility is one of their selling points. Not saying you're wrong but it seems weird to deprecate something like this so first, let's check that assumption.    Your code seems like something that is using JSON as a data source within a customized visual in a VA dashboard? When you upgrade you will need to redevelop any customized portions which is standard when you customize out of the box software.  ... View more

Maybe ask in the Viya community? https://communities.sas.com/t5/SAS-Viya/bd-p/about-viya ... View more

You didn't receive a response because your question is probably much too terse. Please tell us more about the data you have and the process you want to use. ... View more

Create a view with names SAS can use? SAS table and variable names are limited to 32 characters, though I believe that's going away in 9.5/next version. You can also try looking at the VALIDVARNAME option, that may help with special characters, but won't help with table names that are over 32 characters. ... View more