Validation Rule

[harshkumar1]

When we are loading data through data source in json file format, is there any rule or policy we can write in staging table so that we can check all the values in the file is correct or not, format of attribute is correct, we are not getting any empty mandatory field, for any attribute like empNum we are getting equal number of digit value for all. Is there any way to do these things without script or less script.

[Ankur Bawiskar]

@harshkumar1 

nothing available out of the box for this

You might have to take custom solution approach for this

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[Tanushree Maiti]

Hi @harshkumar1 

OOB it is not available.

Refer:Creating a JSON File Data Source and a Scheduled Data Import