Skip to main content
Question

Calling an API from custom field

  • Aug 4, 2023 11:54 AM UTC
  • 5 replies
  • 110 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)
  • Aug 4, 2023 12:08 PM UTC

try using v.po_ref_number in arguments


Forum|alt.badge.img+10
  • Author
  • Hero (Customer)
  • Aug 4, 2023 12:12 PM UTC

Hi Imalka

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

 


Forum|alt.badge.img+4
  • Do Gooder (Customer)
  • Aug 4, 2023 12:16 PM UTC

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)
  • Aug 4, 2023 12:18 PM UTC

Hi Imalka,

I tried that and then got the original error message

 


Forum|alt.badge.img+4
  • Do Gooder (Customer)
  • Aug 4, 2023 12:49 PM UTC

do you have po_ref_number in posting_proposal_head?

can you explain the real requirement?