Can you be more specific in your ask. I don't know what you mean by "repo's script of CI/CD", "use code" and "JSON , PowerShell, CLI"?
Are you asking about how you should store your CI/CD scripts? If so then it is up to you. If you're using a CI/CD tool like Azure DevOps then they will basically tell you how to do it. For Azure DevOps you'll likely be using YAML as a file in your solution.
If you're using Visual Studio's publish feature then when you set up publishing it'll ask you for info and then store that in files in a publishing folder of your app that would also be in source control.
If you're sticking solely with Azure and trying to CI/CD from it then I don't think it needs anything other than your repo and it'll figure things out from there. Any configuration would have in Azure Portal.