https://netsuiteprofessionals.com logo
Join Slack
Powered by
Hi All, I am working on NetSuite Integration with ...
# suitetalkapi
s
Hi All, I am working on NetSuite Integration with third party application. I am trying to use NetSuite rest apis to sync clients netsuite data to a third party application database. In this process, I am wondering how do I fetch the deleted records from netsuite using rest api and update the third party application database. Has anyone here worked on NetSuite integration with third part applications? If so, kindly help or reply, i am kinda stuck in my work and exploring other integration options like using soap which I feel is very complicated.
b
probably will need to use the SuiteQL Queries Through REST Web Services related features
Deleted Records is not available in the REST API Browser
s
Hi @battk Thanks for your reply, I was infact able to fetch the deleted records through suiteql, but am still having doubts with the response that I receive
Just curious to understand as I am new to this integration domain, what is the best way to approach the netsuite integration with third party application to fetch the client's data from netsuite and sync with third party application
Just to give you more information about my approach, I am using an ESB like platform, to make the rest calls to fetch the data from netsuite at regular intervals
I just want to validate my approach, kindly give your inputs,thanks
b
use whatever tool is available for your platform
s
I didn't understand, can you please help me understand
b
there are lots of integration choices in netsuite, pick whichever you are most comfortable with and can do what you need it to do
s
ok, we are more focused on using the suite talk rest api or soap approach for fetching the data from netsuite
the suiteql api returns the deleted records response also, but it has the internal id/external id missing in the response
b
you may have to use soap then]
s
ok
thanks for your time @battk soap looks very complicated to me right now
but still exploring both the options
anyways thanks for your replies
b
soap generally requires tool support
s
tool support as in? the ESB you mean?
I am using WSO2 and its inbuilt netsuite connector is not good, it doesn't support most of the operations, so I need to figure out a way to make it work otherwise
b
yes, keep in mind middleware like ESBs tend to be a very broad category
s
using rest apis, I kinda integrated and done a poc to fetch QBO data and they were pretty straight fwd as they primarily support RESTA
but with netsuite, making soap calls in the esb, I am finding a bit challenging
as I do not have much experience working on soap
Hi @battk
I am following a solution shared by you on the netuiteprofessionals questions page
Inspite of looking into this for hours, I am still facing the invalidSignature error frm the audit logs
I am not able to figure out exactly where I am going wrong
can you please help
b
What does your postman request look like
s
Can I send you the screenshots?
message has been deleted
b
account id should match the value from https://system.na0.netsuite.com/app/webservices/setup.nl, including capitalization
s
It worked 🙂
Thanks a lot @battk
I have been struggling to figure out the issue since many hours
you really saved my day
b
keep in mind that generating the xml used in the body of a soap request by hand is generally wrong
most programming languages have tools to generate soap clients that can make the requests for you
s
ok sure, I will keep that in mind while implementing, thanks for the advice
Open in Slack
PreviousNext
Powered by