Yes i haven’t written the api itself, we (or at least most of my direct coworkers) also don’t have direct acces to the raw database in production.
All the documentation was intended for python and i was provided an jupyter notebook with some python demos. Giving chatgpt the documentation expecting it to understand it is not recommended.
Seems one of of my higher ups is biased againt python “They use that in school as a starter language” (as if that makes it inferior) But there seems to be more in house experience with powershell and others have to be able to continue my work if i quit or fall sick for long.
So the first thing i gave to chatgpt was a selected few snippets of the python notebook and asked to show how i would do the exact same thing in poweshell.
Then i asked what i would need to do more to make this a final working script. (With a very basic goal).
Once that is working i could easily provide a new instance of chatgpt with either full code or the function/part i was working on and provide it with information on what the next step is or what i am trying to do. If i get an error i provide it with that and ask what might cause it.
I have enough coding affinity to notice if it hallucinates, Most of my personal problems writing code is that i am very bad at syntax and not great at spelling.
Chatgpt very often provides long stretches of non functional code because it doesn’t fully understand the context of what i am trying to do but in the middle of that code i may find an excellent for loop function that does successfully implement the logic for that part. i then copy that part with minor changes.
I recognize that for you most of my code counts as boilerplate stuff. But id have a frustrating experience writing it my self.
I rather explain the logic i need in a prompt, and i find it very fun to then puzzle all the snippets together into a coherent script.
I estimate i am on average slower then a full dev but i have the massive benefit of being my own client. The things i am automating are things my team constantly have to do manually trough crapware. Therefor i fully understand what exactly needs to be done, as opposed to us asking the in house devs to check options to see if maybe x y z can be done easier.
Those in house devs are also at my disposal if i get stuck or have questions, some parts are code snippets directly provided by them.
Edit: thats gpt4, i started with 3.5 and its helpful but 4 is such a massive jump i cant take 3.5 seriously anymore.