Skip to main content
Question

Calling an API from custom field

  • August 4, 2023
  • 5 replies
  • 81 views

Forum|alt.badge.img+10

Hello all,

 

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

 

Any advice please ?

5 replies

Forum|alt.badge.img+4
  • Do Gooder (Customer)
  • August 4, 2023

try using v.po_ref_number in arguments


Forum|alt.badge.img+10
  • Author
  • Hero (Customer)
  • August 4, 2023

Hi Imalka

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

 


Forum|alt.badge.img+4
  • Do Gooder (Customer)
  • August 4, 2023

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

SELECT contract FROM purchase_order WHERE order_no = :po_ref_number


Forum|alt.badge.img+10
  • Author
  • Hero (Customer)
  • August 4, 2023

Hi Imalka,

I tried that and then got the original error message

 


Forum|alt.badge.img+4
  • Do Gooder (Customer)
  • August 4, 2023

do you have po_ref_number in posting_proposal_head?

can you explain the real requirement?