I'm hitting a block when building this script and I was hoping for some advice.
My script does this:
- Takes an input from me via Display Input Dialog in the form of a question variable
- It then fires an API request with this question
- Gets a response
- Converts from JSON to Text
- Saves to a list
- Adds list to Excel
- Loops
What i'd like to do is automate part 1, i'd like to give it a list of the questions i want it to ask, if it can:
- Read from a list of questions and take the top one
- Do steps 2 - 6
- Delete the one it just asked
- Step 1 repeats
Any advice greatly appreciated, thanks.
Added some steps above to the current script.