Question

Calling an API from custom field

  • 4 August 2023
  • 5 replies
  • 39 views

Userlevel 3
Badge +10

Hello all,

 

I am trying to do the following but keep getting the error message shown below :  

 

Any advice please ?


5 replies

Userlevel 1
Badge +4

try using v.po_ref_number in arguments

Userlevel 3
Badge +10

Hi Imalka

When I did that, I now get this error message :

 

Userlevel 1
Badge +4

can you use a select statement for this. like below.

SELECT contract FROM purchase_order WHERE order_no = :po_ref_number

Userlevel 3
Badge +10

Hi Imalka,

I tried that and then got the original error message

 

Userlevel 1
Badge +4

do you have po_ref_number in posting_proposal_head?

can you explain the real requirement?

Reply