Hi All,
New to NetSuite here! I am t...
# generala
Aqueel Ahmed
09/14/2021, 8:43 PMHi All,
New to NetSuite here! I am trying to use SOAP APIs to pull all the transactions in netsuite to our internal data lake I can get all the consolidated transactions in the transaction table, but I am having trouble getting line level details. So I can get the a consolidated JE for example but not details of individual line items that make the JE. Any ideas on how to get those. What tables would have that information?
b
battk
09/14/2021, 8:46 PMshaer the request you are using in #C2K2RJNAC
a
Aqueel Ahmed
09/14/2021, 8:49 PMThank you!
b
battk
09/14/2021, 8:51 PMemphasis on sharing the request
a
Aqueel Ahmed
09/14/2021, 8:59 PMI did thank you, Didn't know the channel existed
b
battk
09/14/2021, 9:24 PMas in the request that was sent to netsuite
battk
09/14/2021, 9:24 PMwith the details of the soap envelope
a
Aqueel Ahmed
09/14/2021, 9:58 PMOh I am using cdata for it so they are handling all that. I just have to pick the tables i want and that is about it. sorry not an expert on netsuite or soap apis at all
b
battk
09/14/2021, 10:13 PMsuitetalk doesnt represent data as sql tables
battk
09/14/2021, 10:13 PMclosest are saved searches, which represent rows and columns
battk
09/14/2021, 10:14 PMbattk
09/14/2021, 10:14 PMfind the logs of your request and share there
a
Aqueel Ahmed
09/15/2021, 6:26 PMIts not really a question about how to do. I am trying to get what needs to be done. in cData i could go and add tables to replicate in the internal data lake '
Aqueel Ahmed
09/15/2021, 6:26 PMmessage has been deleted
Aqueel Ahmed
09/15/2021, 6:26 PMI could for example get the JE by getting
Aqueel Ahmed
09/15/2021, 6:26 PMmessage has been deleted
Aqueel Ahmed
09/15/2021, 6:27 PMThis table however does not have line level details
Aqueel Ahmed
09/15/2021, 6:28 PMCopyToPstGress_S_2021-08-26-15-52-32.log
Aqueel Ahmed
09/15/2021, 6:28 PMHere is the log for getting the table "Transaction"
b
battk
09/15/2021, 8:48 PMYou probably want to ask cdada then
battk
09/15/2021, 8:48 PMYou would ask a netsuite channel about netsuite help
battk
09/15/2021, 8:49 PMWhich in this case requires logs from netsuite
3 Views