How to specify value of key at run time

[ashwini.mali]

Hii
i have design job for extract table data from pdf and store into excel file and then i want call rest api Parameterized Post method And passed paratemert in body field .
how can passed value for key run time

[Rahul_Unnikrishnan]

Hello @ashwini.mali

Does that mean you need to pass some value during the execution and user need to enter the value manually?

If yes, you can use a custom input activity.

Custom Input

Thanks

[ashwini.mali]

Not Manually .i Have to calll Rest API Parameterized Post Method And Pass paramameter In Body Field For that That Key Is Fix ,Only Value is changed During Execution Time.Attach screenshot of my excel file In excel Column name is fixed only row data is entered at excecution time

[ashwini.mali]

Issue Resolve But When i call rest Api Post Method getting error
Status code 500

[Tapan_Behera1 (Tapan Behera)]

Hi @ashwini.mali

find the screenshot

Here I have used json, but you can pass the column value to your respective json key.

Regards
Tapan

[ashwini.mali]

hii,
Im Assign Value like below
DT.Select(“[Column1]=‘tmsbillno’”).ElementAt(0)(“Column2”).ToString
use Build data table Activity so the data in table column wise

[Tapan_Behera1 (Tapan Behera)]

Okay @ashwini.mali

you just assign these values to the json Key:

e.g

Jsonobject(“JsonKey”)=“your data table column value”

[ashwini.mali]

how ,
please give example

[Tapan_Behera1 (Tapan Behera)]

@ashwini.mali these are the steps to follow

1. Create the JsonBody first

2. Then pass the json body in httpRequest activity body property

this a example of orchestrator start job api where I am using post method to start job in orchestrator

[ashwini.mali]

hii
I try assign variable like above But getting error
Please guide me to Assign variable

[Tapan_Behera1 (Tapan Behera)]

@ashwini.mali could you upload your workflow here by putting some testing data?

[ashwini.mali]

Hii
Getting Error Json to String Conversion
How to convert string to json

[Tapan_Behera1 (Tapan Behera)]

use deserialize json activity for that

[ashwini.mali]

used Deserialized Activity to convert string ti json but getting error

[Tapan_Behera1 (Tapan Behera)]

your file contains json array so please use this activity to convert

[ashwini.mali]

used Deserialize JsonArray activity but still error is not solved

[Tapan_Behera1 (Tapan Behera)]

Could you upload your workflow here including jsonfile?

[ashwini.mali]

how can upload workflow means which file ?

[Tapan_Behera1 (Tapan Behera)]

.xaml file and json file both…

[ashwini.mali]

kindly checked attach file
webApiParameter.json (419 Bytes)
Main.xaml (13.8 KB)