Taking data from excel sheet and inputting it

Help Studio
1

Hi,

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

2

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?

Thanks

3

Hi,

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
image

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

4

Check the attached XAML.

Main.xaml (8.9 KB)

5

I cant open it

It says document is invalid

6

Do you have stuido installed?

7

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

8

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