Hi , I am using Suiteql rest api. This is what i h...
# general
s
Hi , I am using Suiteql rest api. This is what i have done and it works fine when I hardcode the value in the where condition. my question is instead of hardcoding the value in the query where condition, how can I pass the value as a placeholder
Copy code
https://{url_account}.<http://suitetalk.api.netsuite.com/services/rest/query/v1/suiteql|suitetalk.api.netsuite.com/services/rest/query/v1/suiteql>"
headers={
    "Prefer":"transient",
    "Content-Type":"application/json"
}
query = """select * from Transaction where createddate > PLACEHOLDER HERE """  ====> Question here. How to pass the value in the placeholder
body=json.dumps({"q":query})
response=<http://client.post|client.post>(url=url, data=body,headers=headers)
b
rest web services do not support prepared statements
you will have to build your query string yourself
s
thank you. I constructed the query string and now it works fine.