Question Re: How to use parameterized external service programatically in CAP node.js in Technology Q&A

How to use parameterized external service programatically in CAP node.js

KM11 — Sat, 04 Feb 2023 07:31:32 GMT

Hi Experts

I need to programmatically call an external parameterized service in my cap application.

External service url:

/servicename/ABC(Key=‘123’)/Set

CAP service.cds file:

entity Abc(Key:String(3)) as projection on ext.ABC;

CAP Node.js call: srv.run(SELECT.from(‘Abc(Key:’123’)’)); // tried passing in single quotes and template string both

This created a url like: dest.servicename/?$select=Key

Note: The external service is made out of calc view with parameters

Kindly help. david.kunz2 gregorwolf

Thanks

Kanika

Re: How to use parameterized external service programatically in CAP node.js

david_kunz2 — Mon, 06 Feb 2023 08:32:02 GMT

Hi kanikamalhotra ,

"Key" is a reserved keyword, so it must be escaped and you don't need quotes around the value.

SELECT.from('Abc(![Key]:123)')

Best regards,
David

Re: How to use parameterized external service programatically in CAP node.js

KM11 — Mon, 06 Feb 2023 09:16:53 GMT

Hi david.kunz2

Thanks for the reply!!
Well, I wrote 'key' hypothetically to avoid using exact names as my service.

Passing with and without quotes around the value also, didnt work.
Finally, I found the cqn way of passing which is finally making the correct URL '/ABC(Key=‘123’)/Set'.

Would be happy to try any other way of achieving the same 🙂

SELECT: { from: { ref: [{ id: "Abc", where: [{ ref: ["key"] }, "=", { val: `${value}` }] }, "Set"] }, columns: [ { ref: ["*"] } ], where: [{ ref: ["fieldname"] }, "=", { val: `${value}` }], } };

SELECT: { 
    from: { ref: [{ id: "Abc", where: [{ ref: ["key"] }, "=", { val: `${value}` }] }, "Set"] }, 
    columns: [ { ref: ["*"] } ], 
    where: [{ ref: ["fieldname"] }, "=", { val: `${value}` }], 
  } 
};

Re: How to use parameterized external service programatically in CAP node.js

sairampadarthi — Thu, 13 Apr 2023 12:25:05 GMT

Hi kanikamalhotra,

Iam also working on same requirement now. can you please share me code snippet once.

Thanks in Advance,

Sairam