Taking data from excel sheet and inputting it


I am trying to get data from an excel sheet that is in key:value (dictionary) format into the Http Request API but I cannot seem to figure it out

Any ideas?

Thank you

Hello @JCEY

Does that mean you are reading an excel and converting it to a dictionary variable? Then using the key-value pair to use in the https API request?



The excel is in a dictionary format and I’m looking for a way to extract the key and then put it into https api request

This is a example of how my excel looks like

I am trying to pull the name which is the key and put it into http to call out 123

Check the attached XAML.

Main.xaml (8.9 KB)

I cant open it

It says document is invalid

Do you have stuido installed?

yes i tried to open it in studio and it said that the document is invalid

Use this project file with the XAML. copy both in same folder and then open it.
project.json (1.5 KB)