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
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.
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
Issue Resolve But When i call rest Api Post Method getting error
Status code 500
find the screenshot
Here I have used json, but you can pass the column value to your respective json key.
Im Assign Value like below
use Build data table Activity so the data in table column wise
you just assign these values to the json Key:
Jsonobject(“JsonKey”)=“your data table column value”
please give example
@ashwini.mali these are the steps to follow
Create the JsonBody first
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 could you upload your workflow here by putting some testing data?
Getting Error Json to String Conversion
How to convert string to json
use deserialize json activity for that
your file contains json array so please use this activity to convert
Could you upload your workflow here including jsonfile?
how can upload workflow means which file ?
.xaml file and json file both…